Search results

I've got this bit of code that is giving me a hard time. If IsNull(Me.txtCustomer.Value) Then strCustomer = "Like '*'" Else selectcase Me.frmCustName.Value Case 1 strCustomer = "Like '" & Me.txtCustomer.Value & "*'" Case 2 strCustomer = "Like '*"...

Thanks for the replies. I guess I wasn't clear. I knew WHAT the SQL string should be, I just couldn't get it to work that way. I looked at it a bit further, and realized I'd probably have to have a few different SQL strings to get this to work, and decided it wasn't a road I wanted to go...

I haven't gotten this to work yet; but I'm still playing with it. ~goes off to search some more~

Thank you. I'll give this a try. ~Brenda

OK, I have made some good progress on this program, but I've found a flaw in my thinking. I'm using a SQL string to call a query. In that SQL string, I'm using a lot of If/Then statements. It's working the way I want it to work. You generally have three choices Yes, No, NA. If it's Yes, it...

I did read one of your posts :D I'm trying, folks, I'm trying. See, I'm a mechanical designer, the extent of my programming knowledge is LSP - it's just different in here :)

Thanks. I would love to change all the table/field names, but this is an old database, and it's been linked to so many other databases, I'm not really willing to make those changes. It's a pain in the you know what, but the folks who did the database creating weren't thinking too far in the...

Thanks. I will take a look at that in the morning and see if that solve my problem!

I'm not sure I follow what you mean (I'm a relative novice at this)

I'm in the process of writing a query to search for multiple attributes of our projects. I've been able to write the code to run the query for all of the information I need that is in my main table. I now need to add a bit of code to search for some information that is in a secondary table...

Thanks. It is helpful if you know what to look for. :)

I have no idea what those things are. Gives me something else to go read up on though. Thanks :)

I actually have two questions. 1 - Is there a limit to the number of operators in a sql string. In other words, how many times can I say AND or OR? 2 - I think a little background is necessary. I have a table that includes a wide variety of mechanical information regarding a product we sell...

Just to be sure I'm doing this right, text fields are enclosed in quotes (they can be single or double). It doesn't matter that the text field will contain a number as the text, it is still enclosed in quotes? Thanks in advance!!

Thanks - I'm off to try that. Don't be surprised to see me back here again, however. :D:D You guys rock - the quick and helpful answers were WAY more than I expected. :D:D

OK, so does that mean I have to change this: "AND [Mechanical Features].[Tile Deck]='" & Me.chkTileDeck.Value & "'" & _to "AND [Mechanical Features].[Tile Deck]=" & Me.chkTileDeck.Value & "" & _( I took out the single quotes) Oh, and thanks for the quick responses. I appreciate the help!!!

I thought about that, and if I manually go into my query and select the criteria for those two fields and true and false, the query runs. I guess I don't know how to automate that. This is extremely new to me, and WAY over my head, but I'm plugging through anyway. Is there a way to make the...

I understand the naming convention thing. However, this database was started a long time ago, and I am just now coming in to it. I'm afraid to try and start renaming things now, because I'm not sure what else it would affect. Anything that I have personally worked on is named that way...

OK, bear with me. I am a total novice at this stuff (access, SQL, vb). I am working on creating a form that will allow me to query our project database based on several varying criteria. I get the idea of creating a query on the fly, and I can get this to work for the data we have that is in...