Stop Access from automatically coming to the foreground?

Endlessknight

New Member
Joined
Oct 28, 2016
Messages
36
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

kang23

New Member
Joined
Mar 6, 2019
Messages
9
Not sure if this is what you mean but you could ensure that screen updating is disabled while the code executes
Code:
Applition.ScreenUpding =False

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

Endlessknight

New Member
Joined
Oct 28, 2016
Messages
36
Not sure if this is what you mean but you could ensure that screen updating is disabled while the code executes
Code:
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


 

Watch MrExcel Video

Forum statistics

Threads
1,108,709
Messages
5,524,433
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top