D
Douglas J. Badin
Can Macros be created with Code? If so, how?
I am using Access 2002 and probably an Access Project (.adp) connected to
SQL Server 2000.
Ok, I have seen this in replies to similar questions,
- "Why do you want to?"
- "If you can write code, why do you need a macro?"
Not that the replies answered the question, I will satisfy your curiosities
if needed.
My client knows Macros. My client does not know VBA and has little time to
learn it and as a result, when I am gone wants to maintain the processes I
put in place with the least amount of effort especially in time critical
situations.
The simplified version of the requirements are:
- Easily maintain the process by the Client
- A configuration table will contain a list of reports that need to be run
depending on how the table is filtered.
- This table is maintained by a Form and will change very little but when it
does the Report Macros are re-generated.
- The client wants to be able review the Report Macro before it is used in
Production
- The client wants to be able to quickly modify the Report Macro when time
is of the essence before it is used in Production without having to try to
figure what went wrong with code that generated the Report Macro.
So, have there been improvements and can Macros be created with Code?
Thanks,
Doug
I am using Access 2002 and probably an Access Project (.adp) connected to
SQL Server 2000.
Ok, I have seen this in replies to similar questions,
- "Why do you want to?"
- "If you can write code, why do you need a macro?"
Not that the replies answered the question, I will satisfy your curiosities
if needed.
My client knows Macros. My client does not know VBA and has little time to
learn it and as a result, when I am gone wants to maintain the processes I
put in place with the least amount of effort especially in time critical
situations.
The simplified version of the requirements are:
- Easily maintain the process by the Client
- A configuration table will contain a list of reports that need to be run
depending on how the table is filtered.
- This table is maintained by a Form and will change very little but when it
does the Report Macros are re-generated.
- The client wants to be able review the Report Macro before it is used in
Production
- The client wants to be able to quickly modify the Report Macro when time
is of the essence before it is used in Production without having to try to
figure what went wrong with code that generated the Report Macro.
So, have there been improvements and can Macros be created with Code?
Thanks,
Doug