Search results

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

Thanks all...great grist for thought! I am using the wedge as described, and it is very possible that the receiving program is still "comming up" or doing some other processing at the time of the scan. As for the speed of transfer, I will look into that. The PC is a rather old and down level...

Al... Thanks for the reply. I have to plead ignorant when it comes to what a KB Wedge is. In response to your question regarding inconsistent scaning: It is not the same characters or same number of characters that fail to be read. For example: I have a test part number of 3333-3333...

Hi all...I don't know if this is a weak spot in access 97 or not, but here we go. I am finally and successfully able to print a barcode lable (code 3 of 9 non-extended)for each part that gets returned back into inventory from my form, thanks to some freeware written by a fellow named James...

Nathan: I receintly go some help from this board that covered a very similar need I had. I'll paste the entire code, you modify as needed. It works great! Private Sub Combo40_NotInList(NewData As String, Response As Integer) [(A)Shelf Quantity] = [ctlUpdatedOrigLocQty] Dim dbsMyDatabase...

Travis...thanks for the reply! I had some luck with the Combo.RowSource = "" whereby it successfully got the drop down of the combo box to be blank, but still the query on the fly (as I type in a location), is missing. It doesn't see the part number at that location (I happen to know that...