Search results

Does anyone have an opinion if there is an advantage of db=currentdb over db = DBEngine(0)(0) or the other way around? SHADOW

That's actually a really good idea. That way I never have to worry about db going out of scope or forcing the initialization. Thanks a lot! SHADOW

I've implemented this technique. It's hard to determine if on its own it helps with performance but it does sound logical. I've been running into a problem, though. - When I'm developing the app, I enter using the good old shift key so I can get into the program. The DB variable doesn't...

Awesome! Thanks, CJ! I made a lot of changes to my application and had users test it and they have been seeing real speed improvements. I'll post details later as to what I did so people who are interested might get a few tips.

Ok so just to reiterate: In a query where the last name criteria is "Like AB*", If the user types "AB", access will then only fetch clients whose name start with AB over the network? If so, that makes sense that there will be a huge speed and network-friendly advantage.

Sorry, when I said "Like *" I actually meant "Like AB*". Can someone please elaborate on how the index is being used? Is it just less work for the application to parse or is the amount of data crossing the network being limited? Does the entire table cross the network or not? I'm still...

I have a question about the method that people use (as in my example, or Allen Browne's example) to load the combo box only after a few characters are entered, thus limiting the number of rows rather than loading 20 or 30 thousand rows. Again, my question is based on not understanding how...

The first post stated that the database is split. If you're not clear on how and why (or if, in this case) splitting is done, Albert Kallal has a great webpage in clear language about the topic: http://kallal.ca/Articles/split/index.htm Make sure that no two users are accessing the...

I guess that the debate that people refer to is whether closing the CurrentDB actually does anything. I am meticulous to close any recordsets or other objects I open and then set them to nothing, as per what I've read. However, from what I've read closing the Set DB = CurrentDB doesn't...

So, the way I'm reading you, the only thing NOT to do would be to leave the subform unqualified - i.e. to base it on the complete table - and then filter it as the user navigates the main form. So: - Linking based on Client ID - Setting the recordset of the subform as being filtered to only...

I'm sorry, I don't understand which approach you are recommending. Yes, it is. Probably ten times as big as the client table. I don't understand what you are saying here. Benefit of simply linking or benefit of setting to null and then setting the recordsource after the client's record is...

I'm not clear on the answer. It's possible I didn't ask the question clearly. I set the master/child link based on the client ID. When the client's record loads, the client-specific subform data loads automatically. This means that I don't need any extra coding, and I don't need to set the...

Question to anyone reading this thread: In the demo I uploaded, I set the recordsource for the on-form subform (as opposed to the one on the tab that loads when the tab is clicked) to null, and then loaded the data after the client's record was accessed. Is this a better approach rather than...

Interesting observation about the * but I doubt that anyone really needs a complete list, especially if there are tens of thousands of rows. I corrected the error you found by changing the after update code to If Not IsNull(Me.cboSearchCombo) And Me.cboSearchCombo > 0 Then Thanks!

Ok how about this...

I really like that idea! So is myTable an actual table..? Does it have any data in it? How is that done?

Thanks. That error is only when you don't type a name, but select from the initial A-list. I've revised it to handle that situation. Here's a list of test clients who are searchable. I realize that unless you know the name of the client, you can't test this demo: Brown Lisa Smith John...

Here is a demo I made using the different techniques we've been discussing for people to review or reference. Some notes: - The main point was to limit the rows returned during a search. I used CJ London's technique of originally basing the form on a query that returns no records, and then the...

If I'm understanding the debate here correctly, we are discussing whether a form that is bound to a complete table loads all the records (or at least pointers/indexes) to RAM or to disk on the client computer where the FE is located. RAM, of course, is much faster than disk. Either way, my...

Here she is: http://www.allenbrowne.com/ser-32.html There are other ways to do it but I'll give this a try.