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

access vba - formula bar

Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba - Formula bar

access vba - Formula bar

ResolvedVersion Standard

Anies has attended:
Excel Intermediate course

Formula bar

how do i get the formula bar?

Edited on Thu 13 Dec 2007, 16:26

RE: formula bar

Hi Anies, Thank you for your post, In answer to your question;
The Formula bar should be displayed by default, however if it is not showing you can switch it back on by; Click on the Menu Command Tools, Options and in the View Tab you will see a radio button for the Formula Bar, click in this circle to select it, Click OK and your Formula bar will be displayed. I hope that helps, best regards Pete

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

Server loaded in 0.11 secs.