The form I'm creating will allow the user to registar welds based on a numerbic intervale (ex. 1 of 3). Now if the user is only making 1 weld register and click one of the buttons, it saves to the table fine. However if the user is trying to registar more than 1 registar weld (ex: 2 of 3) and clicks a different button on the second of third weld, then the SN for the second and third welds are not saving in the table on a different line.
...
tmdrake
Last Activity: Apr 3 '13, 06:13 PM
Joined: Mar 13 '13
Location:
-
Table not saving records
My form has text and combo boxes that are bound to a table. Upon completion of one entry that infor is saved to table, however when you go to enter the next record, the information from the previous record disappears from the table. I'm not getting error on the form, so I assume everything is working. Please help,for I'm losing information.
Thanks -
this worked, Thanks Seth. -
Saving Form info to table upon button selection
I have a form with three (3) buttons, each performing a different function. My problem is I can't get it to save the information choosen/entered into the combo boxes and\or text boxes. My intention is when the user clicks on a button, the information choosen/entered on that form saves then procees to the next step. Can anyone tell me what's wrong with my codes (I thought Access auto saves, but I guess not).
...Code:Private Sub GOOD_Click()
-
Thanks, Seth and zmbd.
I didn't think you could.Leave a comment:
-
Table Bound to Form Label
Is it possible to bound a label on a form to a table? If so, can someone please explain how.
Thanks in advance. -
Seth, you Rock, it worked.
Thank you so much, now I can move on to the next problem.
ToniLeave a comment:
-
Hi Seth,
I have tried it both ways, but neither is working. With the OpenArgs code, isn't there something that should follow the
Me.OpenArgs?
I've been trying to figure out what the "Where Condition" means.
Any help is appreciates.Leave a comment:
-
Hi Seth, I not getting any error messages. But I did notice something else. If I open the "GeneralTabWeld " form (this is the form where the use makes a selection) first, then wihout using any of the buttons, I open the "GeneralTabPull Test" form, the information transfers. But if the "GeneralTabPull Test" form is called by using a button on the "GeneralTabWeld " form the information does not transfer.
...Leave a comment:
-
Populate text box on new form based on another open form
On my form I have a text box (in the detail section) that populates based on the selection made from a combo box in the header section of my form. Now I need for the information that populates the text box to transfer to another form that opens when the okay in the msgbox is click. I hope this makes since.
Here is the code I've come up with so far:
...Code:Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec Me.CreationDate
-
Thanks, so how do I fix the code to tell it to test value on final count?Leave a comment:
-
That was my point, I not getting any errors, the cursor just blinks in the field. I have tried to trouble shoot it myself before posting. If continuing to request help is a problem, please let me know.Leave a comment:
-
Results not showing in TextBox
Based on the selection in a combo box using a dropdown list (Row Source Table) and the information entered into 2 text boxes, the results should show up in a text box, it's not happening. Don't know what is wrong. Below is the code use to calculate the results that shoud appear.
...Code:Private Sub Text25_Click() Select Case Me.Action Case "NegativePullTest" If Me.PullForce >= 15 And Me.Nuggets -
MsgBox not showing when it should
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 perform a test. Now the problem is the msgbox does not appear until the sixth record is scanned. I sure hope this makes sense,not sure how to fix this problem.... -
Thanks Seth, this worked perfectly.Leave a comment:
-
Opening and Closing Popup Form would be a good title.Leave a comment:
-
Thanks Seth, that worked. Now how do I get the popup form to close on selecting Okay. Below is the code I've come up with so far, but I'm not sure where to go from here.
I need for it to open a form, then close the popup form;
Thank you very much for helping me.Code:Private Sub Yes_Click() DoCmd.OpenForm.:GeneralTabPullTest:Leave a comment:
-
Opening and Closing Popup Form
[Z{Moderator's Comment: This thread was split from the orignial:
> Form Creation Help}]
Got it to work, but now I have a couple of questions regarding the form. I turn the form into a popup, which works great. However, how to I get the initials and the Yes/No choice to save in the table. The form's control source is a table named "EventT" with colums to record the choice and the initals. But when I run...Last edited by zmbd; Mar 19 '13, 10:29 PM. Reason: [Last edited by tmdrake; 3 Hours Ago at 02:13 PM. Reason: Spell Checked ][z{split thread}] -
Thanks Seth, I said it was simple. I think the reason I couldn't get it to work is I was using text boxes instead of label.
ToniLeave a comment:
-
Form Creation Help
I'm sure this question will appear very basic, however, I having a brain freeze moment. Here goes, I am trying to create a form that is basically a text box with a yes or no option, it will go something like this.
Text: "Did you clean Electrodes"
Please enter initals" [text box for intials]
Yes or No
"If yes, please run single cell test] then another form...
No activity results to display
Leave a comment: