Data entry form turns off 2

[jpl458]

Created an app that has various lookup features, and wanted to add a simple data entry form and a form that displays the data that was entered. I created the data entry ap separate from the lookup ap, and it worked just fine. I then imported the two forms into the original ap, but the data entry displays the first record in the file. I have data entry set to yes in the property sheets. I deleted the form from the ap and created them from scratch again from inside the lookup ap but got the same results. I have checked every place for a setting that indicates data entry = no, and found none. The Lookup ap uses linked tables to SQL Server 2008\EXPRESS and I have a bit of code that relinks the tables on load of the first from. That code works fine. Made tabe for the data entry in the SQL Server database and I can see if I click the table in the Ap.

Wondering if anyone has had a similar experience, or know why data entry will not work in the first ap or what else would prevent it from running. Checked all the property sheets and File-Options and everything seems to be ok. Obviously missing something.

Thanks in advance for any help.

jpl

 

[PHV]

What is the code that open the data entry form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

The code is an embedded macro that was created by ACCESS when I added the Command Button. It's as follows;

Open Form
Form Name Coupon Entry
View Form
Filter Name
Where Ccondition
Data Mode (Tried both blank and Add)
Window mode Normal

Didn't try setting to Edit.

Thanks

jpl

 

[jpl458]

Tried setting the data mode to edit in the macro and that didn't help. So I switched to an event procedure in the button and added the following code:

DoCmd.OpenForm "Coupon DE Form", acNormal, , , acFormEdit

That dosen't do the trick. Exported the two problem form to a new ACCESS ap and they work fine. Deleted the form from the lookup ap, imported the two forms back in to the original ap and tried open them from the navigation panel, but no dice.

BTW, I previuosly deleted the Data entry forms and rebuilt them inside the Lookup ap and they worked fine until I rebuilt the command button to open the de form - they never worked right after that.

Could sure use some help.

Thanks

jpl

 

[lameid]

I only read your very last post and I assume you have tried compact and compare... try the following command line. It will remove all compiled (corrupt) code from your database. Then compact and repair and try compiling your modules.

msaccess.exe <<Your Database Path and file>> /Decompile

 

[jpl458]

Got decompile to run, recompiled (don't know if I did it correctly), but the DE form is still bad. Goint to delete it and start over, again. Maybe it will take after the fixes.

Any other thoughts welcome.

Thanks

jpl

 

[MazeWorX]

I think you may have answered your own problem

Exported the two problem form to a new ACCESS ap and they work fine

You may find the db is the issue and importing all objects into a new container will do the trick

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>