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

macro button

ResolvedVersion 2007

Shah has attended:
Access Introduction course

Macro Button

how to crate macro button

RE: Macro Button

If you wanted to attached a macro button to a form for example you would open the form in design view, select your design tab, click "button" under the controls box and use your mouse to create a button on the form. You will automatically get a wizard open up and give you a number of opens as to what action will occur when you click the button in your form view, this includes assigning a macro.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

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.09 secs.