Search results

Hi, I posted previously that I was having issues getting a form to update a table. Thanks to everyone's help, it's working now. I'm still having one issue though. The form has required fields and I have a custom message box that pops up when one or more field is left blank. When I click "ok"...

Hi, I have a form with the intent that users will enter/select data from various text & combo boxes to update a specific table. I created a button with an "On Click" event that is intended to update the table when clicked and then clear the form. It was working fine, until I added code to...

Hi, I built a search form based off of a query because I need the results to be able to return more than one record. For example, search by ID # and return several rows like so: IDNameCase #Date IssuedLevel12345Mouse, Mickey2222204/11/2018First12345Mouse...

Hi, Trying to figure out why my search form only returns results if I include a date range. I want it to return results if any of the fields contain data or return all results if they are left blank. SELECT tblCorrectiveActions2018.ID, tblCorrectiveActions2018.Name...

Hi, Let me start by saying, while I'm not new to Access, I am new to SQL and VBA...so be gentle I've built a form in a database (Access 2007) that runs a query to search a table and bring back results. The form contains multiple combo boxes. I built it out so the user can enter full or...

Hi, I'm an HR Reporting Consultant in Charlotte, North Carolina. I've searched the forum many times and gotten some excellent solutions...finally decided to join. I guess you would say I'm in mid-level Access user. I can build a pretty nice database but...sadly...I'm no coder and I don't know...