Fetch multiple data in a text box in access vba

[prithwisaha]

I have a table with 5 parameters. I want to show all the 5 parameters data in a text box when click on check data button in the access form. Whenever data is saved via form in a table the last datas will be shown in the text box when check button will be clicked. How?? Please help.

[CJ_London]

to clarify what you require please supply some example data and the result required from that example data

[prithwisaha]

Please check the table

I want all the data from rows to be fetched in a text box when i click on check sms button in an access form:

[June7]

I don't understand what you want. The image does not show what you want the result to be. Give us a mock-up or a better explanation.

Why do the textboxes not show the same values of the record in the table?

[prithwisaha]

I am sending the database with form.
Please check the codes in vba. When i click on save the data in text boxes will be saved in the table. My requirement is that all the data that will be saved when i click on checksms button it will be shown in the right hand side text box. After that what i will do is i will send the contents of the text box through sms by clicking sendsms button which is pending not yet done.CHECK DATA.zip

[davegri]

Please check the codes in vba. When i click on save the data in text boxes will be saved in the table

Above is working. However, each time you click, a copy of the record will be saved resulting in duplicates.

My requirement is that all the data that will be saved when i click on checksms button it will be shown in the right hand side text box.

So this button saves the record to the table same as the Save Table button? Don't see point of displaying the data in the right textbox. Why not just process the data shown in the individual textboxes?


Perhaps you could explain the purpose of your database so that we could better understand the requirements to be resolved.

[prithwisaha]

The user will check the data in the text box as entered in the database. after that there will be send sms button in which when clicked the data that is shown in the text box will be send to selected users.

steps are :
open form
insert data in db using save button
check the current same saved data in the text box
click on send sms button to send the data as seen in the text box as mobile sms over gateway to selected users.

[davegri]

Still don't see the point of showing same data in the right textbox unless maybe you want to show more than one record. Is that the case?
What should the right textbox look like when filled with the data - how would you like it formatted?

[prithwisaha]

I need the form as it is with the textbox. The textbox will let the users check the current data that is entered in the table and after checking the same content will be send via sms when they will click on the send sms button.

[davegri]

See post #8. You have not provided the information.
How-do-you-want-the-right-textbox-to-look-when-it-is-filled-with-the-data?
I can't help you without this information.
Please show an exact sample.

[prithwisaha]

please check the attached file:

[June7]

Really serves no purpose to repeat the data in the single textbox. However, if you must, an expression in textbox ControlSource:

=[Entry_Date] & Chr(13) & Chr(10) & [Shift] & Chr(13) & Chr(10) & [Status] & Chr(13) & Chr(10) & [Size_Dn] & Chr(13) & Chr(10) & [Gauge_Dia] & Chr(13) & Chr(10) & [Load] & Chr(13) & Chr(10) & [Hardness] & Chr(13) & Chr(10) & [Time]


Data is committed to table when: 1) close table/query/form or 2) move to new record or 3) run code to save.

Form and controls are bound to table and fields, the VBA code to save data is unnecessary and, as davegri pointed out, creates duplicate record. Change the code to simply:

DoCmd.RunCommand acCmdSaveRecord

or

DoCmd.GoToRecord , , acNewRec


You have code for sending via SMS? As far as I can tell, this is very difficult.

[prithwisaha]

Thanks a lot. will get back to you with the updated database. can u give your cell number so that i can msg you from the app.

[June7]

No, cannot have my number. You will have to message yourself.

[prithwisaha]

OK. i AM GETTING THE SMS, But on a single line. i need to show the data in the text box with the headers also.