Undefined function 'AppLoadString'

[jim68]

I have started to have all sorts of problems with my database (Access 2000) and I suspect the undlying code is a problem, but I am still a relative beginner.

At present when I use the wizard to palce a command button on a form I get the message

Undefined function 'AppLoadString' in expression

How do I go about fixing this - I do not know where to start?

Thanks,

Jim

 

[SMerrill]

Do you have any user-defined function calls by that name in your code? If your code will not compile, this may come up.

Command buttons are easy enough to do without the weezard. Perhaps your wizard is broken.

A command button is an object. In the properties of that object, choose the Event tab. In the On Click row, type "[", which will cause it to fill with "[Event Procedure]". Then a "..." (elipsis) button will come up to the right of the field. Click it. Your code window pops up with

Private Sub Command2_Click()

End Sub

This is called an "event handler" which "catches" the Click event of the Command Button object. This means that the code in here will be executed whenever someone clicks on the button.
The typical uses for a button are to bring up another form, or to bring up a report, or so. Use Docmd.OpenForm or Docmd.OpenReport like this:

Private Sub Command2_Click()

docmd.OpenReport(

End Sub

Be sure to type the left parenthesis and you will see how to use the command. --Shaun Merrill

 

[jim68]

Thanks for the advice. As far as I know I have no user-defined function calls by that name.

My wizard seems to work on other databases, but I shall try entering a command button manually and seeing what happens.

Jim