Search results

Okay, I been trying to figure this out with bothering you and appearing to be stupid, but I can't get it. You assistance is truly appreaciated. This is the code for all three buttons and the invisible text box. Please tell what I'm doing wrong. The code for all three is located on the "on...

It worked perfectly when I put the code in the first button "Good", however when I put in the OnClick for the second button 'POP" I got the following error: "Ambiguous name detected: ButtonClicked" this is the code: Private Sub POP_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm...

Did what you suggested; however I recived an error "Runtime error '424': object required. Here is where I place the code you suggested. What am I doing wrong? Private Sub GOOD_Click() DoCmd.RunCommand acCmdSaveRecord If Not IsNull(Me.SN.Value) Then LastPosSN = Me.SN.Value End If If...

I'm still not sure where to put the code among the code already there. I am trying to put the click results in the table bound to the form where the button is located. I just want the name of the button to be stored in the table, ie "Good", "POP, "Good". The code already there is on the...

I'm sorry, they can only click one button per record.

No the buttons have different functions, below is the codes for the buttons: "Good" Button Private Sub GOOD_Click() If Not IsNull(Me.SN.Value) Then LastPosSN = Me.SN.Value End If If PosPullTestCount = Me.PullTestNum.Value Then MsgBox "Time to perform a pull-test on a scrap cell!"...

I have three (3) command buttons on a form that perform various task, is there a way to record the button choosen by the user to a table? Any help is greatly appreciated.

My form has a reset button that clean all fileds expect date field and its suppose to start the interval count @ 1, however it clears the fields but the interval change does not reset. Not sure how to fix this. Help is greatly appreciated. Here is the code I'm using: Private Sub...

Assuming you meant putting the code in the AfterUpdate, however when I did that, even if I clicked on the field, the results did not show. If my assumption is incorrect, please let me know what code should I have put in the AfterUpdate. Thanks

Actually after testing, I have another question on the same topic. Is there anyway to have the results appear without having to click on the field "TestResults". Right now it works when the cursor is put in that TestResults field.

Thank you both, using both methods, I got it to work.

My form contains a combo box "Action" (the resource for the combo box is a table) where the user can select the type of test is being performed. Then there are two text boxes "Pull Force" and Nuggets" where the user enters certain parameters regarding the test. Now based on the selection made...

Thank you, that worked.l:):)

I have a form where the is an unbound textbox in header of the form where the user will enter how many weld are scanned before a pull test is performed. Next to it are two text boxes counting the scans, example: 1 of 5. Once the interval of 5 is reached a msgbox appears telling the user to...

Hi Everyone, I found this site by qoogling help for MS Access. I live in Houston, Texas and I'm familiar with Access, but do not use it often enough to go without help. Thanks