Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Veronica has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Access

is there a list available with all available macro commands.

Edited on Wed 17 Sep 2008, 11:50

RE: access

Hello Veronica,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Macro commands.

Here is the list:

AddMenu
ApplyFilter
Beep
CancelEvent
Close
CopyObject
DeleteObject
Echo
FindNext
FindRecord
GoToControl
GoToPage
GoToRecord
Hourglass
Maximize
Minimize
MoveSize
MsgBox
OpenForm
OpenModule
OpenQuery
OpenReport
OpenTable
OutputTo
PrintOut
Quit
Rename
RepaintObject
Requery
Restore
RunApp
RunCode
RunCommand
RunMacro
RunSQL
Save
SelectObject
SendKeys
SendObject
SetMenuItem
SetValue
SetWarnings
ShowAllRecords
ShowToolbar
StopAllMacros
StopMacro
TransferDatabase
TransferSpreadsheet
TransferText

I have included an excel file with descriptions of each one.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Attached files...

macro list.xls

RE: access

Thank you that was a great help. Sorry have not found out yet how to post the question as resolved.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.