Search:

Type: Posts; User: Chief Brad

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    2,542

    Vb dot net compiler

    Hi Y'all - -

    Before anyone asks why in the world I'm still writing lots of VB 6.0 code, I'll make it totally clear, I'M CHEAP, actually I like frugal better. Doesn't sound quite so negative. ...
  2. Replies
    1
    Views
    663

    Controlling computer audio

    Morning Y'all - -

    I'm trying to do something that it seems should be fairly simple, but even after looking through this forum and other sources in depth, I just can't quite find what I'm looking...
  3. Replies
    40
    Views
    64,079

    Re: [vb6] Transparent PictureBox

    This appears to be an answer to something I've been trying to do for some time now. While I'm very knowlegeable in much of VB6, I've never used user controls, and I'm at a loss on how to call or use...
  4. Re: Clearing date fields (ms access / vb6 / ado)

    GaryMazzone's response above does the trick!! I know I tried setting the date to Null in the SQL string before, but I'm betting I was leaving the ## on either side which still caused an error.
    ...
  5. Re: Clearing date fields (ms access / vb6 / ado)

    Here's the code snippet and the error that I'm getting. Before you look at the code itself, let me explain one thing, for various reasons now lost to antiquity, when I select a date using the...
  6. Re: Clearing date fields (ms access / vb6 / ado)

    Well, that might be headed in the right direction, or at least converging on the solution, but not entirely. Setting dtpicker.value=vbnull, either via the dtpicker checkbox or any other method,...
  7. [RESOLVED] Clearing date fields (ms access / vb6 / ado)

    I have been working for some time on a large MS Access DB with a VB6 front end, and have come across an issue that I haven't been able to resolve or work around.

    My DB has many date fields that I...
  8. Replies
    5
    Views
    625

    Re: List of modules

    TO: akhileshb

    That's an option that I can try.

    Chief Brad
  9. Replies
    5
    Views
    625

    Re: List of modules

    Sure, there's no reason that wouldn't work, but I'd always rather do something programmatically rather than hard code it.

    Chief Brad
  10. Replies
    5
    Views
    625

    List of modules

    I've searched the archives and found several similar questions to this, but nothing that appears to be exactly what I'm looking for.

    I'm working on an MS Access database with a VB6 front end. ...
  11. Re: FileSystemOnject/ Run-Time error 13 Type Mismatch

    BINGO!!

    Adding the Scripting library name before the Folder, File, and Files declarations did the trick!!

    Thanks Si and Hack for all of your suggestions.

    Now on to other things . . . . . ....
  12. Re: FileSystemOnject/ Run-Time error 13 Type Mismatch

    Sorry, still no luck.

    The Add Procedure under the Tools drop down menu defaults to Public, and I'll admit that I'm not very cautious about setting it back to Private when opening a new...
  13. Re: FileSystemOnject/ Run-Time error 13 Type Mismatch

    Hi Hack - -

    Yeah, as I said in my original post, I originally wrote the subroutine in a totally seperate VB6 project, all by itself, just to test the code, and it works fine. But when I pasted...
  14. Re: FileSystemOnject/ Run-Time error 13 Type Mismatch

    Thanks Si - -

    I had looked at that before and everything I read said that the "scripting" library name was optional, BUT I had tried that anyway with no success. I just tried it again as a sanity...
  15. [RESOLVED] FileSystemOnject/ Run-Time error 13 Type Mismatch

    Ok friends, I've searched the internet and these archives and am at a real loss on this one.

    I'm developing a pretty complex MS Access database with a VB6 front end and one thing that I need to...
  16. Using savesetting/getsetting with windows vista and vb6

    I have an MS Access database front end written in VB6.0. This front end reads and writes to HKEY_CURRENT_USER\Software\VB and VBA Program Settings in the registry using SaveSetting and GetSetting to...
  17. Replies
    27
    Views
    3,997

    Re: Interpolating a rectangle [Resolved]

    This a very interesting thread to me as I've been scratching my head over something similar for some time, and all I've gotten so far is dandruff under my fingernails!!

    I have two maps of the same...
  18. Replies
    4
    Views
    1,013

    Re: Permissions error - .frx file

    Good suggestion, but unfortunately I can't run either error checking or defrag without admin privileges, which the company won't give me. If this happens again I'll call the help desk and see if...
  19. Replies
    4
    Views
    1,013

    Re: Permissions error - .frx file

    An addition to my above post:

    Out of the blue, and without doing anything obvious, the error went away and the project has been saved. I am quickly saving a current back-up of the entire project,...
  20. Replies
    4
    Views
    1,013

    Permissions error - .frx file

    For the second time in the past week I'm getting the following error when I try to save my VB6 project:

    "Permission Denied: <path>\file.frx"

    The first time it happened I looked and looked for a...
  21. Replies
    1
    Views
    613

    [RESOLVED] Vb6 / outlook email

    I am building an MS Access database with a VB6 front end, and one part of this will send an occasional automatically generated email from the VB6 front end to the database admin. I can send email in...
  22. Replies
    9
    Views
    786

    Re: [RESOLVED] Problem with sql statement

    Great!! Thanks.
  23. Replies
    9
    Views
    786

    Re: Problem with sql statement

    Thanks. Before my original post I wondered if it might be reserved, but couldn't find anything in the MSDN help files.

    Anyway, it's working now, so thanks!!

    Chief Brad
  24. Replies
    9
    Views
    786

    Re: Problem with sql statement

    Thanks, that worked like a champ!!

    But why are the brackets required when I don't have to use them with any of my other field names??

    Chief Brad
  25. Replies
    9
    Views
    786

    Re: Problem with sql statement

    Thanks for the good suggestion, but it's already been tried.

    I neglected to mention in my original post that the run-time error message that I'm getting is: -2147217900(80040e14) Syntax error in...
  26. Replies
    9
    Views
    786

    [RESOLVED] Problem with sql statement

    Good moening y'all - -

    This one has me absolutely baffled, and I'm sure I'll feel REALLY stupid when I get it figured out, but so far nothing I've tried has worked.

    The following SQL statement...
  27. Re: [RESOLVED] Ms access vb6 sql wildcard syntax

    Yeah, that's exactly why I did it that way and I should have made that clear. This leaves the user the option of including appropriate wildcards in the txtCRNumber.text box. The only difference...
  28. Re: Ms access vb6 sql wildcard syntax

    Thanks for the suggestions and a tip of the hat to both of you. I learned something new here and you'll be glad to know that the following works perfectly:


    strSQL1 = "SELECT * FROM...
  29. Re: Ms access vb6 sql wildcard syntax

    Thanks to both of you for the suggestions. Let me play with that and see what I can work out.

    The number field that I'm specifically working with here is an "ID" field and not a numeric that I'll...
  30. [RESOLVED] Ms access vb6 sql wildcard syntax

    I'm in the middle of a database development project using MS Access for the back end and VB6 for the front end. I can easily do wildcard queries on database text fields using something like:
    ...
  31. Re: Opening and closing ado connections and recordsets

    This thread is all good gouge and stuff that I've never known before. Reading more on this under "Tips For ADO Users" at http://msdn.microsoft.com/en-us/library/ms810829.aspx it appears to me that...
  32. Re: Opening and closing ado connections and recordsets

    Thanks for the info. I missed the earlier mention of "connection pooling". Can you give me a very brief description??
  33. Re: Opening and closing ado connections and recordsets

    Thanks for the info. I've seen it done both ways in tutorials, but wasn't sure what the best "real world" method might be. I hadn't thought about the network issue however, and my database will...
  34. Opening and closing ado connections and recordsets

    I've searched through the archives and can't find a previous answer to my question.

    I'm developing a database using VB6 for the frontend and MS Access as the backend. I have been opening my ADO...
  35. Re: Rearranging Tabs On ssTab Control

    Thanks, and I think this is the direction that I need to go. What the heck, I've got all night to work on it anyway.

    I don't have a good reference that shows TabStrip, but I see that I can't...
  36. Re: Rearranging Tabs On ssTab Control

    I just played around with TabStrip for a few minutes, and at least it will allow me to insert a new tab between two existing tabs, "C" between "A" and "B" in my previous example. Switching to...
  37. Re: Rearranging Tabs On ssTab Control

    As a way of answering your question, let me explain basically what happened. I the earlier stagesof my design, I identifed only two tabs ("A" and "B") as being required, and that's what I used. ...
  38. [RESOLVED] Rearranging Tabs On ssTab Control

    I'm a new member of this forum although I have perused it a bit in the past.

    I'm a very experienced VB6 programmer, but have never used ssTab until my current project. Yeah, I know, some...
Results 1 to 38 of 38



Click Here to Expand Forum to Full Width