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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: legolas75
  • Content: Threads
  • Order by date
  1. legolas75

    print in PDF

    Hello, I've been trying to print an access report to pdf. I've looked at thread707-1119207 and it runs - the printer icon pops up and shows that a document is spooling, the adobe icon shows that pages are printing to pdf. However when it is all done and there is nothing left in the print que...
  2. legolas75

    syntax for rowsource selection

    Hi, Currently in my listbox I have a rowsource of SELECT region_nbr, GEO_REGION FROM qry_choose_region UNION SELECT "*", "-- All Regions --" FROM MsysObjects ORDER BY GEO_REGION; I would like to assign this rowsource programmatically to the variable strRowSource as shown below...
  3. legolas75

    Method or data member not found

    Hi, I'm trying to run the code below but I get the error message "Method or data member not found". I have already add the references 'Microsoft Outlook 10.0 Object Library' and 'Microsoft Outlook View Control'. It get hung up at the 'myOLApp.CreateItem(olMailItem)' part of the code. Thanks for...
  4. legolas75

    auto email how to click "send"

    I have a program that will send a report to email addresses contained in a table. The problem is that Outlook opens and I have to click on the "send" button everytime before the program loops and the next email is created. How do I programmatically click on the "send" button. Also, if there is a...
  5. legolas75

    Sub or Function not defined

    I'm getting an error code when I click my button that says "Compile error: Sub or Function not defined". How do I prevent this? FYI I'm trying to email a report based on a number if a table called tblEmail. One report for each line in the table. Thanks. Mike Private Sub Command79_Click()...
  6. legolas75

    Need filter recordsource and change report name for each unique value

    I have a report based on a table, 'DATA1'. For each unique groupnbr in 'DATA1' I want to export a report to show only the data for that group number and save the name of the report to be based on the value on the group number. For example if group number = 1234 then I want the recordsource of...

Part and Inventory Search

Back
Top