911 the strangest thing happening

[bizlink]

I created a data base...I created the forms using the wizard....it worked perfectly....made 2 backups of it to be safe! I added a command button to one form to input data in another form......no problem....works like a charm. test it, tested it again, tested about 20-30 times. No problem! then all of the sudden I'm getting an error message when I try to use the command button.....mind you I didn't change, add, delete except maybe one thing I changed the sort order. But the wierd part is I made to back ups (prior to the problem and tested them both) and now both of the back ups are creating the same error. Here is the error I'm getting.....

The expression OnClick you entered as the event property setting produced the following error: Error accessing file. Network connection may have been lost.

*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event or macro.

I should mention that I created the command button using the wizard as well.....so I didn't mess with anything. I should also metion that I'm not on a network....just a single computer.

HELP!!!!!!!!!!!!

 

[jeff_i]

Where is the database stored? Are you running out of disk space??

Have you done a compact and repair? If you havent make a backup and try to run a compact and repair.

 

[bizlink]

Yes

Yes I made backups, I ran the compact repair....I have the database on my hard drive, I am running low on space but I still have 125mb left and the data base is only 700k

 

[Rakier]

This has happened to me before also. For some reason, the command button becomes disassociated with the VBA code for it (or at least that's what's happened to me).

Open the form in design view and go to the properties of the offending command button. Click on the event (I'm assuming On Click) for the button. If it's the same problem, it will not have anything in the event yet. Click the ... button and go to the code builder. This should pop you into the VBA editor and you should see your code. Save it and now go back to the properties view of the command button. It should say [Event Procedure] there. Try the button and it should work.

Don't know why it happens, but its happened to me a few times.

HTH

 

[bizlink]

Thank you

I gave that a shot........no luck.....I have simply scrapped everything and started over.....everything is working fine now..
(fingers crossed). I also reinstalled Access!


I'm trying to do something else now.......

I have one form/table for insurance companies (called: Insurance Company Info) it has ins. co. adress, phone, and a few other pieces of data unrelated.

I have the insurance company as a combo box set up to retrieve from another form/table called (insurance company list)...I would like to have all of the data from the Insurance company list form go into the appropriate boxes on the Insurance Co. info form.

Like the address, phone, zip, etc.

Is this possible?