Type: Posts; User: jggtz
Search took 0.05 seconds.
I do it next way to change forecolor of listview cells
Dim LI As MSComctlLib.ListItem
Dim LIS As MSComctlLib.ListSubItem
'Add to ListView1 -1 row -2 columns -forecolor blue
Did you try post #6?
Because my english level is not as good as I want, I can't explain exactly what Windows 7 & 8 do about certain paths and keep old versions of files generating this kind of...
I would run the tests in a folder created by me... for example: C:\MyFolder
In this folder store the rpt files and call them from there
It sounds that you are using some kind of protected folder
Probably you are using a font that is not supported by pdf and that's the reason that it change to a supported one
Are you calling the reports from an application?
Because we can change the datasource using code
If this is your case then say language & version used and also Crystal Reports version
Study the attached VB6 project
it shows one way to solve your problem
(the rpt uses the Extreme.mdb file, probably you need to change to other if you don't have it)
The OP clearly posted
Believe it or not, but in many places around the world they are still teaching VB6 and DAO in XP boxes
When using DAO .RecordCount will give you the result only after a .MoveLast method
You should investigate about:
-How to Declare Numeric variables in VB6
-How to accept data from the user in VB6
-How to use arrays in VB6
-How to calculate percentages and averages in VB6
It looks like you are using DAO
1 Reference the DAO library
2 Change the lines where you declare and where you open Recordset
Public Sub modDeterminePrice()
CR10 is better than CR8.5
In design time is almost the same thing
In CR10 You can open rpt files designed by CR8.5 and save them in version 10 or in version 8.5
(...but once in version 10...
Sorry pal, Crystal Reports 8.5 does not has the "ConnectionProperty" property that I used for provide the password to mdb at running time
Try to get Crystal Reports Version 9 or 10 or 11
Please, say the Crystal Reports' version
The next is the code I use without problems
OPOSPrinter1.CharacterSet = PtrCsAscii
The easiest way is to save those images in a db table and then retrieve them
You downloaded the Service Pack, it means that it's expecting that you already had installed the CR2008
Then place your total in the Report Footer section instead of Page Footer section
I mean pass the connection information to Crystal Reports to laod the rpt
You need to provide the connection information in the code using the ConnectionInfo property
I use SOAP Toolkit 3.0 in all my projects that consume web-services
Still available here ---> http://www.microsoft.com/en-us/download/details.aspx?id=10747
Developing in XP, the projects work...
Then post the code where you are indenting the nodes
Maybe parts of the next code & comments could help...
VB.NET and CRYSTAL REPORTS
HOW TO CALL A RPT WITH SUBREPORTS AND PARAMETERS
And what about a small conversion procedure?
Open both mdb
Read the old mdb
Make the data conversion (change/add data)
Write to new mdb
Some printers only accept their own api
Others accept any reporting tool (Data Report, Crystal Reports, etc.)
So, the best way is to select a brand that is compatible with your Windows version...
You should convert to a newer version first
Create a new mdb file (version 2003 for example)
Open it and import your tables from the older one
Now you can set a password using Access
The closing "
Set rs = CN.Execute("SELECT * from Expenses WHERE ExpRemarks ='ABC'")
You could use the DateDiff function (if ms access)
search for the difference in ms sql
You should use another section instead of Page Footer section (for obvious reasons)
Since google, facebook, twitter,etc' links were added to bootom of threads/posts, I need to refresh IE several times to view the threads or sometimes toogle compatibility mode
Do I need to...
You should use the QueryUnload event and ask for the Mode argument
Have you tried connecting the old disk to other laptop... maybe the disk is still good and the problem was in the motherboard
Try using the Left and Top properties of the Label related with the Top + Height and the Left properties of the ListView
You didn't show the relevant code where you call the rpt
I'm sure you are using the Crystal Reports OCX control and there are many reported problems when use 'sqlquery' and Access
Te best solution...
IMO the 'problem' is in the tool you use to view the table, maybe it use only 5 decimal places to show numeric fields
Or you could use OWC
Or you could automate Excel object
You should insert the records when the teacher finish to uncheck the present students
Then the problem is how you are passing the sqlquery to Crystal Reports
Show some relevant code
If it's not showing Sum operation then your field is not numeric
Click Here to Expand Forum to Full Width
Survey posted by VBForums.