Recent content by robsworld78

Thanks arnelgp, that did it. :) As soon as I read what you posted I knew it would work, I wasn't sure what to put as as true condition.

Thanks for the info on Like! Unfortunately that didn't work but I might not have done it right. I see you mixed them so not sure where to put it. The Where gives errors in criteria so I tried in new column with total set to Where and if the "show" wasn't ticked the query ran but gave all results...

Sorry I was wrong, that didn't fix it, it acts the same as Like without the wildcard. So using what you suggest requires that field to have a valid selection, if its blank and only date criteria used the query is empty. Something needs to say use one criteria or two, that wildcard did that...

Oh wow, thank-you sir! I would have guessed = and Like would be the same. Works as expected now.

Hi, I'm having issues with a query, it's based on multiple criteria's, a primary ID and a date field. I've narrowed the problem down to the end of the criteria for the ID, it's the & "*" Like [Forms]![SearchBox_CharitiesSalesSummaryReport]![CharityID] & "*" The criteria I use for the date...

I found a work around solution using update queries.

Hi, I'm trying to use VBA to update a new column in a table with info I already have in another table. The table I want to update is an inventory details table, it has around 25,000 records. I added a column called "UnitCost", of course the column is empty for all 25,000 records so I would like...

:) This saves me a lot of work. Thanks!

So that shortcut would point to the backend file? Then when frontend is closed run the shortcut and it did its thing?

I'll save them as querydefs on day if I think its needed, need to see what happens to file size as data is entered, so far so good and its been used a few days. I was just worried about bloating the file as that appears to affect it. I know the code I have isn't the fastest or most efficient by...

Well, you win some you lose some. Would update and insert queries be better? I thought they were the same. If not what technique is best to replace those SQL strings? I really do have lots of them in the code. In one day it could get to 100 or more of those things getting triggered.

Oh, almost forgot, on the original subject about network speed issues, turns out it was network so that was good news.

So much to learn! Around the place I'm at people can get away with anything, never a consequence. I have the messed up job of building a system so people can't get away with stuff. I say what you say, don't need to build a system for that, straighten up or loose your job but instead they prefer...

Why not, you said that tool will change the SQL to VBA so the queries remaining can be converted easily to VBA and then no more query objects. Its good if you are selling a db and don't want any edits done unless your doing them and you know what edits mean. :D Now without me the db can never...

Well it will be tighter than fort knox once I get my queries fixed up. :)