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 / Forms Programming / June 2007

Tip: Looking for answers? Try searching our database.

storing user id in continuous form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jean-Francois Gauthier - 04 Jun 2007 16:34 GMT
Hi,  I have a continuous form to search for employees.  Edits are also
permitted from this form.   What I would like to do is update the login id
for the user who updates a record on the form.  

I have done the following:
in the before update of form frmemployeesearch

me.useridupdate = forms!invisibleuserid.userid

invisibleuserid is a form that is invisible to the user, but that stores the
user id after the login happens.  I am using this form to update the user id
on records.

as for my continuous form, this is working, however if I edit one record,
the useridupdate field is updated for all the records rather then just the
record on the continuous form that I have updated.  Is tehre a way to have
this coded so that it only updates the useridupdate field on the record that
has been edited on form frmemployeesearch?

Thank you.
Lynn Trapp - 04 Jun 2007 17:01 GMT
you need to make sure that your useridupdate field is bound to a field in
the table behind your frmemployeesearch.

Signature

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

> Hi,  I have a continuous form to search for employees.  Edits are also
> permitted from this form.   What I would like to do is update the login id
[quoted text clipped - 19 lines]
>
> Thank you.
 
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.