Recent content by chuckgoss

Thanks Pat!

Wayne! It's works SOOOO... good! It increments great. I tried it also on earlier contract numbers that have the numerical piece begin with '0' such as: EMC-0814, and, unusually enough, it comes back with EMC-815, not showing the zero. I don't think I'll need to deal with that phenomenon in...

Hi all... I have searched this and other forums for how to do this. Found some hits regarding similar problems, but I just can't make it work. I am trying to increment a contract number (beginning with the one of greatest numerical value in my table) by 1 whenever a new contract number is...

CharityG! I did as you said and indeed the library was NOT checked off! Now it is, and I have 'Database' once again! Thank you very much! Chuck

Hi all... I'm trying to add a new record to a table that is not the record source for my main form. In fact, the Main form is displaying only the results of queries. In the past on other projects, I have been able to use the following method: Dim db As Database Dim rst1 As Recordset Set db =...

Hi all… I have an If statement that works intermittently, and I can’t see why. I have a form that begins with the focus being on a combo box upon load. The user keys in a record number for editing, hits the enter key, and the record appears just fine. There is a ‘next record’ button that...

Thanks for your quick reply Chris...I try those when I get to work! chuck

Hi all... I have a need to know what the code would be to delete a record in a subform from a delete button in the main form. There may be a few records there that are related to the mainform, but I'm pretty confident that I could get all of them, if I could only get to the first one and tell...

Hi all... In access 2000 I can't get past this error on one form. It is trying to update a table by incrementing to a next record, doing some things, and going onto the next record till it runs out of records. I haven't been able to find it is searches here or in access help either. Any...

When I used that method of making null the combo box in my application, it would empty the field in the table of the record that the combo box initially displayed. Sure it would show a null, but it showed it because it had made the field on the table null. chuck

I have resolved this many times throughout the forms in my switchboard. It's cheating but I make an unbound textbox (called ctlCoverup or something)- tab stop NO, place it over the text portion of the combobox, and at the appropriate time make it visible = True, or visible = False. When placed...

Hi all, I’ve been having trouble getting a textbox to disappear after a predetermined period of time. Ultimately, it will not be a text box, but a combination of both a button and a flashing square that surrounds the button that will disappear. Basicly, the button is to close the form, and...

JWT...I hope I understand your problem correctly. This is what I did. I had a need to print multiple labels based on the quantity typed (listed) in a field on a form. The query already had the record pulled up that provided all the details for my label. I use a loop to print multiple reports...

Jack...Thanks a lot. I'll give it a try. Sounds like a workable solution. chuck

Hi all, I have come so far, but this one still stumps me. I am scanning part number barcodes (3 of 9 non-enhanced) into Access 97. When I scan directly into a combo box or any other control on my form, the part number appears perfectly every time. When I scan into a prompt brought about by...