Search results

Okay, I'm back again. In my excitement of finally getting something to work, I forgot about the rest of the items I needed for this form. I would also like to be able to search by any and of fields on the form, ie., Tape Description, Employee or 1 of the date fields. Also, I need to have a...

Thanks alot, the worked like a charm. I'm sure there is propably something more elaborate I should use. For future reference, if anyone wants to provide that knowledge, I'll gladly take absorb it. Thanks again.

Please bear with me, the length of the code is long. I'm trying to get this search form search again after the first search is completed. I can type in a barcode # and perform a search but when I try another search, I get a yellow highlight pointing to the following code: myrec.Open...

Forgive guys but my code module is so congested with active and commented out code that I can't make heads or tails of it anymore so let me try starting from scratch. What would be the best approach to the following: I need a search form to produce a datasheet of records. I want to be able to...

When you told me to try the single quotes instead of the double quotes, that is when the cboselcet went blank. If I go from [LastName] & "," & [FirstName] to [LastName] & ',' & [FirstName] the cboselect becomes empty. The code is as follows: mstrSQL = "SELECT * FROM Employees WHERE " _ &...

The cboselect has a query statement in the control properties that combines the first and last names of employees.

Okay the killed the error but, the concatenated query for the combo box is now not appearing. Could you explain the double vs single quotes distinction. Also, maybe I'm going about this the wrong way, ultimately, I want to be able to scroll to a name and have a datasheet popup and show the...

I corrected the cboselect and removed the "DoubleQuotes". No I get "expected end of statement at this point; mstrSQL = "SELECT * FROM Employees WHERE " _ & "EmployeeID In (SELECT DISTINCTROW " _ & "EmployeeID FROM Employees WHERE [LastName] & ", " &...

I'm using code from Northwinds to try and manipulate for my use. The combo box has a concatenated query which is the first case I'm trying to build. If I ever get the 1st case to work I will then try to include cases for dates, Serial # and Job ID. I don't know what the "DoubleQuote" represents.

I am trying to build a select case on a combo box that is executed by a find button. I'm getting a syntax error with the following: mstrSQL = "SELECT * FROM Employees WHERE " _ & "EmployeeID In (SELECT DISTINCTROW " _ & "EmployeeID...

You got me, that didn't help either. The highlighter went back to the same line. Also I'm getting an error saying that access doesn't recognize the expression (which is the subform) Tape 2.

No I'm getting the highlighting of the line with no error msg. Here is the code that I have applied: Keep in mind that 2 of those lines are commented out. Private Sub cmdFind_Click() frmSubform.Filter = "[Serial Number] = '" & Me![txtSearchResults] & "'" 'frmSubform.Filter = "[Serial Number]...

I'm receiving a run time error 424 object required. This is the line that is highlighted: frmSubform.Filter = "Serial Number = '" & Me![txtSearchResults] & "'"

I am using a form and a subform, on the main form I have a cmdfind. I want the find button to search a table (Tape3) that is displayed as the subform. I am looking to search by multiple criteria but I can't even get the button and form to interact so I've deleted all code and I am looking to...

Was I in the right area with the code I was describing or would select case be more appropriate? Any good books you can recommend on the using of VB code with unbound controls and anything else I'll need to make this work? Thanks again.

This may be a little long winded so please excuse me. I'm looking for the easiest way to create I guess what you could call multiple profiles for a database. In other words, I have one database but I want to have a situation where, when the splash screen appears, here are the choices: D.C...

Thanks for the help but I found a very simple solution. I have the data elements as Text Boxes on the report and all I had to do was open the properties box and click on Hide Duplicates for each text box that I don't want to repeat. Sometimes things are so easy and right under our noises we...

Here is my data: [Employee ListingTable] Id LastName FirstName [Locations Table] Type Manfu Model RAM Speed HDC [Handheld Configuration] HHD_ID Handheld Model SW Type SW Version These tables are combined as a Select Query. The problem is that John Doe will have the following...

I don't know if this should be in queries or in reports but here goes. I have a report which is based on a query and the query is based on 3 tables. My problem is there are multiple records for individuals that I wan't to appear but there is certain data I want to appear only once. Example...