PDA

View Full Version : Save Record from continious form


sbbmaster09
06-08-2016, 10:56 AM
I have a continuous form where when I select the dropdown it will update all the fields, then I filter team field it will only select that team then hitting the Save command, it will enter all the details in the table at once. It will record each line in the continuous form to the table.

Any help on this? Thanks.
SamT
06-08-2016, 12:50 PM
You say that your form updates the fields.
you say that your form Filters the data
You say that your form Updates the Table

It sounds like it is working. What more do you want?
sbbmaster09
06-09-2016, 02:28 AM
You say that your form updates the fields.
you say that your form Filters the data
You say that your form Updates the Table

It sounds like it is working. What more do you want?


hitting the Save command, it will enter all the details in the table at once.

With the selected filter and the date it will save all the names in the table with the selected inputs.

Process Flow:
1] The form opens with all the names from a query (continuous form)
2] Filter the Team from the dropdown and will only show members from that Team
3] Will select status either Holiday or Vacation Leave
4] Select date on where to apply
5] Save button to add all the names with the Team name, selected status and date.

It was kinda bulk saving instead of one by one. Thanks,
SamT
06-09-2016, 05:06 AM
Can you show us the code that your are using now?

Select and copy the code in your VBA Editor, then In the Forum Editor, click the # Icon on the menu to insert CODE tags, then Paste (the copied code) at the cursor between the CODE Tags.
sbbmaster09
06-09-2016, 07:40 AM
Hi, I only have the code for the status


Private Sub UpdShift_AfterUpdate() Me.txtStatus.Value = Me.UpdShift.Value
End Sub

Because the date is in a calendar button which applies to all.

I don't have the code for the Save button.
SamT
06-09-2016, 11:21 AM
Surely there is more code in the UserForm that just the one button.

If you use the "Go Advanced" Button, below the Advanced Editor is a "Manage Attachments" button that will let you upload the Workbook,
sbbmaster09
06-10-2016, 06:55 AM
Surely there is more code in the UserForm that just the one button.

If you use the "Go Advanced" Button, below the Advanced Editor is a "Manage Attachments" button that will let you upload the Workbook,

There is no more codes I have. And it is in MS Access.