I'm using the Snapshot Viewer control in one of my forms to display reports within the form. This works fine, except that with multiple page reports, there is no button to change pages, users have to right click and select 'next page.' In design mode the buttons to change pages and print appear at the bottom, but for some reason they don't show up when viewing the form in form view.
Has anyone run into this issue before?
Thanks
Wonder whether anyone can help me?
Each day I produce reports from access and email then out using the snapshot viewer format. The majority of recipients open this find and the report is absolutely fine, however, when other recipients open the report it comes out all slanted and blurred. It almost looks like there snapshot viewer is squashing a landscape report into a portrait view. Does anyone know how to correct this, as its driving me mad trying to find an answer?
thanks:)
hi
i am using a macro with the outputTo method for a report. i have the report outputed as a snapshot file. it was working fine but now when it outputs the report the extension is missing; the file is created but with no extension. i tried changing the output format to excel but the extension was still missing. i also tried renaming my output report within the macro with the extension .snp and with .xls. snapshot viewer or excel would not open these programs.
anybody else come across this problem?
any ideas?
thanks
Im trying to display a report in the snapshot viewer object that i placed on a form, the thing is that im having a problem filtering and applying the filter fields that i used to the actual report in the window.
Im having problems referring to the object, can someone help with like the syntax. Im trying to apply the sql statement that is generated to the preview window and the report.
All help will be appreciated.,
Could anyone point me in the right direction re the Crystal Reports Active X viewer control and access forms. I loaded it onto a form in access 2000, but can't seem to find any meaningfull properties I can manipulate (especially the report source). I am thinking it works like any other active x control and I can manipulate properties through code, however, the main property I would think I need (source report) does not seem to exist. I have Crystal 10.0 loaded on my system.
View 1 Replies View RelatedI have a database that was built by some users, long before I came to my current job location (oh yes, one of those fun issues), and have run into an error that is involving a 3rd party tool, and is tough to duplicate.
There is an ocx control named "Kodak Image Thumbnail control" the path is C:winntsystem32ImgThumb32.ocx.
This is an active x control, that on the double click event, opens up the correct corresponding .pdf file. It works correct for me, on my machine. It works correctly for 3 other people on their own machines. When we had a user it worked correctly log into a user who it does not work correctly, it then worked correctly for them (appears to be user rights, and not machine specific). It does not work correctly for another 2-4 users (not sure the exact number).
But, the rights were gone over with a fine tooth comb, and nothing was found different from each user.
What is weird, is how the error occurs. There are 59 records in the database, with a linking .pdf file displayed in this .ocx control. For those users in which this does not work, the first two records open the .pdf correctly. After this (records 3 to 59) they receive the following error:
"Microsoft Access can't open the file containing the OLE object.
- You may have specified an invalid file name or an invalid unit of data (such as a range of cells from a worksheet) when the file for the OLE object.
- The file you specified may not be available because it's locked by another user or you don't have permission to use it.
Try one of the following:
- Make sure the file is available and that you used the correct file name.
- Check the OLE server's documentation for information about the syntax to use when specifiying an OLE object's data."
[OK]
Since this is a third party tool, that I have never used, and do not even have on my machine (yet it works correctly for me) I am not sure what else I can do to track down the error. I just wanted to see if anyone else has run into this error, and if so how they had fixed it.
Thank you for your time.
T.J.
I am working for a company that does not want to spend the money on another liceance for Microsoft Access. and I want to access my database from another location. Does anybody now of a 3rd party software that will allow me to run my database forms and enter in data or change data?
View 2 Replies View RelatedIs there any Access viewer from Microsoft, like the others for Word, Excel and PP?
It would be nice if clients can browse forms and print reports without having to buy Ms Office. But I could not find anyone.
I need to use any advanced viewer to view image from my access application>.....thanks for all
View 3 Replies View RelatedJust wondering can anyone help me please. I am only a learner with access so please go easy. :)
I am using access 2000.
Problem:
I have worked out from a lot of help from this forum how to put a cmd Button on my form to call the dialog window and store a file path in one of my text fields called “imagelinks” I can then view the image on a subform. I have two buttons one to insert a new image and another to delete the image. So far so good. Now I want to put another button on the form to preview the image with the default image browser. Can this be done so that if I gave a copy of the database to my friend and he has a different image browser the image can still be viewed by the click of that button.
I hope I have explained the above so it can be understood. :confused: myself.
Thanks in advance.
h
In my VBA (access 2003) project, Im struggling to open a pdf file using Adobe viewer/Reader. Is it possible ?
View 4 Replies View RelatedI have a DB with about 50 tables. I have arranged them in a particular order in the relationship viewer and would like to print out as much of the viewer as I can by choosing the paper size and/or setting a scale factor. Access does not appear to let one do either. When looking at the relationship page, the 'page setup' under File ->Pagesetup is grayed out. Selecting 'print' causes the relationships to be printed in some sort of predefined manner, on 81/2x11 pages. Is there anyway to control how this view is printed?
On a related note: When in the relationship viewer, the only way to scroll the view is by the margin slider bars (the mouse wheel does not work). SHould the mouse wheel do the verticle scrolling? Also, if I want to move two or more tables (at the same time) in this view, how can I select them?
Thanks
John
I am having a problem with 3 pc's attached to our network but at a different campus. They have been complaining that the Snapshot Views of reports they are running are stopping the print queue by asking to load paper type 'bond' to the printer. I have checked the Snapshot Viewer printer settings on thoses machines and indeed they are defaulting to 'paper type - bond'. Setting the paper type to Plain or Unspecified will only print on that type for that instance. Is there anywhere to set the default paper type, i cannot find anything!!
View 5 Replies View RelatedI am using Access 2000, Windows XP and Groupwise 6.5. I am trying to email an employee leave report using the SendObject method. I would like to use the SnapShot format. Must I save the report before I send it? I tried acFormatSNP with no success. Thanks for all your help.
View 1 Replies View RelatedI have the following button on a form:
When I press it a mail is being send with a snapshot attached to it
Instead of a snapshot I want it to attach it as a word document.
Here you see the code that is used. I noticed it says snapshot format on a line but I don't know what the name is for a word document.
Code:Private Sub cmdMail_Click()On Error GoTo Err_cmdMail_Click Dim stDocName As String Dim V_EmailAdres As String If Not (IsNull(Me.HauliersEMAIL.Value)) And Me.HauliersEMAIL.Value <> "" Then V_EmailAdres = Me.HauliersEMAIL.Value Else V_EmailAdres = "" End If stDocName = "TransportOrder" DoCmd.SendObject acReport, stDocName, "Snapshot Format", V_EmailAdres, , , "Transport Order BP", ""Exit_cmdMail_Click: Exit SubErr_cmdMail_Click: MsgBox Err.Description Resume Exit_cmdMail_Click End Sub
Thanks in advance
Hello,
I am using a useful function to save data of a form using the snapshot utility. I open the form, add or change data and sent the form to other users via e-mail. The snapshot uses a report. The code to do this is the following:
Me.Refresh
DoCmd.SendObject acReport, "EmailmyForm", "SnapshotFormat(*.snp)", "", "", "", "Action Required", "Please take action on the attached case.", False, ""
I was now thinking if it is possible to save the shapshot report as a file directly into a selected folder on my S drive (ex. S0000abmyfolder. I will need that the file is automatically named for my with the SSN present on the form.
Any idea or help? Thanks.
When side scrolling from left to right in the query window or on tables, once I start moving to the right, all the text in the fields becomes distorted and unreadable. I have to sit and wait and move my mouse slightly for it to clear up.Is this some graphics acceleration setting, or just a flaw with Access?
View 3 Replies View RelatedWith XP photo linked in Access would open from Access in my default photo viewer. With Win 7 they only open in EI.
How do I fix Access in Win 7 so the links open in my default photo viewer like they did in XP?
Is there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked.
I'm looking on how to do this as I have many reports to create, move to an intranet folder and then name it to the current date. It will save me lots of time if this can be done automatically.
I am using MS Access 2000 and the folder location will be on my hard drive.
Thanks
Aden
For some reason, I can no longer create snapshot files of my Access reports. I used to be able to do it on my computer.
I have downloaded the recent snapshot download from microsoft.com but have had no luck.
Can anyone help?
Thanks
First off, hello to everyone here. I have been using these forums for a couple of months now and they have helped me solve many, many problems.
I've not needed to register before now because everything I needed to find out I was able to find an answer for, so THANK YOU:)
Anyways, back to business............................
I've built a reporting application where the users basically enter details on a form that performs a few lookups to autofill some info and they input the rest.
What happens next is when they submit the 'form', it appends details to a table and sends an email with the details entered to an address specified by a populated text box on the form
One of 3rd party contractors has requested we send this info in .snp format instead of just referencing the textboxes in the body of the mail.
I have created a duplicate of the form in snapshot but cannot figure out how to do the following:
1. Reference the open form to populate the fields
2. Then attach this to the email
Any help would be greatly appreciated.......as I'm tearing my hair out (and I don't really have much left to tear out anyway)
Many thx in adv
Is it possible to email as attachment a FORM in snapshot format?
I have a form that gets the results of a query. I'd like to send the data displayed on this form as snapshot format. Possible? Any alternatives? Suggestions? Please help, i've looked high and low.
Using the access ‘Mail Report’ function, the ‘send’ dialog box comes up to select format… Is there a way to pre-select the snapshot format using code.?
View 5 Replies View RelatedI'm having trouble with a shell() command in my vba.
I'm trying to call up the picture viewer showing the file of the photo I clicked on in a form. Everything is happening as expected - the file opens in Windows Photo Viewer, but it is minimized.
I can open a picture fine from Windows Explorer, but something about my shell command is forcing a minimize.
Here is my code:
Code:
Dim sFile As String
PicFile = "C:Pics" & Me!PicName & ".jpg"
Shell "RunDLL32.exe C:WindowsSystem32Shimgvw.dll,ImageView_Fullscreen " & PicFile
I would have assumed ImageView_Fullscreen would do what I want!
I want to import data in access or excel from snapshot file- *.snp. Can I?
10x
Hi,
I have been reading all of your post for days now and can't find the answer to my question.
I have however found the answer to one of my programming problems. Thanks to all of you.
I have used Access as a data supplier but this is my first attempt to program in access.
I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.
My question(s) are:
1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.
2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.
Thanks so much for all that you have done already.
Tasha