Recent content by assassin4213

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...