troubleshooting Question

Using a Bound Form and VBA for Recording Handling

Avatar of pwdells
pwdellsFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution486 ViewsLast Modified:

I have run into a bit of a dilemma.  Usually, I avoid using forms with fields that are bound to fields in a table.  I started off with using VBA to create a record, insert a UserID and StatusID, then returen the primary key into a form field called REQID.  That would happen in the background.  

Then the user would fill in the rest of the fields that were date, double, and text datatypes.  I was running an UPDATE query to update the recenty created record, with the new entered info.  However, this form now needs to be used globally (around the world) - new requirement. I have been fighting with the European date and number formats for a week.  The only thing that works in both US and Euro environments is to just make the fields bound to the table.  (Which I don't want to do - but don't have time to fight it. - I am over deadline now.)

So, that is the back story.  This is what I am looking to do now.   After the user enters the request information and hits the Save button, VBA runs a check to make sure the fields are entered in the correct format and are not null.  The fields are now assigned to fields within the table.  But when I run the code to save, the data does not save into the table.  

I don't feel that this impossible.  I am just a bit overwhelmed with the constant return of failure.

Any ideas?
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros