Search results

Ok, here's the scoop. I have the following record setup for tracking shipments: [Shipment_ID_#], [Date_Loaded],[primary_silo], [secondary_silo], [2_silos] I need to retrieve average values from another table for certain chemistry values based on the [Date_Loaded] and whether or not one or two...

Hello Everyone, Ok, here's the scoop. I have a tournament / player score tracking database that we are developing. 1. I have a form that I would like to use to select a table number. I use a combo box to select this table number. This part is easy. 2. Once I have selected the table...

Hello Everyone, Ok, here's the scoop. I'm developing a database that will track tournament results. There are several scoring categories that must be filled out by each participant after each round. Ultimately, we would like to use a scantron device to enter all of the appropriate...

Hello Everyone, I am having a problem figuring out how to setup criteria for selecting the previous months data. I try to use the following on a date field. =month(now()-1) However, I have not been able to get this to work. Please help :confused:

Hello Everyone, Here's the scoop. I have two tables. One that has raw lab data, the other that has vendor names with their specifications. I have one form that is used to enter the lab data. A vendor is sometimes associated with a data set. I would like to have the database reference the...

Never Mind Thanks for your help. I actually just figured things out. I was never aware of how to make normal inner joins with a query. I now know and knowing is half the battle.

Separate Tables

Hello Everyone, Ok here's the scoop. I have a report that is generated by sorting all the shipments received for each vendor per quarter. Each vendor has their own unique specifications, which are entered and stored on a vendor table. My goal is to be able to automatically highlight in red...

Hidden Forms Thanks. It worked and I really appreciate your help.

Hidden Fields Hello Everyone, Ok, here's the scoop. I am working on a QC database which contains a checkbox that indicates whether or not the sample is from a vendor or our internal lab. If it is checked, then certain vendor specific fields have a visible setting = True and other fields have...

Hello Everyone, I'm using conditional formatting on a form that is used in a subform on my main user interface. When I open the form by itself, the conditional formatting works. However, when I open the form using the subform, then conditional formatting does not work. Access shows an error...

Hello Everyone, I have a form with a drop down menu for selecting a unique vendor from a list. A query is tied to this drop down menu so that once there is a vendor selected - only this vendor and their specs are provided by the query. I would like to take the spec values in the query and...

Solution Work Around I was opening the query in a subform. Well, I found a work around by making two queries that handled the comboboxes differently. With an if/then statement and the isnull function I was able to have the correct query set as the sourceobject for the subform.

Hello Everyone, Here's the scoop. I have a query that sorts data that is referencing an unbound combobox. I have two scenarios. 1. When a vendor is selected in the combobox - I would like the query to sort the data set and show only that vendors data samples. 2. When no vendor is...

Thanks It would have helped if I wrote the question (been watching too much Jeopardy). I was looking for a way to change the subform source for different queries to be viewed instead of having to make several different forms and program a ton of extra code to make them visible/invisible...

Hello All, I have a subform that I would like to be able to change the sourceobject on with command buttons or even combobox. This way the users of the database can view prefabbed data sets without having to constantly close windows. I prefer to use the command buttons in order to keep things...