Search results

Yes, if you going to have users type in place of selecting a value, then what I suggest? You need more code. So, you will require additional code to check if what they typed in matches a value in the list - and then you move focus. Really no other way to have some focus change if they not...

I can't add more to Geroge's wonderful post above. After all these years, 9 out of 10 times, when you try to change or fight the default behavior(s) of Access? It tends to be a bad idea..... Simply use the Change event. This one: and then the code in that on changed event: Private Sub...

You are 100% correct. As noted, with my older computer, I "really" noticed the speed difference. With a newer (and not really a high end) laptop, then that daily speed difference was not like "oh wow", was the server oh so nice. So, that server is still fast, but as noted, standard hardware has...

It is just the way it is. Now, of course we could as, what is the maxium type of hardware setup to get max performance here? Well, every day, at one clients location, I remote into a sever. How amazing and fast is this server? Well, it cost over $100,000 dollars - in fact quite a bit more...

Actually they do. And why is that? Because 99% of professional Access developers will give you the same answer I did - that's why it releavnt... The same goes if you walk into a room full of doctors, and 99% of those doctors will and should give also the same answer for a given medical...

No worries. Keep in mind that while you cannot pass parameters to a view? (unless you create a Stored procedure, and it thus can use parameters "against" the view which is perfectly fine and legal)? Well, you don't need parameters anyway (at least in most cases - some you do!!!). So, it...

For any public exposure - a VPN is a must have. I remember many years ago - in fact it was 2004. Just before going to the MVP summit in Redmond, I want to show my fellow Access developers how cool it is that you can have a Access front end connect to a database with any valid internet...

To an extent that one needs a good ER diagram for documentation, sure, Access (or SSMS) not all that great for such a diagram tool. But, it's better then nothing! And I remember when Access came out - having a diagram tool was REALLY amazing, and previous systems that had such a feature were...

Probably no real options here. While networks and WANS have vast improved? I think remote desktop is the better choice. However today you can get away on a good solid network. We often have some users in a different city accidentally connecting their front ends through the VPN when they should...

That is correct. However, when you use ODBC to a file based system like a accdb file? It's resolving to a file path, not a tc/ip socket connection. It's still a file - even when using ODBC. And even if the file is sitting on a shared folder? It's still a file, and standard windows file path...

No, it's better that Access does not use ODBC - it uses the native JET/ACE software stack to do this. And thus the result is not only better but since there is no server when using a Access back end? Then Access does not pull the whole table down the network wire as a result - this is good...

Yes, correct. So, no sql statement at all - just the view name. You find that form loads a bit faster - but only when you have say beyond 3 or more combo boxes will you start to notice this "small" reduction in form load time. So, not a huge deal, but yes, in the combo source, don't place...

Yes, but note the above trick - if you JUST use the view name - no SQL for the combo source, the form loads even faster. You not notice this effect unless/until you have about 3 or more combo's on the page. So, it's a "minor" issue, but I have seen this trick reduce form loads times. So, for...

Another trick that helps? Just specify the view for the combo box, not a SQL query. They again will load faster. This can't always be done. But, if you have say 3-5 combo boxes on a form? You notice a slight improvment. So, JUST the view specifed for the combo box source. Now, to be fair, views...

As noted, PT queries and a combo box don't play nice here. Access client can't filter the PT query correctly. And for messy sql? Again, move to server, and then base the combo box on that view...... So, a PT query for a combo box simply does not work well, but building the view and using that...

I can't agree more. Really, with the modern hardware we have? It near all comes down to design, and the gains to be had for today's standard and decent hardware? Not going to help. A mid range, or even bottom feeder computer today gives you what a state of the art $10,000 computer was 10 years...

Actually, I can add one more FYI to the issue of combo boxes. Do NOT use a pass-through query to drive a bound combo box. But, why? This advice seems counter intuitive, since after all, a PT query is perhaps the fastest performing way to pull data from SQL server, right? Well, there is one...

yes. in fact, the #1 developer time saving tip I can share? Any time you have a query with multiple joins? Convert that to that to a SQL view, and link to that view. But why this suggestion over say a pass-through query, or even perhaps say some stored procedure on SQL server? Simple: cost...

Well, as noted, you can get more then 1 second for some disk intensive tasks. So, the better disk can help even more - that 15 seconds vs 14? Probably not going to be noticed. No real changes to my previous advice here. Anything more would be beyond my pay grade and knowledge..... R Albert

Could not agree more! And, I not a big hardware guy, and not a gamer. Really, today we are spoiled with hardware. So, for me? Just about any machine today is more computer then we could dream about years ago. I often when dragging and copying a Access database - say 130 megs? You can drag...