Recent content by andymartnez

One final question, is there a way to call the "compact and repair" from VBA? (Connected to a button on a form)

I again thank you, once small step for a query, one giant leap for the database.

How exactly would i set it up for that line, because it's coming from two different text boxes?

I used that method with my polygon search a while back, and seeing it work so well with my keyword search, I assumed it would work, but it didn't. Here is how I implemented it. Mind you, this is not the query that we had been previously working on (I have 3 queries that are all similar, one uses...

So another problem has arisen out of the ashes of the old one. Well, actually its been a problem the whole time but I'd forgotten about it until now. If any of the fields for a record that are also part of my search form criteria, are left blank on the record, then it won't be returned as a...

I initially tried to make a form that functioned as a report does (before I knew about reports). The only reason I use a report is because it integrates well with queries and can display multiple records at once. I keep them in report view because I have buttons and whatnot on the report so...

You, sir, are a SQL magician. I was thinking about doing something similar to what you posted (using the Nz phrase) but I just couldn't quite figure out how exactly to put it. It worked like a dream! I went back and thanked all your posts for sticking with me on this one. Thank you so much...

Yes that's how I had it. But the problem still remains that it requires all 3 keyword search textboxes to be filled in, otherwise everything in the table is returned. If you want I can split the db and send you the front-end and see what you can make of it. EDIT: Also, this is somewhat...

Yeah that didn't fix it so I took out the InStr code and reverted it to my old method and it works fine. I kept the aliasing, however. Is there truly no way to do what I'm trying to do?

Here's how it looks now: SELECT T.ID, T.model_name, T.date_created, T.thumbnail, T.texture_type, T.path, T.author, T.polygons, T.textures, T.licensing_rights, T.categories, T.subcategories, T.keywords, T.notes, T.associated_program, T.file_type, * FROM database_tbl AS T WHERE...

I have the code doubled up for a purpose, I'd change it but I don't want to have it mess up anything. I'm still getting the "criteria is incorrect or too long error" and I shortened my SQL to this: SELECT * FROM database_tbl WHERE (((database_tbl.model_name) Like "*" &...

Okay here's the whole untouched thing, all I'm doing is making it line up nicely: SELECT database_tbl.ID, database_tbl.model_name, database_tbl.date_created, database_tbl.thumbnail, database_tbl.texture_type, database_tbl.path, database_tbl.author, database_tbl.polygons...

Oops. When I tested it in my query I used the field "keywords" which is my keyword field. Just forgot to put that back in when I pasted it here.

I put my original stuff back in sorry. SELECT database_tbl.ID, database_tbl.model_name, database_tbl.date_created, database_tbl.thumbnail, database_tbl.texture_type, database_tbl.path, database_tbl.author, database_tbl.polygons, database_tbl.textures, database_tbl.licensing_rights...

SELECT database_tbl.ID, database_tbl.model_name, database_tbl.date_created, database_tbl.thumbnail, database_tbl.texture_type, database_tbl.path, database_tbl.author, database_tbl.polygons, database_tbl.textures, database_tbl.licensing_rights, database_tbl.categories...