Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How can i identify what data has changed on an Access 2003 form

Avatar of JulesII
JulesII asked on
Microsoft AccessVisual Basic ClassicMicrosoft Development
7 Comments1 Solution382 ViewsLast Modified:
Hi,
I'm a bit stuck on this issue and wonder if you could help?  we have field workers who do not have access to the companies Servers and need to be able to download data from the live SQL Server datbases and work with the data offline on their tablets and then update the live database again at the end of the day.  If is not possible for them to be logged on at all times due to issues with site locations etc.  I would like to be able to trap any records that get changed during the day, probably on only a handful of specific tables and then to be able to run an update query to push the data back into the live system when they log back on.  I'm imagining something that would know when a form has been updated and which field in an underlying table has been changed.  I think I would then record that change to a table which would hold the name of the table and field to update along with the value to change.  I'm stuck on knowing how to identify the control that has been updated.
Any help as always would be very much appreciated
ASKER CERTIFIED SOLUTION
Avatar of omgang
omgangFlag of United States of America imageIT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers