Search results

Nice job figuring it out. Makes you feel good when you overcome a challange.

Easiest solution would be to declare a form level variable at the top of the form just after the Option Compare Database with something like; Public mdtmTimeStamp as date When you click the button that launches the report, prior to actually launching the report add the following code...

What does your code look like? Does it have a counter that needs to be reset? I think we need a little bit more information. Can you post a a few lines of the code used?

I would ensure all your tables are linked correctly to your backend. Remember if you copied your backend to another directory you have to be sure the linked tables are updated to reflect the new location otherwise you're still adding tables to the wrong backend. Use the linked table manager...

I think you're looking for, If datediff("n", timestamp, now()) < 20 then From the Access Help File, these are the Time Intervals; yyyy Year q Quarter m Month y Day of year d Day w Weekday ww Week h Hour n Minute s Second

I'm at work and can't view the link so I'm going from previous experience. What I have done in this situation is to have a parent form with 2 datasheets (subforms) on it taking up as much of the page as possible each covering 50% of the area available. Then put an On_Current event of the top...

Try putting me.setfocus just above the docmd.output command.

Had to register just to offer this solution since I found it on another developer site. Try putting me.setfocus before the docmd.outputto command. For my scenerio, i was attempting to output three reports to PDF, then use another routine to automatically merge those PDFs. It would not output...