hi
very simply i am trying to print out a report that is comprised of 1 main report and 2 subreports with 1 image per page; all together on 1 page. i can print out 20 records maximum before my computer memory [or the printer memory] becomes full and the printing stops. the same happens if i try to do a snapshot.
what i need is some vb coding so that if my report is over 20 records long, the vb coding will print-out [or snapshot] the first 10 records, finish those records, then carry on with the next 10, and so on untill all the records have been printed.
is this possible??
any help appreciated
hi i have a database with hyperlinked images in a sub form that show a new image for every record. on this sub form i have a zoom in and zoom out button which is VB coded. the problem i have is that when i zoom in and then go to the next record the new image is still enlarged and has not reset to the size of the image box. any idea as to what i need to do to correct this. i think i need to put some VB code on the on current event but not sure what. any help would be appreciated
I inserted an image (jpg) in a report, it appears in PrintPreview, but not when I print it on my printer. Please help me. I do not if the problem is with my printer or I'm doing something wrong when inserting the image.
update: It seems to work when printing from Print icon, but does not work when printing from File/Print menu. Is this a known bug?
Don't Kill me folks... I know this has been asked and answered, but I'm not able to get it to work. I'm using Access 2000.
I have an image in the Report called ImageFrame and the following code:
Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error Resume Next Me.ImageFrame.Picture = Me.PhotoEnd Sub
What am I doing wrong? Is there something else to set? I don't get an error, but it only shows the image I chose to place the image control in the first place...
After filling in a form which includes both text and a photograph (in a bound object frame -- different photograph (OLE object) for every form -- photographs embedded and pulled from a separate photograph file external to MS Access) I email the corresponding report successfully as a .snp file attachment. The problem is that the recipient needs either MS Access or Snapshot Viewer installed in order to view the photograph field (ie. the OLE object in the bound object frame). If I try to format the report according to any other format (html, rtf, etc.) the text shows up okay but the photograph doesn't appear in the bound object frame. I also tried to create a data access page but the OLE 'photograph' field is not even an allowed selection. Any ideas on how I can get around this problem (ie. email the report to a client who doesn't have MS Access or Snapshot Viewer installed on their computer)?
I have a database of 700 or so records each with a image filename (the images are about 75kb). When I make a report from these records including the images it takes a long time, but eventually it creates the report on screen with all the images. However when I try to print the report the images are not there. Is it just that the spool file or is it a limit in access? Would adding memory to the printer help?
My Access 2010 application has many reports. On almost every report, the user can select a new paper size. This paper size is remembered, so the next time the user selects the same report, he no longer have to set the paper size (I guess this is the default behavior for Access programs).One report does not behave properly. This report is a LEGAL size report. EVERY times the user selects this report, it prints on LETTER size, so the form is split in two pages. If the user selects teh LEGAL size paper, it works, but the next time the report defaults back to LETTER size paper.
I checked everywhere in the code, nowhere the paper size is set. In development, I selected the report, I changed the paper size to LEGAL, I ran the report. The next time I check the paper size of the report, it is back as LETTER size.After my OpenReport statement, I tried manally setting the paper size with "Reports(xxx).Printer.PaperSize = acPRPSLegal" but my report still defaults to LETTER size paper.
I have a form in which I want to retrieve images from a folder. Each record contains a txt field where the path of the image is located. Not every record contains a path to the image file as some records does not have images. I have created an image field in my form and used the following code: Me.Image129.Picture = Me.imagetxt to retrieve the image. I would like to display an image containing the words "No Image" whenever the imagetxt field is blank. How would I do this. I cannot go back and fill in the blank imagetxt field with a path as I am pulling the data from an external source. Also, would this be the same method if I am creating an image field for a report? Any help would be greatly appreciated.
I have a report reading directly from a table. Table has a text field "txtOldState" where the field data a 10 digit number.
Also have a directory with .png files named with same 10 digit number. The txt field is on the report - I need to print the associated .png file on the report along with the 10 digit "txtOldState" field. I'm failing at pulling a png from the folder to print on report.
I am trying to have a macro button so when I click it it Emails to a particular person but also prints off a copy.it all works fine but for some reason it wont print the image off, my macro is as below
I've asked this question in different forums before, and though some people say it can be done, I have not found anyone who is successful yet.
I have a report that puts down a person's address, however the address information is stored within the database in separate fields ('Address', 'City', 'State', 'ZIP'). The issue I have is with the City/State/ZIP. Some city names are longer than others, is it possible to have the fields adapt to the different word lengths.
Say the address is, Albany, NY 10023. The database would output this alright, but then if the city name is San Francisco, CA 94143, the fields are in disarray.
I have the same issue with names. Last name and first name are stored separately. I would like to display Last, First. My workaround has been to right-align the Last name, and put it adjacent to the left-aligned first name field. This works unless the person's last name is very long, disporportionately from the first name, in which case, it looks very much off center in the overall report.
I have a report opening to give detail when a button is clicked - however it will only ever return a maximum of 3 records - however the report window is far to tall - it should only be a third of the hieght it is - is there a way to set the height of the report which opens?
I want to get the link adress to an image in a report using VBA. I use the following code:
PHP Code:
Dim strPath As String strPath = [CurrentProject].[Path] & "builder" & FirstImage If Not Right(strPath, 7) = "bilder" Then Me.huvudbild.Picture = strPath Else Me.huvudbild.Picture = [CurrentProject].[Path] & "builder\_tom.jpg" End If
I get the following error (translated from Swedish): Error: 2424 The expression contains a field, a control or a property name that MS access couldnt find.
I have a database used for several product lines. Depending on the product line selected, I need to add an image to my report as the header for it. I need to store the images (there are only 3) in the database and cannot have an external link to them. Have been trying to figure out the best way to do this and I am finding both OLE Objects and Image Objects.
I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic...
I created a report from a query and there is many fields therefore it made the report 22" wide. I rearranged the fields with in 8" but in the property field when I put 8 in there it does not change and it goes right back to 22". in print preview there are 6 pages and only 3 with info showing the other 3 are the extra width of the report.
I am creating barcharts in the report header section but i think there is some size restiction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to do that .
I have a report which gets it's records from a table which has OLE Object data type being a "file.jpg". can I get the image to show in the report print view and also print it with the report?
I am running Access 2013. I have created a report where the tables are linked to a SQL DB
I am trying to run a sales report that includes an stored image.
I am adding an Image and then using the control source to look up the 'filepath' stored in the DB. When I run the report on screen all the images are showing but when I try to print it (including exporting to PDF or XPS) and Print Preview only 2 of the 9 images print per page. The images are around 2-4 Mb.
I'm guessing its to do with the files sizes but cannot do anything about the size.
I really need help with this. I have a database that is quite large and is accessed through VPN. When I shrink and compact the database it goes to a respectable size. But over time everytime a report is previewed the size of the database grows. Or every access it grows to double its size in no time at all.
Any ideas... on what would make it grow and how to stop it.
I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.
I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and column space so that the output can be better tailored to his needs. I have inserted combo boxes on the form to get these parameters from the user, but how am I going to insert these parameters in the report layout through programming. What should be the approach?
We are creating a report and for some reason we can no longer extend the detail section of the report. It has stopped at 2 A4 pages length and won't let us extend it further. We have about 7 pages of the report, I didn't think this was too much?
