Search:

Type: Posts; User: MudManiac

Search: Search took 0.02 seconds.

  1. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    I really appreciate the help. The locale shouldn't be a problem because the user can't even enter the program until the Regional settings are set to Dutch (Netherlands). I actually pull the data...
  2. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    Olaf, I have not completed rewriting all the VB6 code for Access 365 (primarily how it prints to Crystal Reports 11 - was previously using Crystal Report 5). Due to this, the present data tables are...
  3. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    Olaf,

    Thank you so much. I'll search through the code and try to understand it. Unfortunately, my background is nuclear engineering, not programming. As you can tell, I'm self taught and do the...
  4. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    I really appreciate the suggestion. Unfortunately, I'm not having a problem in Excel. The problem I am having is writing the numbers to the csv file in the European format (i.e. #.##0,00) and then...
  5. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    Well I tried the format statement with no success (example: I had a 1stRate value in the database of 3.08. I set the value to the variable and modified the numeric format as follows: in1stRate =...
  6. Replies
    17
    Views
    1,729

    Re: Create CSV File for European Number Format

    I initially created this program about 20 years ago. It runs our main invoicing and inventory control (as well as a host of other things). It has worked great all these years. It has about 2,000...
  7. Replies
    17
    Views
    1,729

    Create CSV File for European Number Format

    I have a program that outputs invoice data to a CSV file for importing into Excel. This works great in the US. The problem is that the Netherlands number format is different. They use a "." as a...
  8. Replies
    2
    Views
    1,330

    Re: Date Range Formula for Crystal Reports 10

    I have a separate form with a Crystal Report control that I pass report definations to named "ReportView". I was able to get the report to view with the correct date ranges using the code below:
    ...
  9. Replies
    2
    Views
    1,330

    Date Range Formula for Crystal Reports 10

    I am trying to use a start date and end date input fields on a VB6 form to select the date range for a Crystal Reports 10 report. This use work in Crystal Report 5 with an Access 97 back end. I...
  10. Re: Selecting Printer for Crystal Report 10 Direct Output

    I really appreciate the suggestion. I gave it a try and unfortunately it didn't help. Note: The reports use several different font sizes (titles, headers, body, etc.).

    It's interesting, when I...
  11. Selecting Printer for Crystal Report 10 Direct Output

    I am trying to let the user select a printer for Crystal Report 10 output prior to sending the form directly to the printer. The code below mostly works. However, the font on the printers is not...
  12. Replies
    6
    Views
    2,789

    Re: DBGrid Refresh of Records

    dilettante,
    I changed the reference to DAO 3.60 and my original code worked perfectly with my Access2000/2003 databases (thank you, thank you, thank you). I had to position the DAO 3.60 reference...
  13. Replies
    6
    Views
    2,789

    Re: DBGrid Refresh of Records

    dilettante,
    Thanks for the advise. Unfortunately, when I change the record set to adOpenDynamic, the routine doesn't work (returns a no data found message).

    The datMain data control is attached...
  14. Replies
    6
    Views
    2,789

    DBGrid Refresh of Records

    I've been working on this darn problem for over a week can't figure it out. I am updating an older program from a DAO database to an Access 2000 ADO formatted database. I have a grid on a form...
  15. Re: Connecting to Access 2003 (ADO) Table in VB6 code

    That worked perfectly. Thank you so much!!!
  16. Re: Connecting to Access 2003 (ADO) Table in VB6 code

    I have been able to successfully connect to the ADO database table. I would like to set the ContectionString to a variable but keep receiving an error. I'm sure I just have something wrong in my...
  17. Re: Connecting to Access 2003 (ADO) Table in VB6 code

    Thank you so much!!! I'll give it a try tomorrow.
  18. Connecting to Access 2003 (ADO) Table in VB6 code

    I have a large program that was created with Access 97 (it's an old program but still works great). Microsoft recently upgraded Office 365 which causes Access 97 to crash when Access forms are...
Results 1 to 18 of 18



Click Here to Expand Forum to Full Width