Activity Stream

Please have a look at the attached file, is that what you are looking for. I see Micron beat me to it, it is the Unmatched query in the query wizard...

How about http://theaccessweb.com/queries/qry0001.htm

It's best to normalize now before adding more features or you will find yourself banging your head against the wall trying to come up with...

I am almost say for sure this isnt the best this can be built. The reason I created it this way is because some of it was already built, and im...

Is this a situation where someone is logging out a piece of equipment and then logging it in when it is returned? Rather than a numbering system you...

So once the user enters all 3 serials you want something to happen? I think you will have to drive the running of the queries from that form and...

OK, I will give more details. The form is Load_Machine, and on this form, there is three fields that the user enters the injector serial numbers...

don't agree re 1 -relationships are created in the back end, not the front end. re 2 access default is DAO, ADO can only be used via VBA re 5 -...

depends on how the value on that specific equipment reaches 2. is it calculated? if so what is the code? or is it entered by the user? @Micron -...

Not much info. What kind of form, single record view, datasheet, main or subform, continuous form? 2 is the number of times used? Equipment is...

1. in FE, but I rarely use them. 2. dont bother with dao/ado, you dont need them with linked tables. 3. just link them 4. the sql doesnt care...

I have this working in a small test DB so I'm going to try and reconstruct the form and test it step by step No Results after requery

No Results after requery

If you want to end up with one db (which makes sense) I'd do what I posted. As to the last question, IMO every table ought to have a PK, but I didn't...

Sorry to not follow you, but with Me.Requery you are still not getting the filtered results or are you getting them as expected?

I use this: http://theaccessweb.com/forms/frm0022.htm

Thanks. I will try that, but I'm still interested to uncover why this has worked in the past but not now.

I do have me.requery in the afterupdate event of the combo box and have tested that it is working.

Thank you for replying. The purpose of this whole exercise is for me to know what albums are not in my car, so it will be easier for me to know what...

What will you do once you know the difference? If you're trying to amalgamate it would be easier to create a new db (this should be a back end only...

Maybe try: continue = True missingLocation = DCount("*", "vbaImportList", " Is Null") If missingLocation >= 1 Then continue = False End If

Try the afterupdate event of the combobox to set the form's recordsource to the sql string.

Do you have a Me.Requery in the AfterUpdate event of the cboMainCat combo? Cheers, Vlad