Forum Discussion

Storming's avatar
Storming
Brass Contributor
Feb 07, 2024

Unable to open a Word document maximised

Hi, I have tried several suggestions from the web to open a Word document maximised from my Access application. All are opening the document but not maximising it. My current code is    Set myWo...
2016
access
arnel_gp's avatar
arnel_gp
Steel Contributor
Feb 08, 2024

Storming i added WorkID (Foreign Key) on table [Work job list]. this id refers to the WorkID of Work table. instead of Word, i created a report (with subReport), WorkQuote. see the report.

Storming's avatar
Storming
Brass Contributor
Feb 09, 2024

arnel_gp 

 

Many thanks for your help, it is working great now.

If you don't mind I have 2 last questions:

1) how do i get a footer on the 1st page only

2) where it prints

yours sincerely,

Signature

Typed name

 

Sometimes these 3 lines get split across 2 pages, is it possible to group them so that it would print the 3 lines on the 2nd page if it could not get them all on the 1st page.

  • Storming's avatar
    Storming
    Brass Contributor
    Feb 17, 2024

    Many, many thanks to arnel_gp.

    You have been a star in helping me with this and several other queries. 

  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Feb 10, 2024

    Storming refresh your screen (F5), i updated my previous post.

  • Storming's avatar
    Storming
    Brass Contributor
    Feb 10, 2024
    Hi, it has removed your email address.
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Feb 10, 2024

    Storming , my email: agpuzonATgmail.com.

    the AT there is the ampersand symbol, this site remove it for security purpose.

    or put it on Onedrive/google drive, etc and email me the link.

  • Storming's avatar
    Storming
    Brass Contributor
    Feb 10, 2024
    Can I send it to you personally?
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Feb 10, 2024

    Storming, please upload your latest db again with data.

  • Storming's avatar
    Storming
    Brass Contributor
    Feb 10, 2024

    Hi arnel_gp 

     

    are you sure this is working?

    I am getting a variable number of lines on 1st page (up to 24) and nothing on the second page when there are futher work lines to print.

     

    Would it be easier if i sent you my current version?

  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Feb 09, 2024

    Storming you can play with this demo (WorkQuote3 report). it has some vba on the Open event of the report, so it maintains a constant 15 lines on the detail section. also see the Signature on signatory table.