Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Accedd Advanced

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Accedd Advanced

Resolved · Low Priority · Version Standard

Reply Wed 13 Feb 2008, 16:25Delegate Robert said...

Robert has attended:
Access Advanced course

Accedd Advanced

I heard that you can convert Macros in Access into VBA code. Do you know how I can do this?

For upcoming training course dates see: Pricing & availability

Reply Fri 15 Feb 2008, 11:15Trainer David said...

RE: Access Advanced

Hi Robert,

Macros are created using VBA, if you just record a Macro then Access will write the VBA code behind the scenes. You can get to the code in the VBA editor within Access. You will not need to convert anything at all.

Hope this helps
David

Reply Fri 15 Feb 2008, 11:33Delegate Robert said...

RE: Access Advanced

Hi David,

Sorry but there doesn't be a way to 'record' macros in Access. Furthermore, unlike in Excel, Access doesn't show the macros you create in the VBA editor.

Any other ideas?

Reply Mon 18 Feb 2008, 11:50Trainer David said...

RE: Access Advanced

Robert,

My mistake. In Access you will have to write the Macro yourself using VBA code. Thus you can just view the macro code in the VBA editor.

Hope this helps
David

Reply Mon 18 Feb 2008, 11:54Delegate Robert said...

RE: Access Advanced

Thanks David,

But I found an easier way of doing this.
If you create an Access macro and then go to File and Save As, and then choose "Module" from the 'As' drop-down list, Access will create the code for you.

Access articles

· Why go on a Microsoft Access Training Course?
· Insert A Real-Time Clock In An Access Form
· Use Split Form View In Access For Simultaneous Views
· Discover The Top Ten Changes In Access 2010
· Why consider Access Visual Basic training?

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips