Search results for query: *

Works fine. Thanks Ron

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...

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?

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?

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...

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...

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

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...

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.

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...

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...

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

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...

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...

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...

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)...

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...

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

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...

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...