Heidi's Journal

05/01/2011 20:48 #54198

VBA?
Category: work

Ugh... almost done with this stupid access db and I need to make a form print two copies and stop having a blank second page (which may just be from imperfectly arranged fields. Here's the code:

Private Sub PrintTicketButton_Click()
On Error GoTo Err_PrintTicketButton_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection

Exit_PrintTicketButton_Click:
Exit Sub

Err_PrintTicketButton_Click:
MsgBox Err.Description
Resume Exit_PrintTicketButton_Click

End Sub

Suggestions, anyone?

It's been so long since I've done any coding! (damned tax law) My developer reference books are all in storage in PA.

tinypliny - 05/02/11 03:29
Congrats! :)

I am not done yet... Going to chug along a bit more before I collapse..

heidi - 05/02/11 02:00
Yea! Done! One totally cheezy inputbox, but the rest is pretty professional.

heidi - 05/01/11 23:24
Finally got it down to the appropriate 2 pages with no apparent reason why. I'm finishing up the daily report for the db and then I'll be able to ship it off to the client. Hopefully they won't want/need additional stuff. The weighstation doesn't have internet access (although they're considering getting a Verizon data plan) so getting into the system to make changes is rather difficult. Thanks for your help! :-)

tinypliny - 05/01/11 22:09
Something to do with formatting maybe...
:::link:::
:::link:::
:::link:::

All these are about resizing to get rid of blank pages... but who knows!

Then there is this video that I haven't seen: :::link:::

heidi - 05/01/11 21:53
Yep, it worked! Now I'm getting two copies of the form and two blank pages. Soooo close!

heidi - 05/01/11 21:34
Definitely related (and the critique of using a form instead of a report is correct)... I'll see if I can get it to work. Thanks :-)

tinypliny - 05/01/11 21:30
Is this related: :::link:::

tinypliny - 05/01/11 21:10
The access is pretty much instant...

heidi - 05/01/11 21:09
Thanks, (e:Tinypliny), but I need it now to deliver the db tonight via email. (e:Paul) - Yeah, yeah, never doing it again! (I hope.)

paul - 05/01/11 21:07
Sorry I don't touch the microsoft stuff. That being said i don't see anything in there that would make it print a second blank page. It must just be imperfectly arranged fields like you said.

tinypliny - 05/01/11 21:06
I don't know about coding... but my uni library recently bought a ton of MS Access books (I got an email about). If you could let me know which book you are looking for, I could take a look and see if I can get you access..

04/30/2011 16:08 #54183

Poodle nest
Category: pets

Cuteness!

Adrian gave Nisha a treat and then tried to take it back. She turned her head away and put her paw on his hand to
stop him from taking it.

tinypliny - 05/01/11 21:07
She is such a cutie and SO very clever!

paul - 04/30/11 18:27
They have such similar fur ;)

04/29/2011 17:25 #54175

Office chicks
Category: home

I love my office. Nisha loves chasing chickens or sitting with jill. It's very wet here. Uncle dudley's basement is flooded (no laundry for me!). A's basement flooded a couple nights ago, about 4".

tinypliny - 05/01/11 21:08
That is a such a cool work environment!

04/29/2011 12:23 #54173

Quarries
Category: work

I'm hanging out at a quarry installing some software... The weighstation has as many as 400 trucks a day, about 22 tons each truck. That's a lot of rocks.

tinypliny - 05/01/11 21:08
You were doing computer stuff at a quarry... yes, you do lead an interesting life!

uncutsaniflush - 04/29/11 23:04
You lead an interesting life. There's a part of me that is jealous.

04/27/2011 18:44 #54161

20 trolley bus
Category: travel

This bus is cute :-)

tinypliny - 05/01/11 21:09
I have never seen these buses from inside or outside *pouty pout*

metalpeter - 04/28/11 17:59
To be honest I'm not sure... I thought there where 2 buses one like that and it has like all kinds of green ads or something and then one that looks like a troly but runs on an engine ......

tinypliny - 04/28/11 00:32
Really? Does it look like a trolley inside as well? That is so cool. I don't take the 20 too often nowadays since I don't go to Weggers anymore.

metalpeter - 04/27/11 19:59
That one I think is the one that is normal bus inside not sure.... There is another one that is made up like a trolly on the inside that I have some photos from in a post from who knows when but not sure how this one looks inside at the least the roof is different.....