Search results

Yup, will be using that in my prototype. I plan to use Allen Brown's code so the search doesn't kick in until a few characters are entered, if that's what you mean.

I have some clients with 30K - 70K clients in their databases and not surprisingly, they would be really happy to have the application in turbo-mode. What I want to do it build a prototype and when I get that right, redevelop some forms in my real application to test it on some users and see if...

Good to know. I'm just trying to figure out why that is. It seems that documentation on this topic is a bit scant. At this point I'm pretty much ready to focus less on the why and start working on a prototype with the one-record search. I am wondering if someone has a working model with subforms.

Let's focus on doing searches based on an index field, as one would usually call up a client based on the primary key which is indexed. You said: That would imply that the ACE/JET BE is intelligent enough to pass back just the requested row. That is a real eye-opener to me and definitely...

I think you're right that reality is probably neither extreme. What matters is that when you request one record that less data is processed and is therefore faster than a table based on a query. I'm not sure if anyone really knows exactly how that works considering the conflicting information I...

Personally I used the good old Me.RecordsetClone.FindFirst "[ID] = " & Me![cboSearch] Me.Bookmark = Me.RecordsetClone.Bookmark Of course they won't be scrolling. :) In that case, the underlying table IS the recordset. Either way, I'll give it a shot and see what happens. Thanks!

I'm talking about, for example, a customer table with tens of thousands of records and the user wants to navigate to a specific record. If I'm reading CJ_London correctly, if the form's recordsource is set to SELECT * FROM tblClients WHERE PK = 1234 then only record 1234 is transferred over the...

And once the records are loaded? Wouldn't navigating through a form that already has the records loaded be comparable or even faster than retrieving the specific record over the network every time the user navigates? I never realized this! I'm not following. If the form is initially opened...

I read through the links and I want to ask about one point you raise. I see the suggestion of not having forms bound to large tables, but rather only access the specific row needed. I have never implemented this method because I have a few questions. I'm hoping someone can help explain the...

I've been using Thunderbird as my email program for about 10 years and I'm completely happy with it. However, your original question seemed to relate to the scheduling aspects, which I don't really use. That's why I didn't suggest ith when I saw the original post.

I use Leban's control and it works really well. You have to do some research because as he says, it's not that well documented. As well, you're going to have to convert existing data to RTF data but it's worth it, IMO! SHADOW

Hey, cool. Welcome from another Torontonian. You've come to the right place for Access help! SHADOW

You're welcome. Glad it worked out. SHADOW

What version of Access are you using? In 2007 and later, you can use rich text. In earlier versions, it's doable but not that simple. I would probably just create multiple labels, format them the way I want it, and then place them next to each other. SHADOW

I use the free version of Tinyspell (http://www.tinyspell.com/) Why don't you check out the product and see if it meets your need? SHADOW

I use Lebans' solution in my Access 2003 projects. It works great: http://www.lebans.com/reporttopdf.htm SHADOW

The description of the question is not quite clear. However, Jack Leach created this awesome demo that I was able to modify for my own needs and incorporate in my projects: http://www.utteraccess.com/forum/index.php?showtopic=1973842 I used version 2. This should be able to steer you. SHADOW

You can turn that off from the Device Manager, finding the LAN card and clicking the Power Settings tab. SHADOW

Can a tool like the Jstreet relinker help you? http://www.jstreettech.com/downloads.aspx SHADOW

If it helps anyone, this is the code I use (credit to Albert Kallal): Function strBackEnd() As String Dim mytables As DAO.TableDef Dim strTempBack As String Dim strFullPath As String strFullPath = "" For Each mytables In CurrentDb.TableDefs If...