Search results

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

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

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

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

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

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

Hi guys… I’m using Access 97 and am having a problem that I think I need to solve by somehow reinitializing either my form or a combo box. If I close the form and then re open it, then I have no problems. My form starts with focus on an unbound control where I enter a part number. From...

Hi All, When I use 'Not In List' with my combo box, I keep getting an informational msg telling me that "The text you entered isn't an item in the list. OK". I've tried to turn off system messages using: DoCmd.SetWarnings False ..in several places such as after update of the combobox, in Not...

Hi all, I have a combo box that successfully queries, getting criteria from 2 unbound controls. It returns either a Null or returns only 1 record. This then becomes the grist of an If, Than, Else statement. Because I want the user to avoid using a mouse to interact with the form, I am told...

Hi all, I am at my witts end in trying to figure out how I can select a record from a list box without using a mouse or keyboard command. In my box, there is either 0 records found or 1 record found (there will never be more than 1 found). I requery the box on GotFocus, and I use KeyDown to...

Hi All, About a week ago, I got some advice here, part of which still confuses me. I was (am) trying to get my query to take the value of a control on my form, and use it as one of the criteria in my query (That part works great thanks to charityg!). What I need to do is to move a quantity...

Hi all, I have 2 questions: Q1) I am trying to use the contents of an unbound control on my form to be one of 2 criteria used by a query in a combo box (ComboBoxB). The unbound control gets automaticly filled in after the update of Combo Box A using the following code:[UBPartNumber] =...

Hi all: Maybe you could help me with another bug I’m having. I have a form with 2 combo boxes. One queries by a part’s number, and the other queries by a combination of a part’s machine type and description. The user selects either one of them for the purpose of adding more parts into the...

Hi all, Just a quickie here...How do I get a combo box to NOT get automatically get requeried after a record is duplicated and appended to the table? It is set to run 'AfterUpdate', and I want to avoid using a command button on the form. Thanks in advance, chuck

Hi all, I’m having a problem using VB code to close one of my forms. Unlike the failing form, I successfully use the command: DoCmd.Close in a form that prints a report just prior to the Close command. The failing form, however, creates a new record as a part of its completion and that seems...

Hi all, Please, help me through this...I've looked at various similar posts here in the Reports forum, I know what I'm supposed to do, but I'm still unable to get this to work. I have the folowing code in my form: DoCmd.OpenReport "Return Form for ChuckG Rpt", acViewNormal I know that I...

Hello, Perhaps someone can help me with this one. I am trying to have a 'current' form print automaticly when the form has been filled out completly. The last event that properly happens on the form is that a Pop-up form appears and prompts the user to take action from there. The print code...

Hi everybody, Hope sombody can help here. I've been very frustrated in trying to get a text box called Test to work to keep a user from returning more parts to the inventory (on the form) than he/she really has (finger checks when entering in the amount they are returning). The code is as...