Recent content by cgagnon

Thank You very much! I will give it a try. At least it gives me something to get started. Much appreciated!!!

Hi! Can anyone point me to some info on how to read/add/update records in an Access table using VB. I am new at both Access & VB. I have an Access table (TableA) that has date/time fields in it. I have another table (TableB) that has basically the same info, except that it has number fields...

I have the Professional Edition. Does that mean that I cannot run this application?

Thank you for answering. I have Crystal 8.5

I am trying to figure out how to use Crystal Reports & VB together (I am new at both). I downloaded the "First Class Hotels" sample from the Crystal Decision site (support.crystaldecision.com/fix/topdownloads), and tried to run it by double-clicking on the HotelSample.vbp. I got the...

I am using ADO in VB to access an SQL database. I create a connection, a command, a record set, etc...All that is working fine. I retrieve a record from a Complaints table (the user enters the complaint # on the screen) and I display info from that table in a "header" area on the...

I can't figure out what determines whether or not the User_ID gets populated (i.e. from Crystal Reports...Database...Set Location). When I create my Crystal reports, I am logged on as CGAGNON. Sometimes CGAGNON will appear in the UserID info...sometimes it is blank. This is causing me a problem...

Thanks Ken...I will try that.

I've been tearing my hair out on this one for weeks, so ...HELP PLEASE!!! I am using Crystal Reports 8.5, and Crystal Enterprise. I create reports from my PC (logged on as CGAGNON), then bring them into Crystal Enterprise for the users to run. Even though the reports are using the same ODBC to...

Thank You! That did the trick! The only problem now is that I would like to have a grand total of the tons that are in the group footer. I can't seem to get it to work. My shared variable that I pass from my sub-report is called Tons. In my main report, I defined a formula called ShareTonsMain...

Thank you for your answer, but no, it is not a rounding issue. The tons are correct, it is just that they appear for the wrong customer. The tons for customer 1 appear on the line for customer 2...

I have a sub report that totals up the sales tons for a particular customer for a certain date range. The customer number and date range are passed from the main report. In the sub-report, I have summed the tons in a shared variable and placed them in the Group Footer portion. I want to show the...

I'm getting really frustrated with this one. I've created a Crystal 8.5 report that I brought in to Crystal Enterprise so that the users might run it. The report was created on my PC, and has a userid of CGAGNON attached to it (I can see this if I go to Set Location...). This report uses the...

Crystal Enterprise (but not Crystal Reports) is installed on our IIS. I create the reports on my PC and then bring them into the IIS using the CMC or the Wizard. When I run the report from my PC (thru Crysteal Reports), I get different results than when I run the same report from my PC thru...