MS Access 2003
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?
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
RunCommand - Print
SendObject - Report, RPTDailyReports
Close - Report, RPTDailyReport
when I do CTRL + P and put the print quality up to 'Super' it prints fine
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 created a print image form in my project so that when a user opens the form, it cycles through all the images stored in a temp folder and prints them out four images/page at a time until all the images have been cycled through. I am using the below code on the "OnCurrent" event of the form. The problem I am having is trying to close the form with code after the images have been cycled through. I get an error message stating that "this action can't be carried out while processing a form or report event" I guess it is caused by the form still being sent to print. How do I add a code to catch the event when the form has finished printing? Also, when I open the form by itself, it works correctly and prints all of the images. However, when I tried to use a switchboard to open the form, it prints the switchboard form. Please help me in correcting this. Thanks
Private Sub Form_Current()
Dim mysql As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim PicPath As String
Dim TotalSet As Integer
Dim CurSet As Integer
Dim SetStart As Integer
Dim RecNo As Integer
Dim PicNo As Integer
Dim RecCount As Integer
Dim RecNoMove As String
Dim PageCount As String
Set rs = New ADODB.Recordset
Set conn = CurrentProject.Connection
mysql = "SELECT tbl_Image.*, tbl_Image.SelectPrint " & _
"FROM tbl_Image " & _
"WHERE (((tbl_Image.SelectPrint)=Yes));"
rs.Open mysql, conn, adOpenKeyset, adLockOptimistic
RecCount = rs.recordCount
TotalSet = (Int(((RecCount) / 5)) + 1)
CurSet = 1
PicNo = 1
SetStart = (((CurSet) * 4) - 4) + 1
rs.MoveFirst
NextSet:
For RecNo = 1 To 4
PicPath = rs("myimagepath")
Me("image" & PicNo).Picture = PicPath
PicNo = PicNo + 1
rs.MoveNext
If rs.EOF Then
If Me.Image1.Picture = "(none)" Then
End
Else
PageCount = "Page " & CurSet & " of " & TotalSet
Me.PageCount_txt = PageCount
DoCmd.PrintOut acPrintAll
GoTo closepage
End If
End
Else
End If
Next RecNo
PageCount = "Page " & CurSet & " of " & TotalSet
Me.PageCount_txt = PageCount
DoCmd.PrintOut acPrintAll
PicNo = 1
CurSet = CurSet + 1
Me.Image1.Picture = "(none)"
Me.Image2.Picture = "(none)"
Me.Image3.Picture = "(none)"
Me.Image4.Picture = "(none)"
GoTo NextSet
End
closepage:
DoCmd.Close acForm, "frm_printimage_4", acSaveNo
End Sub
I need to be able to browse to and open a folder from a form, and import images from within that folder to (i guess?) another form?
I then need to print each image on 3 different reports, but in order as below...
Image 1 - report 1
Image 1 - report 2
Image 1 - report 3
Image 2 - report 1
Image 2 - report 2
Image 2 - report 3
etc
Once images / reports are printed they can be removed.
Should I have a page that shows maybe 40 images and a big print button? or 40 images with a selection box by each one and a big print button? or 40 images and 40 print buttons? etc
The reports will need to change in the future, so a option to select any or all of the reports would be a really good idea.
I have access 2013 but I much prefer 2003 as I know where all the buttons are!
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)?
Thanks ahead of time .....
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
thanks
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.
View 2 Replies View RelatedI 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 want to use a image in Header in a report. Even if I use a small image (gif), it produce a huge mdb file. Haw can I reduce it?
View 3 Replies View RelatedHi I am new to the forum. :)
I am creating an access database that holds customer information for a friend of mine. I am struggleing to think of ways to make Access do several tasks.
I have created several forms that display when reletive buttons are clicked and some run automatically using queries, one of which runs a query that displays any upcoming service inervals that are within thirty days of the current date, and allows the user to print a report that is designed to be a service notice for the relevant Customer/s which contains the customers address, phone numbers and service due date with a small pre-made text insert that advises the Customer about the upcoming service recommedation. The Form also provides the ability to print address labels for the same customers, making it quick and easy to send them out by post. The problem that I am having is that I would like the customers information that has already been printed to be removed or greyed out in someway so that the query does'nt print out duplicates but also have the ability to allow user control to reprint any result that may for any reason need reprinting.
Thanks for any help
Christopher
Hi
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
Your help is greatly appreciated:)
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page:
Private Sub btnPrtOrderFrm_Click()
On Error GoTo Err_btnPrtOrderFrm_Click
Dim stDocName As String
stDocName = "rptOrders2"
DoCmd.OpenReport stDocName, acNormal
Exit_btnPrtOrderFrm_Click:
Exit Sub
Err_btnPrtOrderFrm_Click:
MsgBox Err.Description
Resume Exit_btnPrtOrderFrm_Click
End Sub
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
Dean
Hi all, i'm having a rather annoying problem. When I view my report I have 2 sets of conditional formatting that run, one that changes the back colours of certain fileds when the criteria is meet, and the second, the text colour of certain fields, both of which work fine when previewing the report. However, when I print the report, any of the back colour in the preview does not print out but text colour does. If I print from another office programme i.e. Word, block colour is printed fine its just seems to not work in my access.
Please note that if the same report is printed from another computer, it prints fine.
Please does anyone have any idea on why this is happening and how to sort it. Thanks in advance for any ideas and help.
I had made my own database for my own business.
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
Please help
Hi, Ive read all I can on forums and web and am still unable to print the current forms report using a command buttons on click. This is the code i have been playing with:
Dim strDocName As String
Dim strWhere As String
strDocName = "Home_Oxygen_Report"
1. 'strWhere = "[general_info.HospitalNumber]= Me!Home_Oxygen_Form!general_info.HospitalNumber"
2. strWhere = "[general_info.HospitalNumber]= "" & Me![general_info.HospitalNumber] & """
3. 'strWhere "[general_info.HospitalNumber]='" & Me![general_info.HospitalNumber] & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
Number 3 gives the closest result but it prompts me to enter the primary key when i hit the command button but i need it to do this automatically. The primary key is a text box not number. Note that the primary key is HospitalNumeber of Table general_info (form and reports record source is query of many tables).
any help would be muchly appreciated!!
Tania
Need how to help on printing reports in Access
Problem: I have a databse that is on a network at the office. My users are out in the field using mobile data computers linked to the network using verizon air cards (56.6 kbps modem). Whenever they want to print a report, since the front ends of the DB are on their computers and the back end is on the server, the mobile computer has to send the actual report from the computer over the air card to the server for printing. Each page takes 5-7 minutes before it prints at the office.
Question: Since the data resides in a table on the back end on the server, Is there a way to have the reports reside on the server as well and have the Mobile computers simply send a command to print the report from there so it's not having to send all that information over the incredbly slow air card? Or am I just going about this the wrong way altogether?
I'm not totally up to speed yet on all this computer lingo so please use little words (LOL).
I have a report with one sub-report. It previews correctly and prints correctly from my ACCDB. However, when I create an ACCDE, the sub-report previews correctly and then does not print. I have tried the following and none work: In the main report, deleted the links and changed the subreports record source.
Changed layout for print to no
Changed filter on empty matches to no
Moved everything from detail to page header.When I put code in the subreport to set a flag when loaded and queried that flag in the main report, the subreport never admitted to being loaded when run from the ACCDE (again works fine from the ACCDB).
I'd like to print out a report so that each record should be printed into an individual pdf file. When printing manually, record by record, I use an app called cuteprinter for converting reports into pdf. But that one needs saving path for each individual pdf file. What could I do if I'd like to make a series of record printing? Would there be a way of automatic generating path and file name for each record's print?
View 1 Replies View RelatedI am able to print a report of all records from a command button on a form with
DoCmd.OpenReport "General Input Info", acViewPreview
I can also print just the current form to the report with
DoCmd.OpenReport "General Input Info", acViewPreview [ID] = & [ID].
What I would like to do is print a report showing the current form and all the forms after that form. In other words, none of the records previous to the current form listed but do show the current record and all others after that as determined by the auto number ID field. I am able to filter by form in the ID field with >45 showing me all records with an ID of 46 and above but I want to be able simply print the report from the command button that is on the form.
I have an Access Database installed on a server that is accessed remotely by numerous users. I have a button to print out a specific report. The problem is that in order for a user to print the report their print driver must be loaded on the server. Due to the number of users, and the numerous types of printers available, this is impractical. The current code on the button is currently:
Private Sub Command PrintReport Click()
Dim strWhere As String
strWhere ="[Property Number] = " & Me.[Property Number]
DoCmd.OpenReport "RESERVE REQUIREMENT REPORT", acViewNormal, ,strWhere
End Sub
I would like to know if there is some code that would send the report to PDF, so that any remote user could then print the report from PDF.
My table structure is
id photoPath name
1 C:a.jpg A
2 C:b.jpg B
How to show all image per row at report details section in a report like
ID Image Name
1 Here Image of A A
2 Here Image of B B
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.
View 8 Replies View RelatedHi Everyone,
I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report.
Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course.
Here's the code for the button:
Private Sub PrintSingleChamber_Click()
On Error GoTo Err_PrintSingleChamber_Click
Dim stDocName As String
stDocName = "SingleChamberPrintOut"
DoCmd.OpenReport stDocName, acNormal
Exit_PrintSingleChamber_Click:
Exit Sub
Err_PrintSingleChamber_Click:
MsgBox Err.Description
Resume Exit_PrintSingleChamber_Click
End Sub
Can someone point me in the right direction? :confused:
Thanks again,
Mark