Recent content by Mwam

  1. M

    Compile error: end if without block if

    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.
  2. M

    Compile error: end if without block if

    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...
  3. M

    Compile error: end if without block if

    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...
  4. M

    Compile error: end if without block if

    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...
  5. M

    Compile error: end if without block if

    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...
  6. M

    allow user to check boxes for records that need to be exporte dto word template

    Yes, sounds like that could work since I want the user to be able to select multiple projects. How can I create such a list? Thanks!
  7. M

    allow user to check boxes for records that need to be exporte dto word template

    Thank you for the response pbaldy. could you please expand on what you mean by a "multi-select listbox"? thanks
  8. M

    Export to word template using VBA does not work

    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.
  9. M

    Export to word template using VBA does not work

    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()...
  10. M

    allow user to check boxes for records that need to be exporte dto word template

    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...
  11. M

    hallo

    hallo form toronto
Back
Top Bottom