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.
I have created some Crystal Reports to open out of MS Access. Everything works great for me and all the users, except one.
The one user when they try to open the report gets nothing (no error, no lock-up, nothing). It is only on their machine (we have tested them logged into other machines and the report works just fine).
My guess is there is something wrong with the Crystal Viewer on their machine (in our case Crystal 8.5 ActiveX viewer control). I looked on their machine, and they have the same .ocx control as myself and the other users C:Winntsystem32Crystl32.ocx
I even went into their Access and Registered this ActiveX control (design view of a form) and still was not able to get the control to work. We were thinking about re-imaging this users machine, but this is the only error they currently have. I was wondering if anyone else had run into this error, and if so is there an easy fix?
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.
I have MS ACCESS 2003 installed..I am trying to open crystal reports in access form. I am not sure how to program that..but to begin with I was trying to place the Crystal reports viewer control in the form..but I dont see Crystal Reports Viewer Control under active X controls...Is it something that needs to be installed separately?
An other member of my team has the same version of access installed but he can see Crystal reports viewer, under Active X controls?
I 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.
I am using access 2003 and Crystal reports XI. I have created some reports using CRXI that access my access database. I use the following code to open the standard reports. MyReportFile is the name of my rpt file. I have no problems here.
Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign) CRViewer1.ReportSource = crxReport
But when I use the following code to use the recordset as source for the report, everything works the same - opens the report with data from the recordset.. Problem is after I close the application, access window will not close. The only way I can close is by task manager. If the following code is not executed then I could close the access window. I get no error messages. When I run the same application with Access runtime version I get the message "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down.". But will not let me close the access window.
Any ideas will be appreciated.
Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign) crxReport.DiscardSavedData crxReport.Database.SetDataSource SearchResults_rst Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign) CRViewer1.ReportSource = crxReport
I would appreciate any advice/opinions as to what advantages, if any, Crystal Reports has over Access.
I am used to developing complex queries and reports etc. in MS Access but a job I have applied for uses Crystal Reports of which I have no knowledge/experience. I've got an evaluation copy of CR and it looks relatively straightforward but if I could use Access I would!
Hi, I am Cesar Gonzalez, I am preparing a exam and I am struggle to get the right information for this topic. There are several questions that I would like help with, if possible.
This is the list of Questions that I need to prepare.
a. Explanation of Crystal Reports (what Crystal Reports is trying to do? and how does it do it?) b. Explanation of the role played by XML (and optionally any language written in XML) c. A possible role for a database in the application. d. why is XML used in Crystal Reports. e. How does XML simplify storage on Crystal Reports? f. How does XML simplify sharing on Crystal Reports? g. What does XML replace? h. What does the XML represent in the chosen application? i. How is the XML processed? j. Are there any disadvantages of using XML? When a database is used alongside XML: k. How are they related? l. Is the XML stored and if so how is it stored? m. How is the XML queried?
I Have this exam for the next 10-Apr-2008, So I would need this help before 9-Apr-2008 (Next Wednesday).
Any link/s to a website that could answer some or all the questions would be appreciate.
I would really appreciate if any of you could give a hand, althoug I know it is quite long question.
Thanks in advance,either you can answer or not.
PS: I dont know if you can send it to my email, but if so please fell free to send the answer to my email.
I am trying to view a Crystal Report within a Microsoft Access Project. I am recieving the following error " object does not support this property or method". I have registered the crystl32.ocx and the crviewer.dll. Any suggestions would be helpful. Thanks Jacqueline
I was wondering if any of you would be able to help me out. I'm trying to get a button on an access form to open crystal reports and pass two parameters through to it from controls on the access form.
This is what I have at them moment: Private Sub openRpt_Click()
Dim selForm As String Dim CrystalReport1 As Crystal.crystalReport Set CrystalReport1 = CreateObject("crystal.crystalreport")
CrystalReport1.Connect = "ODBC;UID=ID;PWD=PW;DSN=dsn;Database=dbname" CrystalReport1.ReportFileName = "O:DatabasesCReportsSingle Project Up To Burn Rate.rpt" 'CrystalReport1.WindowTitle = "Single Project Up To Burn Rate" 'CrystalReport1.WindowMaxButton = False 'CrystalReport1.WindowMinButton = False 'CrystalReport1.WindowState = crptMaximized
I have built an automated procedure in VBA Access 2000 that is now great (thanks to a lot of downloaded help from this forum). I use the MSCOMM active-x control to talk to an instrument via the serial port.
Question: Is that control only working because I also have VB6 installed on this same computer? It seems to me that I tried something like this a year ago and could not get MSCOMM to work in Access, but at the same time, I didn't have great MSCOMM examples to go by. I do now as I could rob them from other programs my company has written in VB6.
I have both VB6 and Access 2000, but chose to develope this procedure in Accesss because of the heavy amount of data to store (and I know VBA much better than I do VB6). I thought Access is a natural. But now I am wondering if I will have problems distriubuting this database to other service offices that may not have a machine with VB6 on it?
Do they need just plot MSCOMM32.OCX in to their system32 directory?? :confused:
Please can someone advise me how I can link the date which I select in the calendar control to a date field in the form. I want to use the calendar instead of a combo box. It's probably simple....but then so am I! Help appreciated Richard
when i select a button from the active control menu and want to use that button for either next record, previuos record. attach macro, print, i am sure that was part of the menu when selecting the button. i am not seeing that menu when i select the button from the active control could you please tell me why
Please can someone tell me how to change the back colour of a control when it has the focus and then revert to the original colour when it loses it. I have 35 controls on my form, so I need a function, rather than changing the colour with a subroutine evey time.
I have searched the site and haven't found whatI want-though I'm sure this question has been asked before.
Essentially I have a form_A with several tab's and then one list control box in each of those tabs. At present if you double click on any item within the control boxes your taken to another form_B with info about that item and when you close that from down again if refreshes form_A.
Is it possible to only refresh the specific list control box that is active instead of refreshing the whole form ?
I have tab controls, each of which holds a report. If the report is longer than the tab control the report is stuck there. no slide bars, no overflow. I have set scroll bars but they dont seem to take or work. I need to find a way to add verticle scroll bars to the reports within the tab controls so that you can view the entire report. I have included a screen print of what I mean.
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?
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?
Just 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.