Recent content by ITwannabe

Hi all, Thanks so much for all of your input. I followed Frothy's advice and deleted the NextRecord_Click() routine and the button. I had the wizard create a new button and viola!...error 2105 has been banished to the netherworld from whence it came!!! Thanks again everyone :)

@frothingslosh I hit debug and the line that's highlighted is this: Private Sub NextRecord_Click() DoCmd.GoToRecord , , acNewRec I'm getting the error every time I enter a record and hit ok to the custom message box regarding missing fields. Hope this helps. I'm new so I don't always...

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 Pat, Can you tell me what I need to remove and replace with this code? I'm new to VBA and form building in general, which explains the bad form on the control names :( I'm trying to learn on the fly. Thanks!

Minty, Thanks for the quick response and no worries, I didn't think you were being rude. I used your code and it's working :) The only issue is that after you click ok on the message box regarding missing fields, the following run-time error message pops up: Run-time error '2105': You can't...

Thanks Minty, I apologize for not making sense. I'm a novice. I moved the validation code to the Before Update event and added the code you noted to the next button on click event. It will now update the table as long as all of the required fields are completed, which is great. The problem...

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

Thanks for all of the responses. I apologize for being unclear. I'm not a coder so I don't always explain things the right way. I created a query that I want to have users run (using a form) and then update the results if needed. The field being used to run the search is an ID field and there...

Sorry everyone, I should've previewed before I posted. It wasn't supposed to be one continuous string but multiple rows. 1 Record for each. :o

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

Thank you pbaldy that did the trick!!!! You are officially my hero :D no more :banghead:for me!

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

arnelgp, Thanks for the quick reply. I tried removing Like "*" from the date criteria but still have the same issue

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

Learn...how...to...code!!!!