Solved Add and Update record continuous form from another form. (1 Viewer)

[smtazulislam]

I have an employee Facility Item form. Please check form frmEmployeeEdit, In the Items want to click_event open another form which name is frmFacilityItemsEditor.
Q : in the form frmFacilityItemsEditor command button cmdInsertData need click to Add and Update record in the Items textbox add with separate via comma with between colors.
Q : frmFacilityItemsEditor form have a command button SELECT ALL It not work, I have some missing.
Any help will appreciate.

 

[smtazulislam]

Any help ?

 

[pbaldy]

Well for starters, your function doesn't work, you need to add a space before ORDER. It currently resolves to:

",,,FROM tblFacilityItemsORDER BY ..."

Your "Select all" code doesn't make sense. You test a text field and then try to set it to True or False. Looking at it, I suspect you want to set the checkbox, but it's unbound so that won't really accomplish anything anyway. I dump all that and run a update query that sets all records at once. To do that there would need to be a field in the table.

 

[smtazulislam]

",,,FROM tblFacilityItemsORDER BY ..."

Thanks for reply.
It also not work.
Have a error message 3141.

 

[smtazulislam]

Your "Select all" code doesn't make sense. You test a text field and then try to set it to True or False. Looking at it, I suspect you want to set the checkbox, but it's unbound so that won't really accomplish anything anyway. I dump all that and run a update query that sets all records at once. To do that there would need to be a field in the table.

I try to continues form, because I needs to add data more (if need) So, my sense the Continues form needs to a CheckBox, for selection Items.
If it was list box, can click to selection, that all

 

[smtazulislam]

pbaldy One of your helping post in www.accessforums.net/ I try to follow this method, but SQL not run. I failure.

 

[pbaldy]

Not sure what you did. Adding a space before ORDER fixes the function:

  StrSQL = "SELECT tblFacilityItems.FacilityItems, tblFacilityItems.Id, * " & _
           "FROM tblFacilityItems" & _
           " ORDER BY tblFacilityItems.Id;"

In order to be able to select multiple records on a continuous form, the checkbox needs to be bound (have a control source) to a field in the underlying table. Any unbound control will show the same for all records. You can see that in your form by checking or unchecking any record. They all change.

 

[arnelgp]

your form has some problem so i recreate it.

 

[smtazulislam]

Thanks Arnel, nice job. I appreciated.
also I need update SQL for add or update record in the Items textbox add with separate via comma with between colors. exp: if I selected 3 items it 3 color.

 

[smtazulislam]

your form has some problem so i recreate it.

I cant open this Continues Form to click my another Continues Form.
I try click_event, MouseMove_Event. not work.

Private Sub Items_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    DoCmd.OpenForm , "frmFacilityItems", , , , acDialog
End Sub

 

[smtazulislam]

your form has some problem so i recreate it.

Can you give me advice how I insert data in ITEM text box from frmFacityItems form by selection.

 

[arnelgp]

which Table do you want it added?

 

[smtazulislam]

which Table do you want it added?

To add in tblFacilities > Items field from tblFacilityItems

 

[smtazulislam]

any help anyone please ?

 

[arnelgp]

try this.

 

[smtazulislam]

try this.

Thanks for your reply. And I apologize for waste your times.
Please check my message #11 there I uploaded my completed DB, Open frmEmployeeEdit form and click Items field then open frmFacilityItems Form.
Here I need selected Items is added to subform frmFacilitiesSubform > in items field with comma.

Edit/
if each Items have between colors. Example : If i have selected 3 colors and it was added 3 colors [Mobile, TV, Refrigerator] with comma (if possible).

 

[arnelgp]

i already told you, you must use a Bound field for that color to appear.
it won't work on Expression.

its a lot of code for those Makeup.

 

[smtazulislam]

i already told you, you must use a Bound field for that color to appear.
it won't work on Expression.

its a lot of code for those Makeup.

Okay, No need color, because color is not important. Just need data added with comma.
LIKE : Mobile, TV, Refrigerator. OR Mobile; TV; Refrigerator.
Thank you.

 

[smtazulislam]

arnel I need your help Please. Just need selected data added in the fields with comma (,) OR semicolon (; )