Recent content by Minnesota

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"?