Recent content by warco

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.

my users enter the compound in a textbox. I would use a combo box, but there are just too many compounds to search through. Your solution does make sense though. I do have a comments box which would work fine to display my notes.

that is good to know, but writing code is very new to me. Is there any way to give me an idea of what I need to do to create these notes. Thank you.

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

sorry for the late reply, but the solution worked fine and thanks for your help.

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

After a few tweaks I found that your solution worked very nicely, but my boss let me know that he changed his mind about saving space in the reports, so I am moving back to the old report. Thanks for your help anyway.

When I group the entries by compound, the compound specs are just repeated for each batch in the compound. My problem may be structural, but if you have any other suggestions, they would be greatly appreciated

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

success just wanted to say thanks for all the help. I just worked through some trial and error creating a macro, but now everything runs smooth and efficient.

thanks neil and King kong for your help, but I have read both of your solutions and I feel that WayneRyan and Tal's solutions may be too advanced for me. Neil your solution sounds like it would solve my problem, but I do not understand what "PK" is. I was wondering if you could give me some...

thank you for you're reply to my question. I only posted multiple threads because I did not see the first two in the forum after I posted them. It is good to know that there is a way to solve my problem. If anyone has tackled similar problems as mine and would like to give me a good starting...

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