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 Chriss Miller 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. RonMcIntire

    Adding variables to a control in a footer

    Works fine. Thanks Ron
  2. RonMcIntire

    Adding variables to a control in a footer

    sxschech: The variable is coming from the form that populates the report. To wit: I'm trying to create a Title Page for a directory. The form contains the following fields: Title of the page in the directory The Report name StartPageNO EndPageNO Calculated number of pages The Title Page report...
  3. RonMcIntire

    Adding variables to a control in a footer

    All: Does anyone know if I can add a variable to a control in a report footer? Example: =" - " & [Page]+ StartPageNO & " - " where StartPageNO is the variable. If there is, how do I do it?
  4. RonMcIntire

    Page Numbering a report with vba

    After some more research, my question boils down to: Can I write code containing an Access object to a report that is in design mode? If I can, my problem is solved - if I knew how. Any thoughts?
  5. RonMcIntire

    Page Numbering a report with vba

    Writing the 13 images to a report is solved. This 13 is a report start page. Right now I can write the =" - " & [Page]+1 & " - " statement to the footer and make it print on the page when the report prints. Under normal circumstances, the statement must enter the report in design mode to make...
  6. RonMcIntire

    Page Numbering a report with vba

    I have written a routine to add the page number of a report in the footer section. The routine populates a textbox control so that I get this: =" - " & [Page]+13 & " - " . How do I preview the report with the page number? This entails calling the routine before the report previews but I don't...
  7. RonMcIntire

    Multiple images on a Report

    dhookom Looks like I have found the solution. I now have to figure out how to handle the arguments for the Detail section. Thanks for your help. Ron Mc
  8. RonMcIntire

    Multiple images on a Report

    Why would I want a 3-column report when I have all my images in a grid? Please look at my code procedure to see if I'm doing anything wrong that would cause my program to hang up. I'm sure I haven't assigned the image controls (in red) correctly. The images are in a grid like this: x x x x x...
  9. RonMcIntire

    Multiple images on a Report

    I didn't answer your question: I have tried putting FPath(1), nFilePaath1, and FilePath for each image in the Detail Picture Property name field. No Luck.
  10. RonMcIntire

    Multiple images on a Report

    I've bound the table to a single record source: tblChapter Officers Eleven of the images are in a w x 3 grid and two images are at the top of the grid, like this: x x x x x x x x x x x Each image has a name: nFilePath1, nFilePath2,. . . . nFilePath11. The remaining two images are used in...
  11. RonMcIntire

    Multiple images on a Report

    I tried to edit my post yesterday and found it didn't send so here is what I have so far: dhookom Thanks for your response. BTW: I am using Office 2007 and Win10 I understand what you're saying, but I have 13 images paths in one table I want to put on one report. I haven't figured out how to...
  12. RonMcIntire

    Multiple images on a Report

    Each record has one image. There are 13 records in the table.
  13. RonMcIntire

    Multiple images on a Report

    dhookom Thanks for your response.f I understand what you're saying, but I have 13 images paths in one table I want to put on one report. I haven't figured out how to make your code work for me. I think I want to step through my table (field, Org) and pick up the file path in that record, but I...
  14. RonMcIntire

    Multiple images on a Report

    All: I wish to put up to 11 images on an Access Report from data in one Table. The number of fields include ID, Org, FName, LName, Office, OfficerName, and FilePath (to the image). I create my Table with a form, inserting single images for each name, and show the image in an image box. I...
  15. RonMcIntire

    Multiple images on a report

    Duane: I'm creating a chapter directory, 8.5"H x 5.5"W. The pictures are each 1.125"H x .8125"W and fit in a 3 x 3 array on the page with two photos at the top. I can and have copy/copied the photos to the controls individually but I'm thinking long-term for the guy that follows me and may not...
  16. RonMcIntire

    Multiple images on a report

    I am using MS Access 2007, Windows 8.1. I input the FilePath to 11 Chapter Officer images and names on a form using a table source. That Works oK. My Table: Org (Organization number to re-org the officers if needed). ChapterOffice (President, VP, Membership, etc)...
  17. RonMcIntire

    Insertng OLE objects in a form

    I want to insert an OLE image onto an Access 2007 form but all internet assistance I find says "drop the OLE object on a form, right-click (presumably in Design View) and click on the insert image" option. The problem is I can't find the option in any dialog as stated by YouTube or Internet...
  18. RonMcIntire

    Preview multiple pages in a report

    dHookom: Not sure what you mean. Here's a prntscr/jpg of my report with subreport. My data source is a qry with one table. No links. Ron Mc
  19. RonMcIntire

    Preview multiple pages in a report

    I am writing a report with a multiple-record interior subreport. When I print (preview) the report, I get multiple pages with the same group of records. I suspect the report writer is printing a report page for each record. I would bet the problem has an easy fix but I am at a loss to find the...
  20. RonMcIntire

    Error: [Filename.mdb] can't send this email message

    lameid: Thank you for your response. One thing I didn't mention was that I use comcast.net as my email server and they require the IMAP (993 portal, SSL encryption) to send and SMTP (587 or 465 portal, SSL or TLS encryption) to send and receive emails. Don't know if this means anything. I use...

Part and Inventory Search

Back
Top