Search:

Type: Posts; User: DataMiser

Page 1 of 13 1 2 3 4

Search: Search took 0.66 seconds.

  1. Re: Sorting more than one table in single query?

    I got it, just had to remove the first select from and the ( ) that surrounded the other selects. Seems to be working now.
    Thanks for the assistance.

    Working query looks like

    Select...
  2. Re: Sorting more than one table in single query?

    hmm once I got into the code I see that it is actually dealing with two join queries so I am not sure if the union all still works or what I would need to do to make it work. I tried coding it as...
  3. Re: Sorting more than one table in single query?

    Well, unfortunately it is a foxpro DBF and it is being accessed from Excel so that throws a wrinkle into it.

    WHat I have right now are two completely separate queries the history is query first...
  4. [RESOLVED] Sorting more than one table in single query?

    I have two identical tables one is current and the other is history.

    I need to select fields from both tables and need to sort them by date.

    Initially I used two queries assuming that the...
  5. Replies
    10
    Views
    732

    Re: Form designer in IDE glitching

    If you have AMD graphics on it you may want to reconsider.

    I recently build two new systems and put Windows 11 on both of them everything seemed fine at first but started having major display...
  6. Re: Problem with VS after latest Windows 10 update

    I am a little reluctant to change versions of VS mid project. Sometimes that does not go well. VS2017 was working fine until the update.
    I am setting up a new machine and will put the newer version...
  7. Problem with VS after latest Windows 10 update

    Hi guys, wondering if anyone has ran into and solved this issue yet.
    There was a recent update for windows 10 that is causing an issue with VS2017 possibly other versions.
    Once the update has...
  8. Replies
    2
    Views
    545

    Re: Name Statement

    D: is not valid you need either D:\ or D:\FolderName ......
    Can't remember off the top of my head if the destination filename is also required quite possibly may be.
  9. Thread: Mscomm?

    by DataMiser
    Replies
    19
    Views
    1,734

    Re: Mscomm?

    Not sure what you did or where the error came up. There is no subscript in the line I posted.
  10. Thread: Mscomm?

    by DataMiser
    Replies
    19
    Views
    1,734

    Re: Mscomm?

    Dim i As Long
    For i = LBound(chunkContent) To UBound(chunkContent)
    MSComm1.Output = Chr(chunkContent(i))
    Next i
    Get rid of that part.

    Send the whole chunk instead
    ...
  11. Thread: Mscomm?

    by DataMiser
    Replies
    19
    Views
    1,734

    Re: Mscomm?

    You are converting it to text and send one byte at a time. You need to be sending the entire chunk as binary. This will increase the speed dramatically.

    Yes serial communications is slow by todays...
  12. Replies
    19
    Views
    3,356

    Re: Would you buy TwinBasic ?

    I don't know, haven't really looked at it but also have not had much going on with VB6 or even VB.Net over the last few years pretty much everything I have did has been coded in either C#, JS or B4A....
  13. Re: What is the best program in preparing a program report?

    https://www.grapecity.com/forums/ar2/latest-version-of-active-reports-for-visual-basic-6-0#:~:text=The%20latest%20version%20for%20use%20with%20VB%206,a%20supported%20design%20environment%20for%20Activ...
  14. Re: What is the best program in preparing a program report?

    IMO Active Reports is as good as it gets. I've been using it since VB5 and would not want to use anything else.
  15. Replies
    3
    Views
    2,597

    Re: [RESOLVED] JS Hide column in table

    Looks like I have it, I added the id to the th part as well and it looks to be only affecting the table desired.

    $('#ITCase td:nth-child(3),#ITCase th:nth-child(3)').hide();
  16. Replies
    3
    Views
    2,597

    Re: JS Hide column in table

    I have also tried

    $('#ITCase td:nth-child(3),th:nth-child(3)').hide();
    Where ITCase is the id of the table in question.

    This also correctly hides the column in the ITCase table but also hides...
  17. Replies
    3
    Views
    2,597

    [RESOLVED] JS Hide column in table

    I have a page that has multiple tables on it. I need to be able to dynamically hide/show one of two columns on one table and need to show or hide 3 of 6 columns in another table and I need to do this...
  18. Re: Updating table with sum from another table

    What result are you getting?
    What result do you expect it should give?
  19. Re: Why is VB6 IDE crashing when I change some code.

    What message do you get when it crashes?
    Are you doing any sub classing in the project?
    Using any custom or 3rd party controls, dlls?
  20. Replies
    23
    Views
    1,939

    Re: Formatted data in textbox

    In the 80s? That would be quite a feat given that VB6 was released in 1998 ;)
    VB3 was not yet around in the 80s
  21. Re: Out Of Memory error when executing a function

    First thought is a memory leak, something being loaded and not properly unloaded causing the program to eventually crash for lack of memory. I would have a look at the memory used by the program over...
  22. Re: I found many planetsourcecode codes but I can't find the way to open the psc file

    Really? I did not know that. I have a habit of installing and using Power ISO so never bothered to check.
  23. Replies
    27
    Views
    2,669

    Re: [RESOLVED] Do Loop Question

    I think Wend predates all of those End Whatever statements. Can't remember if Select Case goes back that far but none of those others existed in early forms of basic while wend did but once the Do...
  24. Re: I found many planetsourcecode codes but I can't find the way to open the psc file

    Looks like they are ISO files.
    You can mount them with a program like PowerISO and have them behave as a virtual CD or you can burn them directly to CD and use them that way.
  25. Replies
    27
    Views
    2,669

    Re: [RESOLVED] Do Loop Question

    I think the last time I used a While Wend in BASIC code may have been in GWBasic, possibly VB3 or VBDos. As of VB5 I never even consider using them in VB code. I have used the While loop in other...
  26. Replies
    12
    Views
    1,252

    Re: Weird problem with Line Feed

    Well, I would have to say that no you did not try that because the code posted in post#2 works exactly as expected.
    Output is as follows
    Line1
    Line3
    Line5

    Whatever you are doing you have a...
  27. Replies
    11
    Views
    1,542

    Re: Creating new versions of a VB program

    For the most part no it should not lead to problems with over writing, provided of course that the source files are all in that folder tree and you are not linking to source files in some other...
  28. Re: Can not unload from within this context - Error 365

    You can use the timer but what you need to do is just have the code in the timer that unloads the form and then in your routine that prints the form at the end of that code start the timer that way...
  29. Replies
    7
    Views
    762

    Re: [RESOLVED] SQL Update question

    LOL

    Yep, I was very surprised but had to try it and see, went through and looked at the data and everything looks good,

    Thanks again.
  30. Replies
    7
    Views
    762

    Re: [RESOLVED] SQL Update question

    Thanks for that info on RecNo()
    Turns out to be simple after all


    Update TableName Set RowNO=RecNO()

    Worked like a charm
  31. Replies
    7
    Views
    762

    Re: SQL Update question

    The DB is FoxPro I think version 8, though I am trying to execute the query through code from within my program.

    I tried looping through and updating with a simple VB6 piece and it failed after...
  32. Replies
    7
    Views
    762

    [RESOLVED] SQL Update question

    I find myself needing to update a rather large table with a new field.
    What I need is for this new field to hold basically a row number. There are already a lot of records in the table and the...
  33. Replies
    9
    Views
    1,053

    Re: .recordcount vs COUNT

    I've did quite a bit with dbfs and sqlserver no problems there either.
  34. Replies
    9
    Views
    1,053

    Re: .recordcount vs COUNT

    cursor location.

    When using client you should get an accurate recordcount
    When using server you will not get an accurate recordcount.
  35. Replies
    26
    Views
    2,356

    Re: save data id and list1

    Well you have not gave a clear description of what you are really trying to do. The code you showed does not give much of a clue as to what you want your end result to be and clearly you have not...
  36. Replies
    26
    Views
    2,356

    Re: save data id and list1

    So your items are not in a list? That code just tries to write the same text multiple times to the same location in the file which is apparently a bad location. ListIndex is most likely = -1 when...
  37. Replies
    26
    Views
    2,356

    Re: save data id and list1

    You only have one spot in the code that does a write and that spot writes only 1 record.

    If the intent is to write everything from the list then you need to loop through the list and write each...
  38. Re: Installing older version of VS with newer version already present

    That is kind of what I was thinking, I did create a new clean Windows 7 VM this morning and could put the VS2008 on there I suppose, That may be the best option anyway as I am unlikely to need it...
  39. Installing older version of VS with newer version already present

    I have a customer that wants some changes to an old project. The project is for a Windows Mobile Device and was done with VB 2008. The issue I have is that my current system does not have VB 2008...
  40. Replies
    6
    Views
    1,547

    Re: [RESOLVED] XP VM issue

    So at least that is one thing I don't have to worry about now. I rarely ever have a need to boot up XP but I did have a request from an older customer last week wanting some upgrades to an old piece...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width