apploadstring

[WStover]

I am very new to access, but have a good working knowledge of the other Microsoft platforms.

I am building a database that is to house inventory. Eventually i want this to be used by several people to input and search for data.

While building a form I put a command button in to save the data entered onto a table. When I did this a prompt appeared:


I then select "ok" and the wizard appears. This prompt appears upon each additional selection until I selected finish. The button does not work. I have been trying to remedy this all day to no avail.

[June7]

You created a VBA procedure behind form with the button? Did you select [Event Procedure] in the button property? Or is this an [Embedded Macro]?

Why do you need this? Is this form bound to table - does it have anything in RecordSource property?

[moke123]

A few things on google said it may be caused by problem names in tables\fields.
Another said to import all your tables,forms,etc into a new Database.

[WStover]

I haven't gotten in VBA yet. I tried to code the button myself by going through the properties, but I dont have enough knowledge establish the command manually. It isn't an embedded macro. The form is to be used as a platform to input new data without accessing the database itself.

[WStover]

I will look into it more tomorrow, I am surprised there isnt more out there on this issue.

[June7]

What do you mean by 'without accessing the database itself' - not opening a table?

If it isn't [Event Procedure] nor [Embedded Macro] then has to be calling a custom function and that would be VBA code.

We really don't know what the issue is because don't have enough information. You have not provided any code for analysis. If you want to provide db, follow instructions at bottom of my post.

[orange]

Please clarify the following.

It isn't an embedded macro. The form is to be used as a platform to input new data without accessing the database itself.

I am surprised there isnt more out there on this issue.