Recent content by Anthonydb

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.