Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / December 2003

Tip: Looking for answers? Try searching our database.

REQUERYING FORM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AAron - 08 Dec 2003 18:24 GMT
Hello,

I'm somewhat new to Access, but have developed a runtime
application (data entry form) to put on multiple computers
in my plant. These are there to enter repair information.
I needed my forms on all the computers to update everytime
a record was entered. Hence, I was told to REQUERY with
the ON TIMER event and to save on an event, which I did.
However, when the requery takes place, one of my folks
might be right in the middle of entering data into a new
record, and the requery takes them back to the first
record. First question...is there any better way for the
forms to be updated with new data. Second, if not, when I
requery, can I have it so it leaves me in the record and
field I'm working with? Thanks much,

Aaron
Alex Dybenko - 08 Dec 2003 19:07 GMT
you can check form's Dirty property before requery:

if me.dirty then
   'do nothing
else
   me.requery
end if

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com

> Hello,
>
[quoted text clipped - 13 lines]
>
> Aaron
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.