Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shuttlelaunch

    Command Button Mail Merge stopped working when I added a Password

    I used to use the code below on a command button in Access to fill form letter (.docx). If Me.Dirty Then Me.Dirty = False Set ObjWord = GetObject("C:\MY DOCUMENTS\FORM LETTER.docx", "Word.Document") ObjWord.Application.Visible = True ObjWord.MailMerge.OpenDataSource _ Name:=" C:\MY...
  2. shuttlelaunch

    Access Mail Merge VBA Help

    Would all of that go into the Command Button On Click event?
  3. shuttlelaunch

    Access Mail Merge VBA Help

    When are viewing the database through a Form, the specific record you are looking at, not the whole table. If I wanted to print a report with just that record, I use the code: DoCmd.OpenReport "LETTER_COMRATS", acViewPreview, , "ID=" & Me.ID" Is there a mail merge equivalent for just the...
  4. shuttlelaunch

    Access Mail Merge VBA Help

    The merge pulls all the records from the table "TAD_Database
  5. shuttlelaunch

    Access Mail Merge VBA Help

    I have searched the web. There is nothing for how to create a mailmerge from the single record being viewed.
  6. shuttlelaunch

    Access Mail Merge VBA Help

    If I am using a from the switchboard, how do you make a query for the single record being viewed? I am not using a link to an access table.
  7. shuttlelaunch

    Access Mail Merge VBA Help

    How would you use a query? Would kind of code would I have to add to the button to run a query for the specific record being viewed?
  8. shuttlelaunch

    Access Mail Merge VBA Help

    Hello All, I am trying to make a command button in Access that will fill a Word Mail Merge with information from that record set. The code I have so far is: Set objWord = GetObject("C:\My documents\Mail Merge.docx", "Word.Document") objWord.Application.Visible = True...
  9. shuttlelaunch

    Text spacing in textbox of PDF

    I need to change the tracking, or character spacing. The issue is that the form has a box for each character. Instead of using a text box for each letter, I want to use a signle textbox that the user can input the whole word, than use a script to space the characters out evenly so that they...
  10. shuttlelaunch

    Text spacing in textbox of PDF

    I have a textbox in a fillable PDF that I want to change the spacing of the text that is input. How do you change the textbox so that the spacing between characters are changed?
  11. shuttlelaunch

    Count recrods per day to be used in graph

    The table with the dates is named tblDates, the field is [TheDate]. The table with the check in/out dates is named MasterDatabase, the check in date is [GAIN DATE] and the checkout date is [CHECK OUT DATE].
  12. shuttlelaunch

    Count recrods per day to be used in graph

    I've created the table and query, but I dont see where to put Group By the [TheDate] and count [TheDate].
  13. shuttlelaunch

    Count recrods per day to be used in graph

    Do I do this in a normal query or a crosstob query?
  14. shuttlelaunch

    Count recrods per day to be used in graph

    I have database that we use at an animal shelter. The day an animal arrives we record the day [gain date] and when it leaves [check out date]. I am trying to make a query that I can use to create a graph of number of animals per day over the year. How do I create a query to count the number...

Part and Inventory Search

Back
Top