Search results for query: *

This might be more of a statment than a question. I have written a module that is referred to in my Access query LastDayOfMonth(CInt(Right([01_qsub].[DATE-YYMM],2))) The purpose of the module is to determine the last day of the month. When I run the query in Access it works fine. However...

First of all, I know that there are a multitude of questions and answers on this topic in Tek-Tips. The problem is that while it appears to work for all others ... it doesn't work for me. I am using VB 6.3 (through Access) and Crystal Reports 9 The standard answer has been what is below Dim...

Does anyone know where the CR9 (and perhaps other versions) is on the www? Thanks in advance

I am trying to use Visual Basic to programatically (and silently) create PDF's from CR9. However, the problem is that the user is continued to ask for the path they would like to store the pdf. My code is as follows: Dim Application As New CRAXDRT.Application Dim Report As CRAXDRT.Report Set...

I am developing a footer that makes use of CAGR's (cumulative annual growth rate). What I would like to do is refer back to the values in the detail part of the report to build my CAGR formula. Example 2002 180 2003 198 2004 212 2005 225 2006 295 So a CAGR takes the difference...

Does the name property have any useful development applications? For example, if a field is created with the name "Text1", what can I do with it? In some report writing packages you can refer to the control by reference, but it seems that you can't do that in CR (version 9).

I have a dashboard report (fill as much information as possible on one page). The report has up to 8 different subreports. Is it best to create the subreports under separate names and link to them from the main report or just insert them into the main report?

I am attempting to write a conditional statement that if A<>0 then A else "N/A". However CR9 requires that both branches of the If statement be the same data type (as best as I can figure). Any easy way arount this? Thanks

I have been hunting for some answers to these questions for some time. When I use CR (compared to Access) there are a few maddening gliches which hopefully someone can convince me that its a "feature". 1) Switching the source of the controls. In Access, I can easily switch a control source...

Is there a way to look behind the scenes and view/edit properties of Crystal reports. In Access (and other db's) you can make use of system tables. Many times in the past I was able thru VB code dynamically make a field name change to multiple tables in near instantaneous time. Has anyone...

My laptop got a Windows problem a week ago. Laptop can't boot, nor will it see the CD Rom. I removed the 20MB hard drive from the laptop and, with the help of an enclosure, successfully hooked the hard drive up to another PC and started moving all files over. All files are successfully...

I checked thru the past threads looking for this answer and couldn't find the answer to the question above. In VBA I would start my recordset with rs.Edit and when I had the fields changed I would use rs.Update. However, the Edit method is not recognized in ADO. Any suggestions would be...

I am trying to run this method when I QBF (Query by Form). The stored procedure required 3 parameters all of which are contained on the Access form. I can not figure out where to add the parameters in the .OpenStoredProcedure so that it will run the stored procedure and put the results in a...

In summary I have 14 views each ending with a 3 digit number. The 3 digit numbers correspond to different business units, each of which must be kept separate. I have had to create a global temporary table (##) using each view, hence I could have up to 14 temp tables. I have a need to drop...

I have a SQL table that has 350 fields and it holds sales data for the past 3 years for a number of hotels. My client wants a report that shows sales as follows: Previous Day Month to Date Last year month to date I would need this information for about 200 different fields. I have written 3...