Search results

I have two queries. One has an item field, a field for dates (date) and the other has a list of holiday dates (holidates). I have an if statement that compares the date to the holidates and tells it how many days to add to bring it to the next work day if it is a holiday. My problem is that...

In Expression Builder and other areas of Access where the fields of a query show, my fields are not showing anymore for any of my queries. Does anyone have a solution for this? Thanks.

I created a function and when I try to use it in my query I am getting the error message Undefined Function in Expression. This is the function: Option Compare Database Option Explicit Function Next_Weekday(DateField As Date) As Date If Next_Weekday((DateField)) = 1 Then...

Two of the fields in my query are for Progress Note and Progress Note Date. Each client has several progress notes. How can I have the query show only the Progress Note with the latest date? :confused:

I have a report where you enter the criteria via a form, it works fine, except when you close or cancel the form it continues to prompt for the criteria as if you were running the report without the form. It only prompts for the criteria that hasn't had any data put in it through the form...

When I import an excel spreadsheet into my Access database it always creates a couple of new blank records. I import this spreadsheet frequently so I would like to set up a macro that will automatically delete any blank records it creates. Can someone tell me specifically how to do this...

In MS Access 97 I have a basic query based on a single table. When I use "Between [Start Date] and [End Date]" as the criteria in a date field it returns incorrect records. It works correctly on date fields that are not calculated but not on the date field that is calculated. If I type in...

I have a parent combo box and a child combo box. When the requery runs on the update event of the Parent combo box to update the records in the child combo box, all other records in that field except the current one are deleted. What other method can I use to keep the cascading combo boxes...

I have used your very informative information on cascading comboboxes. It works well except when the requery activates it erases all information in the childID field on all records except the current one. In the cboParent AfterUpdate event I have the following code: Me.cboChild.Requery This is...