Search results

I have two queries; each is supposed to have the same values for a result field. I need to make a query to show the results from Table 1 which are not the same in Table 2. I am not too good with code so if there is a way to do it using an expression that would be great thanks in advance.

In my lab database i was wondering if there was any way to attach a note in the form to certain compounds so when they are entered, a pop up can let the user know some information specifically about this compound and its allowed field values. A restriction for certain fields could also work. For...

I need to make a query for a report that will only show the new records added during a certain 24 hour time frame. The time frame which i had in mind was from 7:00AM yesterday-7:00AM today. Right now I have it set on today's date as a criteria, but everyday we need to print 2 reports rather than...

In this inventory database, I have entered different chemical compounds which also can be seperated into individual batches for these compounds.All the batches within the compounds are identical except for their "batch number" But, the daily inventory report tends to be too lengthy with all the...

I am trying to build an expression using the afterupdate() function in an expression (not VBA). Can anyone give me an example of an expression that increments the field [batch#] +1 after the update. Any alternate suggestions for my expression would also be helpful. I've thought about using...

I am having a problem with a very basic macro. I attached a incremental expression for my invoice # field to a duplicate button in my form through a macro. I did this so that I could make duplicate records with only the invoice number changed. Everything was going as planned until I realized...

I am creating an inventory database and each entry has an individual invoice # and a few other informative fields. Quite often there will be 20+ entries with consecutive invoice #s and all other fields will be indentical. Is there any way to enter these records into a table without having to...

I am creating an inventory database and each entry has an individual invoice # and a few other informative fields. Quite often there will be 20+ entries with consecutive invoice #s and all other fields will be indentical. Is there any way to enter these records into a table without having to...

I am creating an inventory database and each entry has an individual invoice # and a few other informative fields. Quite often there will be 20+ entries with consecutive invoice #s and all other fields will be indentical. Is there any way to enter these records into a table without having to...