Converting VBA to Macro
- Thread starter Kundan
- Start date
- Local time
- Today, 13:06
- Joined
- Jul 9, 2003
- Messages
- 17,426
Yes it is possible, see Video 4 at time index 1.28 on Nifty Access Here:-
www.niftyaccess.com
VBA Beginner – Nifty Access
www.niftyaccess.com
- Local time
- Today, 13:06
- Joined
- Jul 9, 2003
- Messages
- 17,426
However, be aware there is a small problem that can occur if the macro contains a TempVar.
See "Value" problem on Nifty Access Here:-
https://www.niftyaccess.com/tempvars-value-error/
See "Value" problem on Nifty Access Here:-
https://www.niftyaccess.com/tempvars-value-error/
- Local time
- Today, 13:06
- Joined
- Jul 9, 2003
- Messages
- 17,426
WTF? It's too early in the morning! I just seen, the Question is the other way round!
Oops!
Oops!
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 08:06
- Joined
- Apr 27, 2015
- Messages
- 6,760
You were on such a roll too!
- Local time
- Today, 13:06
- Joined
- Jul 9, 2003
- Messages
- 17,426
In my own defence, I've never heard that question asked before!
- Local time
- Today, 07:06
- Joined
- Feb 28, 2001
- Messages
- 30,164
Kundan, the problem with converting VBA code to a Macro is that the things a Macro can do are more limited than the things that VBA can do, so it becomes a real problem to do the conversion. Not everything you can do in VBA is even possible in a Macro.
Can you perhaps tell us WHY you want this? Then we might be able to advise you better.
Can you perhaps tell us WHY you want this? Then we might be able to advise you better.
onur_can
Active member
- Local time
- Today, 05:06
- Joined
- Oct 4, 2015
- Messages
- 180
Hello friends,
You can convert a macro to VBA code. But as our plog friend said, VBA is from macros
is much more powerful. I want to talk about an issue in Access's definition. MS Access offers you a number of wizards for programming,
You write in a database with the help of wizards, almost without writing code. Likewise, you just write a simple database using only macros.
So what do you do when things get a little more complicated?
Of course, it is time to take advantage of the power of VBA.
As a result, you must master VBA and SQL language beyond Macros and Wizards to gain full control of Access.
You can convert a macro to VBA code. But as our plog friend said, VBA is from macros
is much more powerful. I want to talk about an issue in Access's definition. MS Access offers you a number of wizards for programming,
You write in a database with the help of wizards, almost without writing code. Likewise, you just write a simple database using only macros.
So what do you do when things get a little more complicated?
Of course, it is time to take advantage of the power of VBA.
As a result, you must master VBA and SQL language beyond Macros and Wizards to gain full control of Access.
