Search results

Is there a way I can make a button that will map all the addresses from a table (200+) at once? I'm having a problem with duplicate locations as different address listings and think a map of locations would help solve this issue. Any input is welcome. Thanks.

Thank you! I try to avoid spaces, but this is my working document. When it goes final I'll be sure I have a cleaner database. Thanks though.

I have this set up with text box serach fields. It works great for the search. However, once I have clicked 'search' I can no longer edit the fields I need. What am I missing? How can I make it so I can edit the fields after I search for them?

I have between 4 and 6 multi-select list boxes in a search form. I would like to have the user be able to select one or 2 options from each list box, then click serach and get the results they selected. Here is the code I'm modeling mine around. I had it working with just one list box and 2...

With the above posted database I'm still not able to search for the two word towns (i.e. Saint Paul) without getting an error. The one word town work and I don't think I have any table-level lookups. As I've read other posts I've noticed that everybody says the table needs to show the number...

I get File Now Found from your link. Is this more how I should have it set up? Now I'm having a hard time understanding the search feature and also limiting data input to specific options (i.e. city name). You people have been a great help. I really appreciate this.

As I read through these 'evils of table-level lookups' I am getting a little more confused. Table-level lookup would be where I have my city, county, and other drop downs in the table?

bump... Any help is appreciated. Thanks!

Here it is...

I guess I'm not understanding. Like I said, I'm new and this. Sorry for the dumb questions.

Ok, here is what I have. I'm new to this, but it looks like my quotes follow what you've said. Correct me if I'm wrong. Option Compare Database Option Explicit Private Sub btnSearch_Click() 'Updates the record source Me.[QryMasterDataList subform].Form.RecordSource = "SELECT * FROM...

I have a list of cities here in MN. Obviously some are two words. When I input any two word city into my search (select from a drop down list) I get an error. However, the one word cities work fine. Is there a way I can fix this? The error I receive is: Run-Time error '3075': Synax error...

Works perfect, thank you!

I have the update Query in place and it works when I manually run it. Now how do I make it run on exit? Sorry for my ignorance, I'm still learning a lot about Access. Your help has been invaluable.

When I set this up it only reverts the selected entry back to "no". How to I get all of the entries back to "no"?

I need to create (code or macro) a button on my form that will revert all entries under one field on a subform back to "No". I have a form with a search function in it. The user can search for various parts of an address or name and click search. The results are shown in the subform. In...

I have a rather large list of locations that are filtered down to a manageble size based on what an employee needs (6 criteria options). The employee then needs to pick a couple locations (say 5 of the 10 results) and print/email just those 5 locations, not all 10. I'm happy to give more...

I'm putting together a database to select and assign locations to employees. Each manager will assign between 5 and 25 locations at one time to one employee. The list will consist of somewhere between 500 and 1000 locations and will forever be growing as more locations come in. What I'm...

I'm looking to purchase a good book for beginner Access as well as more advanced features. I was curious if there were any recommendations? I'm looking for something besides the "Access for Dummies" suggestion.

I have a Report Title and Employee ID in the Report Header. Then in the detail section I have all the data from the search. Then in the Report Footer I have the current date and the page numbers. Attached is a screenshot of the report. Unfortunately I can't upload the database due to...