Search results for query: *

Hello, I have a functioning Access database that is used by a vendor for the input of the receipt information. From that I numerous queries running off of other queries in order to create the necessary reports. I have ran into a programming issue with this now. The tax rate for one of the...

I am trying to set my query up so that it prompts for a location name and a date range when ran. The date range works great but when used in conjunction with: Like [Enter Location Name] it fails. It prompts for a location name but returns the query with no data and the date range is blanked...

Thank you for your help. I entered the expression from this point on and entered it as an Expression Builder on the After Update command. Nz(DLookup("[countyID]","locations","location ID]='" & Form!ReceiptEntry.[County ID] & "'"),"") Did I...

Hi, I have written the following expression to set a value in a field on a form based on the data in another filed: DLookUp("[countyID]","locations","[location ID] ='" & [Forms]![Receipt Entry]![County ID]) I am trying to have a field self populate based on...

I am creating a database for a vendor and I am trying to get one field on a form to lookup a value from a table. The other fields already run on macros and are just used to populate dollar amounts. I need the county ID to populate automatically based on the Vendor name. Does anyone know the...

I am trying to set up an Access form so that the item selected in the combo box populates the rest of the fields on that form. I want to use it as a lookup box so that when someone selects a Company, the company information will populate in the rest of the fields. Any ideas?

I am trying to set up an Access form so that the item selected in the combo box populates the rest of the fields on that form. I want to use it as a lookup box so that when someone selects a Company, the company information will populate in the rest of the fields. Any ideas?