Recent content by tim1982

Woohoo! Thank you, sir. It appears to be working. (This will save me some serious time when printing file after file. I used to have to re-open each dialog box to make sure I was printing the newest updates.) Tim

Hello, From a Form where I input information to be printed, I always have to re-open the form in order to print (otherwise, it doesn't print the most recent information added.) Is there a way to get my VBA print command to create a report to print with the most recent refreshed information...

Worked! Thanks Bob. The worst part is that I remember reading a similar description in the book I learned Access from, but I didn't understand what it was saying without seeing the pictures. Oops. Thank you.

Hi, I'd like to have multiple lines displayed in a subreport for each entry, for example ------------- Description PartNumber EntryNumber Delivery Date Comments ------------- Description Part Number EntryNumber ...etc I think this should be...

AutoExec works well. Thanks Paul, Tim

Is it possible to open a report on startup? I know it's easy to open a form on startup, so I assumed it's the same for reports, but no no no. Any tricks?

Hi Bob, I tried what you recommended, but it gave me a few errors. However, I did figure a way around this problem by simply closing the report when I open the edit form, then re-opening it once I close the edit form.... this way, it re-opens after I've made my changes, and of course the...

Ahh! That makes sense. I just assumed I had to keep adding, not subtract. Thanks, Bob. I guess my only little concern now is that the report doesn't reload the data I've just inputted... Is there a way to have a "refresh" button on the report. Beyond that, is it possible to have the macro...

OK, it opens to a new record just perfect... However, when I close the dialog box, it still comes up with an error that the object/form isn't open... It's redundant, since I can open a new entry, but is there something I did wrong to make this error to still appear? The errors (there are...

Wow, fantastic. Thanks again, Bob.

OK, I've noticed that if I have the form open already, the "GoToRecord" will go to a new entry... However, I wanted to have it open in a dialog box opened individually each time so you can only see one record at a time.... with this setting, it won't go to the new record and says "object form...

Bob, Thanks for the quick response. I tried adding a "GoToRecord" action, but it gave me an "object not open" message... OpenForm----- Enter/Edit Orders, Form, , , , Dialog GoToRecord--- Form, Enter/Edit Orders, New, Any further help appreciated... I'll also think about changing my Form...

Hello, I have a few openform buttons that I'd like to open on a "New" entry.... I've tried entering new in the where clause of the macro action, but it doesn't seem to be working like this... Action Arguments OpenForm Enter/Edit Orders, Form, , [OrderID]=[New], , Normal Much...

Haha, excellent. Thanks a lot, Bob.... Now if I need 10 copies of something, I'll look like I really know how to code in VBA.

Hello, I have a WorkOrder Print Button in a form that I want to print TWO copies instead of the standard one... Could someone help me with where I need to add to my VBA. Private Sub PrintWorkOrders_Click() DoCmd.OpenReport "WorkOrders", PrintOut, , _...