Search:

Type: Posts; User: oprache

Search: Search took 0.02 seconds.

  1. Re: What is the correct syntax for INSERT INTO using VB.Net and MS Access?

    Thank you both for the quick response.
    I apologize for not displaying the code right: I confess I do not yet know how to do that.
    The blog is fantastic, thanks for the link and I could not agree...
  2. [RESOLVED] What is the correct syntax for INSERT INTO using VB.Net and MS Access?

    Hi,
    I am using VisualStudio for WebExpress and VB.NET and my data is in an MS Access 2010 database (.accdb)
    I connect using OLEDb (that part works well).
    I have been trying (so far in vain) to...
  3. Re: Cannot pass a DBNULL parameter using OLEDB

    Thank you Wild-bill, this worked!
    I had thought I needed to use the .Add method instead of the .AddWithValues method to pass this parameter, based on another post I read earlier.
    Much appreciated...
  4. [RESOLVED] Cannot pass a DBNULL parameter using OLEDB

    Hello,
    I hope this is the right forum for my question.
    I am using VB in an ASP.NET application connecting to an MS Access db (Access 2010) using a stored parametrized query
    I want to be able to...
  5. MsOf03 Re: Excel 2003 VBA: Getting error 1004 when trying to open a *.csv file via VBA

    Problem Solved!
    Contrary to my previous statement, the path and filename are needed.
    To ensure the file is recognized as a csv, it is best to use the .open method as follows:
    workbook.open...
  6. MsOf03 Re: Excel 2003 VBA: Getting error 1004 when trying to open a *.csv file via VBA

    Hello westconn1,
    Thank you for the tip, it does work in the sense that it opens the csv file.
    However I used workbooks.open(myfile) since mypath was already included in the dir statement.

    It...
  7. MsOf03 [RESOLVED] Excel 2003 VBA: Getting error 1004 when trying to open a *.csv file via VBA

    The machine is a Win XP Pro PC with Excel 2003 (no other office application).
    My program is trying to open a csv file in a series of specific folders.
    The .csv file has a variable part to its name...
  8. Re: How to interrupt a method from a user form control?

    Hi,
    Thanks for the quick reply. I tried that and it did not work initially but after adding a DoEvents in my motion loop, it worked like a charm.
    Thanks again
    Olivier
  9. [RESOLVED] How to interrupt a method from a user form control?

    Hi,
    I have a class module that basically controls a motor to open/close a trap. I defined the open and close methods. The methods simply turn on (of off) the motor and monitor the closure of a limit...
  10. Re: How to make an exe with no form?

    Solved the problem:
    Remove the form in the project
    Add a Sub Main in the main module
    Set the project to start with Sub Main in the Project Properties window
    Olivier
  11. [RESOLVED] How to make an exe with no form?

    This may be a silly question but I do not need a form to run my code since it will be called from a scripting application.
    The issue I have is that all of the code runs automatically once the form...
  12. Re: Empty squares reading from memory

    Problem Solved!
    The following statement was missing:
    tid = GetWindowThreadProcessId(hwndPHD, pid) (declare tid as long)
    This statement must come before the memory allocation function which uses...
  13. Re: Empty squares reading from memory

    Something new: In the code above I forced the string sTemp as follows:
    sTemp = String(dwSize, "A")
    I then ran the code and looked at the results of using the ReadProcessMemory function:...
  14. Re: Empty squares reading from memory

    To Quiver138:
    No I have not tried it on anything else. I am not that familiar with using APIs but I am thinking of trying to write known data to the memory area and read it back (using the same...
  15. [RESOLVED] Empty squares reading from memory

    I am trying to get the text in different panes of an msclts_statusbar32 status bar in another application.
    I found some clever code from Arkadiy Olovyannikov that gets me to the point where I can...
  16. Replies
    2
    Views
    921

    Re: Problem with FindWindow API

    Thanks.
    I found my problem. I thought it was timing related and added a delay but that did not do it. The solution was to place a Do Events and a loop polling FindWindow until it returned a non zero...
  17. Replies
    2
    Views
    921

    [RESOLVED] Problem with FindWindow API

    I use ShellExecute to launch an application from VB6. I then use FindWindow to get the application's window handle. Using Spy++ I know the class and the window caption, which I input into the...
Results 1 to 17 of 17



Click Here to Expand Forum to Full Width