Search results

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. :)

When I said that I meant putting the SQL back in the form/report and deleting the queries. Having no queries is best for security, I figure. That was the bad part about putting my sql in a query view, they are more vulnerable. The queries aren't protected when you create an executable, I can't...

I will start to transition the queries back however that tool you mention sounds interesting, isn't it best to have the sql as vba for a couple reasons at least? Security (as in no one can get to your work) I'm thinking and I'm sure more. I am starting to get a grip on queries, since I found...

Cool, I always felt the size was ok as it slowly grow with more objects. There are lots of areas I need to improve the db frontend, when I started I had difficulty with queries and yeah some are trains and hard to track. That sucks to see you say place sql's in forms, I asked around on that...

backend file is 1.6mb but that's empty, with a bit of data and orders its 1.8mb. frontend file is 17mb at the moment, was around 23 for a long time and for some reason went down recently.

That's what will take time, me knowing how big the file should be, right now I have no clue, that could be bad as far as I know. I'm going to go through all the fields and change all the 255 character fields to a length that's really needed. That should make it even smaller. How is about 20mb...