Query to Populate List Box

[rocky09]

Hi Brothers,

Is it possible to populate a List box after clicking the Button?

Ok. Here is my situation.

1. Data is on Server (remote location), I have that Access.
2. I built a Form in my local System, which has a Search Field, Button and a List Box.

So, When I enter some string in Search Field and click on the Button, the results should display in the List box.

Is there any way to do this?

Thank you In advance,

Best Regards,
Rocky

 

[Uncle Gizmo]

Is it a front end back end arrangement?

 

[rocky09]

Is it a front end back end arrangement?

Hi,

Thank you very much for you reply. It is a Front End.

You mean, the FORM right?

 

[Uncle Gizmo]

Do you have a Microsoft Access database on the server containing the tables. And everything else in a separate database on the individual users desktops?

 

[rocky09]

Do you have a Microsoft Access database on the server containing the tables. And everything else in a separate database on the individual users desktops?

Hi Thank you very much for your reply.

the tables [linked from Server] and Form are in the Same Access Database.

 

[Uncle Gizmo]

So it is the answer to my question yes or no?

 

[rocky09]

So it is the answer to my question yes or no?

Hi Sir,

First of all, thank you so much for your replies.

Actually, I am accessing tables from SQL Server [link table option]. Then, I have created a form to display the desired results.

I have created a Blank Access database in my local system and used ODBC Database option from External Database and linked the tables from the Server. Now, I am trying to create a Search Form to display only searched results.

Please let me know, if I am not clear.

Thank you very much once again.

 

[Uncle Gizmo]

The first step would be to create a query in the Query Designer grid. This query should return results based on the criteria you enter into the text box.

 

[rocky09]

The first step would be to create a query in the Query Designer grid. This query should return results based on the criteria you enter into the text box.

Hi,

Thank you very much again.

I am following John's Method , When I am running Only query, I am getting results very quickly. But, when I trying to open the Form, it is taking nearly 6 - 10 Minutes to load.

 

[Uncle Gizmo]

How long does your form take to open if you remove the query from it?

 

[rocky09]

How long does your form take to open if you remove the query from it?

just taking seconds.

 

[Uncle Gizmo]

I suggest you forget about John's method for now and just get a simple query working first, otherwise there are too many uncontrollable elements to your problem.

 

[rocky09]

I suggest you forget about John's method for now and just get a simple query working first, otherwise there are too many uncontrollable elements to your problem.

Thank you. I will try to make it as simple and let you know the update. Thank you very much for your time.

 

[rocky09]

John's design is based on the "On Change" event. This technique can slow down your searches. Especially if you have large data sets. I would follow Uncle Gizmo's advice and get a select query to return results. Then go from there.

Hi,

Thank you so much for your reply. Can I get an example for the Select Query to display the results in the list box?

Best Regards,
Rocky

 

[rocky09]

Create new a query in the QBE, add the relevant table(s). Run this query to see if you a pulling in all desired records. Once you are satisfied with it save it and base your list box on the new query. Then you move to more complex operations.

Hi Brother,

Thank you very much for your reply. I have already done this. But, when I assign the query to the List Box and when I trying to open the Form. It is taking nearly 10 - 15 minutes to load the form.