Recent content by mechwarrior3

As a head's up, my problem was with the recordset type, like you said, Pat. I tried using a dbOpenDynaset at my .OpenRecordset command instead of dbOpenTable and it worked. Everything is good now. :) Thanks again for your help, Pat. :)

First off, I'd like to say thanks, Pat for your quick response. :) Unfortunately, those modifications did not work. I still get the same run-time error. I tried it with the .Value property and without. I even switched the data type of the dummy variables to Variant, with no change. I am using...

This thread seems to be exactly what I am looking for. However, trying the code you suggested, Pat, still results in an error. I have a table with several fields. I want to find a record based off of two of these fields, called MfgLotNum and MixLotNum. Both are text fields. This is what I am...

Just wanted to throw in a quick "thank you" to Wayne as well. I was searching the forums for a solution to this very problem. I stumbled upon this and "BAM". Problem fixed. :) Good call, Wayne. :)

Bingo! :) That was exactly what I needed. Thank you so much, Sammy B! :D They work even better than those updown buttons because when I set the .Value property on the spin button, it does not make a call to the spin button's change method. That was an issue I ran into with the updown buttons...

Good afternoon. I am brand new to posting on this forum but I have been using this forum for help since I started my new job and I would like to start off with thanking you all for that. :) Now onto my problem: I am currently trying to create a form in Access 2003 that can be easily read and...