Creating my own macro

[PoniKika]

Im designing a stock control system in access, and would like to write my own
code for one or two simple macros which I could use. Trouble is, I dont know
any code. Can someone reccommend a link to a suitable website where I could
find suitable code? Or can you help me by giving me an explination of the VB
code syntax so that I can understand which words I write when I want to open,
close, move edit etc. Is there a specific alphabet or dictionary available?
that would be great. Any help, no matter how small is always appreciated.
Thanks.

 

[Duane Hookom]

You can convert a saved macro to a module. Then open the module to see how
it converted your macro.

Otherwise tell us what you need to do with code and add a comment about
"never coded before so baby-steps please".

 

[John Vinson]

Im designing a stock control system in access, and would like to write my own
code for one or two simple macros which I could use. Trouble is, I dont know
any code. Can someone reccommend a link to a suitable website where I could
find suitable code? Or can you help me by giving me an explination of the VB
code syntax so that I can understand which words I write when I want to open,
close, move edit etc. Is there a specific alphabet or dictionary available?
that would be great. Any help, no matter how small is always appreciated.
Thanks.

One warning: Access has both "Macros" and "Modules" - the latter are
VBA code, the former are much more restricted. Excel and some other
applications use the term "macro" to refer to VBA code; Access is an
exception. What you almost surely need is VBA code modules.

There are some good books on writing VBA. See the links from the
website http://www.mvps.org/access.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps