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 / Macros / June 2005

Tip: Looking for answers? Try searching our database.

Variable field in macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
menscandidus - 01 Jun 2005 03:56 GMT
I am trying to create a macro or VB code which refers to the current field
which is selected.  Because I am trying to create a macro which will be able
to be used for different fields.  So if I have Field1 and Field2 and I am
trying to SetValue after the field has been updated.  So to put it simply as
just an example, I want to make it so that afterupdate Field1 will be changed
to 1, then using the same macro I want to have afterupdate Field2 value
changed to 1. So that I don’t have to keep reworking the same macro for
different fields (not that I am accutally trying to set the value of the
field to 1).
Thank-you for your time.
Steve Schapel - 01 Jun 2005 18:14 GMT
Menscandidus,

Try using...
[Screen].[ActiveControl]

Signature

Steve Schapel, Microsoft Access MVP

> I am trying to create a macro or VB code which refers to the current field
> which is selected.  Because I am trying to create a macro which will be able
[quoted text clipped - 6 lines]
> field to 1).
> Thank-you for your time.
menscandidus - 01 Jun 2005 19:01 GMT
Thank-you for your help

> Menscandidus,
>
[quoted text clipped - 11 lines]
> > field to 1).
> > Thank-you for your time.
 
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.