User Profile
Storming
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Unable to open a Word document maximised
Hiarnel_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?1.3KViews0likes6CommentsRe: Unable to open a Word document maximised
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.1.3KViews0likes8CommentsRe: Unable to open a Word document maximised
arnel_gp Hi, I have attached a cut down version of the database but the main items are there to create the mailmerge. The WORK table will only ever have 1 row in it (different customer each time) and the WORK JOB LIST table holds the work to be done. Thanks again for your help1.4KViews0likes10CommentsRe: Unable to open a Word document maximised
Thanks, I will try that. If you don't mind can I ask another question please? I want to use 2 tables in my letter. The main merge is based on my customer table. I am trying to list in the letter a table of work items and have tried the following code but it is not working {DATABASE \d "c:\\Users\\Norman\\Desktop\\Arron.accdb" \s "SELECT [Work job list].Room, [Work job list].Item, [Work job list].Description FROM [Work job list] \h} Any suggestions please?1.4KViews0likes13CommentsUnable 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 myWord = CreateObject("Word.Application") myWord.Visible = True myWord.Documents.Open FileName:="C:\Users\Norman\Desktop\template for estimates.docx", ReadOnly:=True With myWord .Application.WindowState = 1 .ActiveWindow.ActivePane.View.Zoom.Percentage = 100 End With Set myWord = Nothing End Sub Anyone any suggestions please?1.6KViews0likes19CommentsRe: Margins
Doug_Robbins_Word_MVP Apologies Doug, but could you explain that further. In the header I have the club logo and club name, then a table with social media links in and then a purple line to mark end of header. That header is set to indents of 0. I then have a table containing social media links and then a purple line to end the header. I then have the section break and a blank line which has indents of 1.5 right and 1 left. The user starts their letter at this blank line. When the user then needs to write a new letter they obviously need to delete the existing. Doing this allows them to delete the section break line which then automatically changes the header indents. I could send you the file if you would like to have a look at it. Many thanks for your help.862Views0likes3CommentsMargins
Hi all, I am designing a letterhead template. I have set up a header with specific margins. In the body I have added a section break and formatted that section to use different margins. It works fine until the user deletes the body lines and also deletes the section break causing the margins to be wrong again. Has anyone any idea how to possibly protect the section break line? I tried the protection option but the unprotected body lines then display in yellow surrounded with brackets which I do not want.Solved917Views0likes5CommentsRe: Macros not opening
Karl_Donaubauer Thanks Karl. I had already tried that but all objects would not import and the import kept failing. I have finally identified 2 form objects which would not import. So I have created a new database with all objects except those 2 and reimported the 2 from an earlier back up I had. All appears to be working now, thanks for your help.1.5KViews0likes0CommentsMacros not opening
Hi, my Access database which has been running for 4 years has all of a sudden developed a problem with macros. I can edit all objects no problem apart from when I try to edit any macro the databse just closes. I am running Access 2016 on a Windows 10 laptop, all software is up to date. Can anyone help please?Solved1.6KViews0likes2CommentsOpening a Word document from within Access
I am trying to open a Word document containing the user manual at different bookmarks depending on which form the user is on. I have the following code:- Private Sub Command35_Click() Dim strPath As String strPath = "C:\Users\norma\Desktop\Phili CCC business management system user manual.docx" Dim objWord As Object Dim docWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True Set docWord = objWord.Documents.Open(FileName:=strPath, ReadOnly:=True) docWord.Bookmarks("MainMenu").Select objWord.Activate WindowState = wdWindowStateMaximised End Sub The Word document opens fine but I can not get it to be maximised. The other problem is that the Word document opens at the bookmark but the bookmark is at the bottom of the maximised screen showing half of the previous page above it. See attachment. Any idea how to resolve that please so that the bookmark starts at the top of the page?911Views0likes0Comments
Recent Blog Articles
No content to show