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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » Macro

Macro

ResolvedVersion 2000

Wed 8 Oct 2008, 16:03 Delegate Emma said...

Emma has attended:
Access Advanced course

Macro

How do you creat a macro command button within a form to copy the record across to a new table?

Wed 8 Oct 2008, 20:52 Trainer Julie said...

RE: Macro

Hi Emma

You would need to create the macro 1st and then assign it to the command button in the form.

Alternatively you could create a query to copy certain records and still add a command button to the form, under Miscellaneous, run the query from the command button.

Hope this helps.

Julie

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Macro

Macro

RE: Macro

Access articles

Access tip:

How To Find All Overdue Accounts?