Recent content by atadbitslow

Thanks you both very much! I appreciate your help and I hope to get to the project today. I'll let you know if I am successful at getting it to work! Thanks again!

Hi, Thank you very much for your reply. I'm too much of a beginner to know what to do with that statement in regards to the form I have. I tried to create a query but it didn't produce any results even though there are organizations that have the string I entered into the search box...

Hi, I have a form that I'd like users to be able to enter a partial word/string of letters and records that include the partial word/string of letters will display. For example, the search is to be done on a field called 'organization'. Needing a user to type in the exact way an organization...

Hi, I think I'll use NZ() which is what I thought of trying on my own, but didn't. I haven't updated the code just yet, will do today. Thank you both!

Thank you both very much! One table is imported data from our online dashboard and is used to update our existing data in our Access database. So not really same data in two places. The imported data table is cleared after each session.

Thanks for your response. The question is why when comparing data in one field in a table to a field in a different table that has no data, why are the two fields not being recognized as being unequal?

Hi, I have two subforms on a form and I have VBA code that compares the fields on one subform to the other subform. If the fields don't match, I have a button for the user to click on to update the data in the field that doesn't match. It's basically: If...

Thanks very much! That did the trick!

Hi, I have this expression in a query. I can't figure out how to get the date the user will enter to work with the criteria. DLookUp("res_begin_start","zoom meetings tab","zoom_meeting_date=" & #[Please enter meeting date: mm/dd/yyyy]#) Thank you!

Hi, I will be upgrading our A2010 database, but I'm trying to decide whether to upgrade it to A2013 or A2016. I was hoping to get some feedback on any issues that others may have had with either of these versions. Any advice would be very much appreciated. Thank you!

Thanks! Most appreciated!

Thanks Duane.....I had clicked on "Great Post" yesterday, but missed the link to confirm it......done now!

Thanks so much!!

Hi, I have a form where a user can enter a name to search for and another form opens with the results of the search. The search does not work if a name that is being searched has an apostrophe, such as O'Leary and I know it's because I don't have the syntax correct in the code below, but I...

What is the best way to create a listserv using email addresses in an Access database? We often need to send email to large groups of people in our database. One of the problems is that our mail server only allows us to send out 50 emails at one time, unless we send them out under a group...