Heidi's Journal
My Podcast Link
05/02/2011 12:38 #54202
Graduation!Category: school
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:
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.
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.
04/30/2011 16:08 #54183
Poodle nestCategory: pets
04/29/2011 17:25 #54175
Office chicksCategory: 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!
That is a such a cool work environment!
04/29/2011 12:23 #54173
QuarriesCategory: 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!
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.
You lead an interesting life. There's a part of me that is jealous.
Congrats! :)
I am not done yet... Going to chug along a bit more before I collapse..
Yea! Done! One totally cheezy inputbox, but the rest is pretty professional.
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! :-)
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:::
Yep, it worked! Now I'm getting two copies of the form and two blank pages. Soooo close!
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 :-)
Is this related: :::link:::
The access is pretty much instant...
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.)
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.
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..