Search results

Well, for this one, it needs to filter once by company ID, then from those records I want to find the matching contacts. Edit: I guess it's true what you said about the inefficient search. I looked again and since I am not populating anything with that SQL, I can put the Like statement right in...

An Example Here is the code I use to populate a message box with the search results. Private Sub AdvancedSearch_Click() Dim strResults As String Dim rst As Recordset Dim SQLStatement As String SQLStatement = "SELECT Customers.IDFLCustomerNum, tblContacts.ContactName, tblContacts.ContactNumber"...

Hello all, The normal function of a combo box as a search method is great - as long as you search by the first letter of whatever it is you are looking for. Some cases have come up where it would be nice to be able to search for June and get the result that is Xiang Xu (June). I can do this...

Detail Not Visible Based on CheckBox -Fixed...ish Hello All, I have a one to may relationship where a sample can have multiple free form reports attached to it. These are stored in a table. I have a check box on the form (and the table of course) where the user can check whether or not they...

Oh Good Grief! Ok. Thanks. I guess I will have to do yet another hack to get access to do what I want. Thank you for the reply Greg

Hello all, I have a report where I am counting based on certain criteria in the form of If such and such = this then counter = counter + 1 Elseif.... End If The counter works fine up until I hit a new page. The counter counts once, goes to the new page and then counts again. So for each page...

That didn't work either. Thanks for hanging in there with me so far.

Maybe I should add this. I am using MySQL as the backend with the ODBC connector driver.

Getting rid of DISTINCTROW doesn't do it. I have a feeling it is not query specific.

Good idea. Here it is SELECT DISTINCTROW tblTestsWithInvoices.ArbitraryIncrement, tblTestsWithInvoices.InvoiceNumber, tblTestsWithInvoices.TestID, tblTestsWithInvoices.seqInvoiceNumber, CheckIn.Contact, CheckIn.SampleRepresents1, CheckIn.CIQNumber FROM CheckIn RIGHT JOIN tblTestsWithInvoices ON...

More info: I tried adding one of the tables to a query. Didn't work. Took out some fields. Didn't work. Added a field (happened to be the PK) worked. Added another table, didn't work. I am going out of my mind here.

I don't think it is my query design because It still has problems when I import it into this database. There has to be something deeper that is making this query read only. The link didn't sort it out. I tried everything on the list and it all checks out. I am still mystified.

Ah, Suspicions lead to insights. I inspected the query, and I cannot add any records. There is no add record button on the record selectors and when I right click on a column, Add Record is grayed out. Curious. How did this happen and How do I change it? I tried rebuilding the query but I get...

That didn't work either. The link Master and Child fields are InvoiceNumber. The invoice number is blank when a new record is created and it is filled in by the user. This has never been a problem, but I wonder if the subform is having a problem making a new record in the associated table/query...

It displays normally. It displays all records for the query that the subform is bound to.

Yep. That didn't work either. I'm getting very nervous.

It is SP2. I went into the backups and found a working copy. I imported that working copy into my current working copy and the problem shows up even though it was working with the same forms in an older version. Very bizarre. Any other thoughts?

I applied the hotfix and that didn't do it. I am pretty sure I installed SP3.

Access 2003 and yes to both of those.

Hello helpful friends, I have a main form with two subforms, both of which are continuous forms bound to different queries. One subform works as it should. The symptoms of the other subform are that when I create a new record with the main form, the subform just shows the form header and not...