ivalid qualifier

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Ivalid Qualifier

resolvedResolved · Low Priority · Version 2007

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?!

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

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.08 secs.