Ivalid Qualifier

Resolved · Low Priority · Version 2007

Fri 13 Feb 2009, 17:24 Delegate 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?!

Mon 16 Mar 2009, 15:42 Trainer 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@stl-training.co.uk

Reagrds

Carlos

Mon 16 Mar 2009, 20:38 Delegate 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips