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 » Ivalid Qualifier

	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

Ivalid Qualifier

Resolved · Low Priority · Version 2007

Reply Fri 13 Feb 2009, 17:24Delegate Edward said...

Edward has attended:
Excel VBA Intro Intermediate course

Ivalid Qualifier

I am using the

Application.DisplayAlerts = False

function. The code won't work. I get a Compile Error saying: Invalid Qualifier.

When I debug the code this line (Application.DisplayAlerts = false) is highlighted. So it looks like "Application" is not a valid object within the scope....

Huh?!

For upcoming training course dates see: Pricing & availability

Reply Mon 16 Mar 2009, 15:42Trainer Carlos said...

RE: Ivalid Qualifier

Hi Edward

Sorry for the delay.

This does sound weird. The Application.DisplayAlerts = False command is standard.

Is there any chance you could e-mail me the workbook with the code and running instructions, so I can run it and observe the error as it occurs. You may need to change any data that may be deemed secret.

Send it to

carlos

Reagrds

Carlos

Reply Mon 16 Mar 2009, 20:38Delegate Edward said...

RE: Ivalid Qualifier

Hi,

I reallised what the problem was. I had defined a variable also called Application which screwed it up! I change the variable to "Applicatn" and the displayalerts method worked fine. thanks.
Ed

Access articles

· How To Filter And Sort Data In Access 2010 Tables
· How To Use Concatenation In Access To Create A Custom Lookup
· An Introduction To Queries In Access
· How To Create Your Own Access 2007/2010 Navigation Pane
· Get To Know The 3 As: Access Accuracy Achievement

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

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips