Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Vba

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Vba

Resolved · High Priority · Version 2010

Reply Mon 12 Dec 2011, 15:41Delegate Archana said...

Archana has attended:
Excel VBA Intro Intermediate course

Vba

I have just added the

Application.screenupdating= false

and then= true at the end of the sub routine

while running the macro but I find that the system seems to freeze and the dialogue box which asks what macro to run is frozen on the screen so the first thing that comes into your mind is that excel is frozen, but actually the macro is running!how can I get rid of the Dialogue box before the macro starts

For upcoming training course dates see: Pricing & availability

Reply Tue 13 Dec 2011, 19:00Trainer Anthony said...

RE: Vba

Hi Archana, thanks for your query. First of all, this is Excel we're talking about, yes? You posted the query in the Access VBA section and the macro dialogue box can cause problems when running code in Access.

However, if you're in Excel you should get that macro dialogue box coming up if your cursor is flashing within a subroutine and you run the code from there. If the code is attached to a worksheet control, the subroutine name may have changed and become dissociated from the control. Finally, can you paste the entire subroutine here so we can have a better look at what is going on?

Hope this helps,

Anthony

Tue 20 Dec 2011: Automatically marked as resolved.

Access articles

· A Brief Guide To Table Relationships In Access
· Microsoft Access, an Efficient Database Tool
· Protect Sensitive Access Databases With A Password
· The Benefits of Certified Microsoft Training in Access
· Access And Its Uses On The Web

Please browse our web site to find out more about
access 2003 training and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips