Stop Access from automatically coming to the foreground?

[Endlessknight]

Greetings all,

I wrote a VBA program in MS Access that generates and saves dozens of PDF reports. The program works great but every time a report is saved Access jumps to the foreground, preventing me from working.

Is there anyway to stop this?


Thanks in advance for any help offered.

 

[kang23]

Not sure if this is what you mean but you could ensure that screen updating is disabled while the code executes

Applition.ScreenUpding =False

Just ensure you set the same line of code as true before the code ends

 

[Endlessknight]

Not sure if this is what you mean but you could ensure that screen updating is disabled while the code executes

Applition.ScreenUpding =False

Just ensure you set the same line of code as true before the code ends

Thanks for the input but apparently ScreenUpding is an excel only function

Access has Application.Echo False but that just stops the report from previewing. It doesn't stop the program from jumping to the foreground