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.

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...

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...

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 form that allows the user to perform a search. I have the results of that search going to a report. So far it all works flawlessly. The problem is when you view the report it only shows the first result of the search. How do I make the report repeat the same format over and over...

I have a form that is somewhat based on this sample. I have the search working perfectly. Now I would like to take the search results and email, print, and/or save to a file (xls, html...). I have been able to set it up so I get the XLS file (to email or save), but it includes all the data...