Record button??

[JB_96RS]

Any way to make a macro in Access the same way it is done in Excel? Where is the record button!!

Thanks,

JB

 

[spacepro]

Afraid Not!

It is purely done through VBA code or creating a macro and select the functions and complete its arguments.

Personally I prefer to use code than macros but macros in access as no error trapping, something that can be done in code.

HTH

Andy

 

[JB_96RS]

Any where that I could get a guide for coding this in? I've tried reading all the help topics that looked remotely close to this. There is really only 3 pieces of info that I need to get out of a txt file and plug into a SQL table.

Thanks again,

JB

 

[spacepro]

if you go down the macro route, look at access help file for the functions and you can press F1 on each argument and the help file will show an explanation.

If you want to go down the coding route then do a search of the forum of what you want to do, there are so many examples of import/export functions.

If you get stuck post on the forum, everyone here will certainly point you in the right direction.

HTH

Andy