Search results for query: *

You connected oracle via QUery or table? IF query is that the only query or you are using any UNION clause? Two SELECTs can be combined into a compound query by a set operation*using UNION,UNION ALL..) only if they satisfy the following two conditions: The result sets of both the queries must...

Search for Runtime.hlp and read the topics. It depends how you are connecting the DATABASE AND Crystal reports. It runtime files varies for ODBC DRIVERS AND JET OLEDB providers. Read the RUNTIME.hlp based on the DAtaaccess method you have. Bagavi [wavey]

Hi, The error is due to missing dependency files. Look for P2smon.dll. If it is present and still you get error then look for Msvcrt.dll and Msvcirt.dll dependency files for P2smon.dll 7.0.100.3. Bagavi/Bhargi [wavey]

I think you need to have proper license in order to view and run the crystal reports. Did you buy any of the crystal reports version? VB5.0 has inbuilt crystal report.Access doesn't come with crystal report need to buy separately. THere are many ways to call the crystal reports. USe can use...

Hi, I am calling crystal reports 8.5 from access 2000 DB. Sometimes my crystal reports opens sometimes I don't see the reports and no error message and sometimes I get this error Method 'Action' of Object "CrystalRpt" failed / Application or object defined error. I reffered crystal...

Hi, Thanks For your advice.Sorry I Can't use browser control as I have done lot of calculations and code in the VBA Section. I referred Runtime.hlp. In the dataBaseAccess Index they metioned as Direct Access -Access 7 and direct Access -access 8 methods What is this Access 7 and 8?? I know as...

Iam also getting this password problem. This password is asked when you Iam trying to setDBlocation at design time. ACTUALLY THERE IS NO PASSWORD BACKDOOR OR FRONT DOOR UNLESS YOU SET SOMETHING IN THE ACESS DB. Crystal is asking for password because of various reasons corrupted DLL's or Access...

Hi Iam using Access2000 and Crystal Report Developer edition(8.5) Iam passing parameter values from the Access forms. Iam referencing in my access form via VBCODE to CRYSTAL REPORT CONTROL.(example DIM m_CrystalRpt as crystalReport1). Iam setting the file name and setting the action to...

Read article at http://www.hammerapps.com/techtips/techtipsasp/query.asp Look for the title CRYSTAL WANTS THE PASSWORD... Bhargi [wavey]

Thanks Mike, I was able to resolve this Password asking problem if I close my access application form which calls it. Once the form is closed I am able to work in the crystal report without any dll erros & prompts . But still I will try contact Crystal Report Support. Regards Bhargi[wavey]

Thanks Mike, I was able to resolve this Password asking problem if I close my access application form which calls it. Once the form is closed I am able to work in the crystal report without any dll erros & prompts . But still I will try contact Crystal Report Support. Regards Bhargi

Hi, I am calling Crystal Reports 8.5 from Access00. I am using Reference in the access(TOols-reference) instead of the Crystal Report Control. When I call the button I am able to display the crystal report with basic View. Whenever I open is there any way I show the Hierachial tree structure in...

Thanks Guys, I have 97 and 2000 installed on 2 different PC's. I don't have any problem in running 97 version & crystal reports. Crazy thing is I am able to open the crystal reports Via access 2002 after setting the DB location.I did open the Crystal reports from the Access 2002DB more than...

I had and access DB & Crytal reports which are working fine in 97 version. I converted to 2000 and in my crystal report and I am trying to SET THE LOCATION TO THE ACCESS 2000 location. IT IS ASKING FOR ACCESS PASSWORD. I din't set any password. I went into tools-security there is no password...

THANKS KEN, I did use the criteria but using IF condition and I used the SUm(fld,condlf,conf) that is the reason I am getting error. THANKS AGAIN.I GOT IT.

Thanks Ken, You want me to use EVALUATE property?? What does it do? Can you give me an example? 2)WHy this doesn't work in the formula field SUM(fld,condFld,COnd) This sum works in the formula field when there is not condition 3 attribute. THANKS AGAIN. I appreciate it. :->

Iam calling crystal reports 8.5 from Access97 using crysta report control. I have assigned a query(SelectQuery1) to the crystal report. I need a cumulative running total to calculate all previous months hours based on my STATUS (previous) Initially I used Running total on my field...

Are you using the captial or small C? I think if you use capital (C) you won't see copy right symbol at run time. If you use small (c) you see copyright symbol.Another way is to add some code to convert into string or use double quotes around the (C) For example combo_update event() 'select...

Are you familiar with Recordset concepts? You need to look into ADO properties.(VBA CODING) Use 2 recordsets. use 1 recordset to fetch the fields based on the WHERE PROJECT_ID= (user entered value) forms!formname!combobox Store this in another variable like this if not RecordsetName.EOF then...

Thanks Dollar...