data type mismatch?

[Jeffrey Tan]

i have a form "Maintenence-Users" that is linked to the table "Users"

i created a filter combo box with the following

Private Sub Combo23_AfterUpdate()
 
    Dim rs As Object
 
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[win_id] = " & Str(Nz(Me![Combo23], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
 
End Sub
 

win_id - text - is the primary key

the rowsource of the combo box is

SELECT users.win_id, users.First_Name AS [First Name], users.Last_Name AS [Last Name], users.Office
FROM users
ORDER BY users.Last_Name;
 

but im still getting a mismatch?

Thanks!

[NeoPa]

Your line #6 should be :

    rs.FindFirst "[win_id] = '" & Nz(Me.Combo23, 0) & "'"

Str() had no effect as that was already handled automatically by the VBA. It was the SQL that was complaining as it had no way of knowing your literal was a text value (See Quotes (') and Double-Quotes (") - Where and When to use them).

[Jeffrey Tan]

wow neoPa, thanks a bunch! problem solved :)

[NeoPa]

A pleasure Jeffrey.

I'm finding most of your questions make sense (mainly) and seem to include the relevant data. This makes answering so much more pleasant. You keep putting the effort into posting sensible questions and I'll do the same for finding the answers ;-)

[Jeffrey Tan]

@NeoPa:

I really admire your talents NeoPa. :D

I did learn one thing though - before coding, always draw diagrams/flowcharts and plan it out first. I think I have become a better programmer. I only had a semester of SQL in my freshmen year of college, so I'm still in the learning process.

I do have another unrelated question if you have any inputs you would like to contribute :P

So this whole database (where I've been making tons of questions) is a problem-tracking database where my colleagues keep track of user & printer problems.

I would like to know if there are any notable features that a problem tracking database must have? I have researched a bit on issue-tracking systems: http://en.wikipedia.org/wiki/Compari...acking_systems but I can't seem to narrow it down to name a few features a problem tracking database must have.

Thanks in advance!

[NeoPa]

Jeffrey, I can't help you with this I'm afraid.

If you're serious about wanting to ask it then I suggest you post a new thread for it (which is how questions must be asked here - 1 per thread). It's not something I'd be likely to get involved in though, even if I do have a dig around in my brain to see if I can come up with something.

I doubt you'll want for suggestions though. Many others are likely to have been there before you.

[Jeffrey Tan]

@NeoPa:

good idea. i just feel that i've been posting too many questions lately so i don't want to spam the board :)

[NeoPa]

That's not a worry Jeffrey. As long as each question is thought out in advance and presented properly with all the relevant data (as yours tend to be anyway, according to your current understanding) then they are all valid. There are a couple of threads at the top of the forum that outline the things that should be included, as well as those to be omitted. Keep to those guidelines and you can ask away happily.