Thank you fvdb.
I think I am starting to make progress. I am just confused with txtboxcolumn = true. Would this be an unbound field? I have it as a bound field right now otherwise when I check the unbound check box in the Form for a record then all of the records get automatically selected.
Hi fvdb,
You are correct with the first statement. The checkbox is checked in the form which is based on a query.
And I have now figured out that I need to use a recordset. I get confused since I have a for/next and if and I am not sure where the rst lines must be incorporated. Could you please...
Thank you James and fvdb!
That solved the error but when I export click on the command button only the first record that has its check box checked gets exported. Do you have an idea how I can export all of the checked records?
My word template only has the fields entered once but even if I...
Thanks for the help plog!
My apologies, I only copied part of the script, here is the rest where I have included a End with statement.
Private Sub Command19_Click()
Dim appWD As Word.Application
Dim WordApp As Word.Application
Dim doc As Word.Document
Dim ctl As Control
On...
Hi,
I have created a form based on a query where the user can select the records (using a check box named Chk1 which is bound to a yes/no field in the Table) that he/she wants to have exported to a word template (with field codes). The user must be able to select several records and all of...
Thank you Ranman256 for your response.
I apologize, I am still an Access amateur. What does breakline mean? also If I move my cursor over Me.ProjectName nothing happens. and Yes the fieldnames in the word document is corrcet.
Thanks again.
Hi,
I would like to export a form entry to a word template. I have VBA code connected to a command button, however, although a new word document opens upon execution, the fields are not populated (the word document remains empty). Please advise!
here is my code:
Private Sub Command694_Click()...
Hi,
I have a database of different projects (that various employees have worked on) and then a query that selects the projects for each employee. I want the user to then select projects (relevant to that employee) that must be exported to a word template. How can I incorporate check boxes into...