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 / December 2003

Tip: Looking for answers? Try searching our database.

Conditional Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jacquie - 31 Dec 2003 20:34 GMT
This macro works without the conditions, but once I put
the conditions it, it just stops at the first step. If the
copy is 0, I want to add a new record and set the copy
value to 1. If it isn't, then I want it to sort. I can
send a screen shot of the fuller macro if you send me your
email (this newsgroup doesn't allow attachments or pics).
Any ideas?  Thanks!!

---------

         openform
         gotocontrol          copy
[copy]=0  gotorecord           new
...       setvalue             copy = 1
...       stopmacro
         runcommand
Ken Snell - 31 Dec 2003 21:01 GMT
Post the macro's listing here...what you've listed isn't complete, and it's
not clear what you're trying to do.
Is [copy]=0 supposed to be a condition? Be more specific about the different
parts of the macro (condition, action, arguments, etc.).

Signature

      Ken Snell
<MS  ACCESS MVP>

> This macro works without the conditions, but once I put
> the conditions it, it just stops at the first step. If the
[quoted text clipped - 12 lines]
> ...       stopmacro
>           runcommand
 
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.