Search:

Type: Posts; User: Pasvorto

Page 1 of 13 1 2 3 4

Search: Search took 0.37 seconds.

  1. Replies
    6
    Views
    886

    Re: Non-normalized data

    Now there's an interesting approach. I never considered using a view. I am only supporting this company until the end of February. They are converting to a new system so there really is no long term...
  2. Replies
    6
    Views
    886

    Re: Non-normalized data

    That just seemed a bit more complicated. I have used aliases before, but I'm not a fan of them. I am leaning toward just inserting a sub-report that accesses data from that table.
  3. Replies
    6
    Views
    886

    Non-normalized data

    I have a report that gets employee data from a table (Table A). The report works fine. Now, the user wants to include data from Table B. The problem with Table B is that the data is not normalized....
  4. Replies
    1
    Views
    571

    Re: ClearContents error

    I got it to work. using this code:

    For rep = 1 To 15
    output_sheet_Current = Sheets("Admin").Range("D" & rep).Value
    If Worksheets(output_sheet_Current).UsedRange.Rows.Count > 0 Then
    ...
  5. Replies
    1
    Views
    571

    [RESOLVED] ClearContents error

    I did a search and did not see the same issue.

    I have Excel2013. Worksheet "Admin" contain the name of the spreadsheet to clear. I want to clear all of the cells on the destination worksheet.

    ...
  6. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    Thanks to everyone. I got it to work over the weekend.
  7. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    I was looking at your tutorial. For now I would like to develop on a PC that has Excel 2007 but use the Excel 2013 coding. Do you think that is possible? Once I have 2013 on the dev machine there is...
  8. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    No VBA
  9. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    Here is my code

    Dim xlApp As Excel.Application 'Excel object
    Set xlApp = CreateObject("excel.application")
    Dim xlBook As Excel.workbook ' Workbook object
    Dim xlSheet As Excel.Worksheet...
  10. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    I will post the source code tonight.
  11. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    I wish I had the source code at hand, but I don't. However, on the Windows 7 PC with Excel 2013 it throws an error at the first line of code that is creating the workbook.
  12. Replies
    24
    Views
    4,430

    Re: Excel upgrade

    The development PC is a virtual machine with 2007 on it. I was hoping to do some sort of check before processing. If dir <> = blah, blah, blah and have 2 subroutines, one for 2007 and one for 2013.
  13. Replies
    24
    Views
    4,430

    [RESOLVED] Excel upgrade

    I have an application that is written in VB6. In a number of places it either creates or updates an Excel spreadsheet. Everything was working just fine until IT upgraded the users from MS Office 2007...
  14. Re: [RESOLVED] How to Install VB6 sucessfulli in Windows 7

    Update:

    I discovered that the VB6 IDE will not function correctly with Windows7 SP1. It compiles an app that gives automation errors on XP machines. You must uninstall SP1. Unfortunately, my...
  15. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    Finally got a clean compile! Now to test.

    Thanks for the help.
  16. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    OK. That got fixed by running this

    http://support.microsoft.com/kb/195353/EN-US/

    One of my forms has an "input past end of file" error that I need to investigate now.
  17. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    Wow. That was fast. I ran that and it completed successfully. However, in the compile process, when it get s to writing the EXE, I get the same error message. I tried compiling to a different...
  18. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    I registered those and got the same error.

    License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.

    No...
  19. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    I think it is having trouble with Graph.ocx & threed32.ocx

    Not sure how to register those using Windows 7
  20. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    The new PC is running SP6. The old one is on SP5.

    I got all the forms across by editing the vbp file and the frm files. Now the compile is stumbling over some 3rd party components. I hope to get a...
  21. Replies
    15
    Views
    4,995

    Re: Moving VB6 to Windows 7

    I think I may have gotten a hint of what is happening. As an example:

    It loads
    frmInvAdditiveParam but does not load
    frmInvAdditiveInventory or
    frmInvAddChg

    ** note the 1st 8 characters **?
  22. Replies
    15
    Views
    4,995

    [RESOLVED] Moving VB6 to Windows 7

    I am moving my VB6 IDE to a Windows 7 PC. All of the forms have loaded except for 5. When I try to add the form I get:

    Errors during load. Refer to 'C:\Program Files\Microsoft Visual...
  23. Replies
    2
    Views
    566

    Re: Having a real problem with totaling ...

    Say there are 100 employees. Each one has 5+ records. I show the employee group with the average of field 'match', not the detail record. I want a total of those group records. So if each employee...
  24. Replies
    2
    Views
    566

    Having a real problem with totaling ...

    I am going through employee records from a temporary database table. The detail records on the report are suppressed. I have a field called 'match' in each detail record. I have a group for each...
  25. Replies
    1
    Views
    640

    Re: Odd problem with Windows 7

    I wound up reinstalling the program and that seems to have cleared it up.
  26. Replies
    1
    Views
    640

    [RESOLVED] Odd problem with Windows 7

    I am having an odd problem with a report. First details:

    PC is Windows7 pro
    App is VB6
    Crystal version is 9.5

    Whenever I run a specific report (call it ReportA) to screen on this PC I get an...
  27. Replies
    3
    Views
    4,473

    Re: VB6, shell, and Windows 7

    I got it to work by taking out

    CnxnPR.Properties("Integrated Security"). Value = "SSPI"

    and replaced it with the properties of user ID & Password.
  28. Replies
    3
    Views
    4,473

    Re: VB6, shell, and Windows 7

    I do have a proper setup program. It works just fine (on the XP computers). There is just something fishy going on with the Windows 7 units. Maybe copying it to desktop would not solve anything...
  29. Replies
    3
    Views
    4,473

    [RESOLVED] VB6, shell, and Windows 7

    I have some code


    Private Sub Form_Load()

    MsgBox "DAD Launcher - 10/19/2011 10:00"

    Dim filefrom As String
    Dim FileTo As String
    Dim Command As String
  30. Replies
    23
    Views
    1,871

    Re: Looking for some help, simple VB project?

    have you considered a listbox instead of a text box?
  31. Re: Help with Visual Basic 2010 (newbie)

    textbox.text = "something"
  32. Replies
    1
    Views
    661

    Re: Application suddenly won't work.

    deleted the LocalSettings\Apps directory and that solved the problem.
  33. Replies
    2
    Views
    805

    VS 2008 Weird install issue

    I created an application using VS2008. I am having a problem on only one PC. If I log on to the PC as the domain administrator, it deploys and runs just fine. If I log on as the user I get an error...
  34. Replies
    3
    Views
    2,015

    Re: Crystal reports with vb.net

    Set parameter fields on the report and populate thoise when you run the report.
    Kind of like this (CR9 and VS2008)


    Dim report As New ReportDocument
    Dim...
  35. Replies
    8
    Views
    1,050

    VS 2008 Re: default date vs null

    I will give that a try, Wild Bill. Thanks all.
  36. Replies
    8
    Views
    1,050

    VS 2008 Re: default date vs null

    Due to how the Insert command is constructed, wouldn't I have to account for that field?


    sqlinsert2.CommandText = "INSERT INTO POHEADER...
  37. Replies
    8
    Views
    1,050

    VS 2008 Re: default date vs null

    Hack: The field in the db is set up as a date format. Won't "NONE" give me a type mismatch error?
  38. Replies
    8
    Views
    1,050

    VS 2008 [RESOLVED] default date vs null

    I have the following code:


    If Trim(txtConfirmationDate.Text) <> "" Then
    sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", CDate(txtConfirmationDate.Text))
    Else
    ...
  39. Replies
    13
    Views
    1,297

    Re: Creating an Application for Friends Business

    So, if I understand correctly... Employee 123 opens a transaction screen. The system adds a record with a start time. When the transaction finishes, the databases updates the completed time. The...
  40. Replies
    13
    Views
    1,297

    Re: Creating an Application for Friends Business

    I would think that there are many packages available that do network monitoring. Why re-invent the wheel?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width