Search results

I've been talking with a couple of other people on this forum to get help on improving query response time. That problem has been solved. I thought it might be beneficial to display the returning record count. I was hoping there was a way for the query to give record count as soon as the...

'Behind the scenes'. Might that add to the query response time; i.e., to the time it takes for query results to be returned?

They know the approximate name and probably general location of the business they are looking for. For instance, a Mr. John Doe may own a financial advisor business in California. The name of the company may actually be Doe Financial, Inc., or John Doe, LLC, or Doe Enterprises, Inc. So...

Never heard of cascading combos. Is that covered in the example you referenced? User spec problems and networking issues are yet to be discovered, if any, as this is a new application for them.

The state and zip fields on the database are indexed duplicates okay. Also, their query statement says 'equal' and not 'like', meaning user must enter exact values. If I include the state or zip with the partial name search, I get 2-3 second response. That makes sense because Access probably...

All of the search fields are indexed (dups allowed) which of course is useless for the wildcard fields. I should probably remove those indices. The state and zip fields are not wildcarded and expect user to input exact value. As I said earlier, the results are displayed in list box middle of...

The query results are placed in a list box bottom of form. User can scroll the results list, find the record that he wants and double click it. The full record is then displayed at bottom of form, including those record fields that are not searchable.

The back end is .7GB and has 1.8 M records, 3 of the 5 fields ( name, address, city) can be partially filled with search argument. When I put any value in those 3 fields, response is 14 secs. I'm running W10, Office 365 with an Intel I7 4Ghz proc and 16GB mem, using WD NAS.

Good news. I reprogrammed building the sql string, so that instead of including all of the searchable form fields in the sql string, I included only the form's search fields that had an argument. So, even with using the 'Like' command on the name field, I am getting response times under 10 secs.

How can I save the record count from query results without rerunning a count query? Thanks.

Thanks to both of you. To jdraw, we have no control over standardizing names. The data comes via subscription from web site and it is what it is. The looked up record is used to get current address of the business. The looked up business address will be manually copied by some method to local...

I'm importing about 2 million .csv records into Access. The records contains 5 searchable fields (name, address, city, state, zip). These are business name and address records where the names and addresses are formatted differently; i.e., I cannot expect the user to precisely know the name...

Is there a way that I can give a single user the ability to change the 'ShowToolBar' command from yes to no and vice versa on a VBA 'Locked for Viewing' database without sharing the VBA project password? I'd rather not create a table, or dynamically modify the VBA code. Is there a load Access...

Think I figured it out. Included a Me.refresh and a DoCmd.Close at end of After-Update event code. Would that be the correct way to do it?

Hello again. Still learning about forms. Any help is appreciated. I've followed some YouTube videos on the subject and am trying to create a form with some search boxes and a list box. Without posting my code, I wonder if there is a simple answer to this question: When I enter the values...

I made the change that arnelgp suggested and will wait for the user to test. To CJ, the missing property is not displayed in the error message, and the error line is not displayed either. I built code using Access 2007 (though I have Access 2013 on another device), and the user is on...

Need help please. Created a form with buttons that work fine for me. The form is on a front-end database that is linked to a back-end on a remote server. When I mail the front-end db to an end-user, he can link to the back-end, but when he opens the form and clicks on the 'search' button, he...

Just to be clear, I do not want to autofit the fields on the form. When a query is executed and it returns a result table, I want to autofit its columns. Thanks.

How can I auto fit the column widths on a datasheet view that results from a query? Thanks.

Rowey, what do mean by the FE and BE are both on the same server? I thought the FE's would be on each user's PC. Can you give me any more info on the hired TS? How do you go about finding a TS provider? I just Googled that and up popped Amazon Lightsail. Is that suitable? Thanks.