In the navigation pane there is a macro "mcrImportDetails". I open that in design view and see the columns Macro name, Conditions, Action & Arguments. The macro I want to look into in the Macro name column is "Import_DailyDetails" - how do I see this in design view? Not sure if my info is vague, please let me know if I can provide any other information. I know that the macro is importing an Excel file
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have tried using:
However it says you need to insert the Macro name however I do not know what the embedded macro is called in order to refer to it
When you are building or reviewing the macro, Access does not permit access to any other part of your database and there are lots of reasons why it would be nice to have that ability.
The only help I have found is to have the VB window open so I can check the value of variables and test expressions while I'm building the macro conditions
For example, say I have a Table (called myTable), that has 2 fields, ID, myFieldA. I want to make a Form that has an Unbound text box (say, boxA). Then, I want to make an Embedded Macro that queries myTable, using ID as the criteria field, so that the query would return only one record.
The Macro would then temporarily store the RecordSet, so that it would populate thetextbox, boxA, with the value of myFieldA from the query.
I know about binding boxA to myFieldA. I also know how to do this using VBA. But for my purposes here, I want to keep all of the form elements Unbound, and drive the user interface with queries, using only Embedded Macros.
Then I could use smarter logic for doing things such as validating that the user fills in required boxes before writing records to the table, verifying that the user intends to save changes, etc.
(I've had enough pain dealing with Access' clunky BeforeUpdate and AfterUpdate events).
Ive used the wizard to create a delete record button with an embedded macro and it looks good as it takes care of all possible scenarios.
Now, Ive been trying to encapsulate the 3 or so if then statements of the macro (exluding the error handling of course) in an if msgbox(.)=vbYes (or rather = 6) but no matter what I try I cant seem to move the end if to wrap the other If then statements
MacroName: frmLoadIns Detail : OnClick : Embedded Macro
Arguments: 2, frmLoadIns, Next,
I got this when I was entering the command to have the form start at a new record every time it is opened