Any Ideas on what is wrong?

[Steve56]

Hello all. Could someone help me or give me guidance?

I'm currently creating forms that contain macros assigned to command buttons.

These macros are only basic and open one form and close another.

I've just created a macro that opens a menu screen (a form which is customised). I intend to use this macro on the majority of my forms for easy navigation.

Now I created this macro, assigned it to a command button and tested it.

I suddenly came across this error message.

The Expresssion on click you entered as the event property setting produced the following error: Ambigious name detected: McrMainMenu_Click.

Any ideas what this means because I'm starting to get this on all my macros/forms?

Thanks for your help.

Steve

 

[Rich]

Why are you using Macros when the button Wizard will create code for you?

 

[Steve56]

Why are you using Macros when the button Wizard will create code for you?

Because on the Main Menu (form) I would like buttons to be able to open Tables.

That is why I'm using macros assigned to buttons. Sorry I didn't make that clear.

 

[Rich]

I have to ask why you're opening tables?

 

[Steve56]

So that for future use more details can be added. For now it is just full of test data.

 

[___]

So that for future use more details can be added. For now it is just full of test data.

Shouldn't you be creating user forms based on the tables for data input? Letting users open the raw tables can lead to data loss and corruption.

 

[namliam]

AND you shouldnt be using Macros but VBA!

 

[Steve56]

Well now that I have changed the macros to go to forms instead of tables it hasn't made one bit of difference. So any help which is relevant please?

Also I have never used Visual Basic to create macros. I have always been taught to record the macros.

 

[a.sinatra]

Alright, i have a firm understanding you have no idea how a database should be utilized.

• Don't use macros.
• Use a switchboard for users, you can "tie" all your forms together.

________
HIGHLAND PARK FORD PLANT SPECIFICATIONS

 

[Rich]

Have a look at some of the sample dbs in the samples folder, ask the db wizard to create one or two dbs for you so you can get some idea of a user interfaces etc.