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

Advanced Access Queries

ResolvedVersion 2007

Fri 8 Jul 2011, 17:08 Delegate Daniel said...

Daniel has attended:
Access Advanced course

Advanced Access Queries

Date Functions

Allow user to enter or select an ingredient by ingredientDescription and the system will produce a list of all patients who have had a dish including that ingredient on a menu for them with a service Time later than 31days before the current date and time.

what I want is how to work out Service Time later than 31 days before the current date tim Please!

Mon 11 Jul 2011, 09:39 Trainer Stephen said...

RE: Advanced Access Queries

Hi Daniel

Thanks for your question

This is fairly straightforward.

In the query designer simply enter the following criteria for your service Time field

>(Date()-31)

This will return every date that is 31 days or less from the system date

Hope this is useful

Regards

Stephen

Sun 17 Jul 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

Advanced Access Queries

Advanced Access Queries

RE: Advanced Access Queries

Access articles

Access tip:

Open A Combo Box Automatically