Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andylec

    ISLOADED

    Unload frmYourForm rgds Andy
  2. andylec

    Unable to get Negative value from text

    I'm guessing the numbers in the text file are padded with zeros to get a fixed width format, hence a -ve sign in the middle. Just needs something to trim the leading zeros. rgds Andy
  3. andylec

    Noob hWnd Question

    FindWindow or FindWindowEx. rgds Andy
  4. andylec

    Using a string in an SQL query

    "SELECT * FROM bugs WHERE dbbugdescription LIKE ('" & searchstringtext & "')"
  5. andylec

    Cin and cout??

    Just to elaborate on chipperMDW: #include <iostream> using std::cout; using std::cin; although I'm not sure that it needed any elaboration, concise and accurate as it was. rgds Andy
  6. andylec

    Error in source code about reading intensities of pixel

    Straight from MSDN: The GetPixel function retrieves the red, green, blue (RGB) color value of the pixel at the specified coordinates. COLORREF GetPixel( HDC hdc, // handle to DC int nXPos, // x-coordinate of pixel int nYPos // y-coordinate of pixel ); rgds Andy
  7. andylec

    Using Winsock without a Form

    Have you considered a wrapper class, such as the one at http://www.vbip.com/winsock-api/csocket-class/csocket-class-01.asp You can find plenty more examples with a quick google. rgds Andy
  8. andylec

    Inline assembly with Dev-C++?

    Assuming you are using the MinGW compiler (Dev-C++ is only an IDE, and can be used with other compilers), have a look at the bottom of this page: http://www.bloodshed.net/faq.html rgds Andy
  9. andylec

    Using COM Add-In functions in SQL statements with Access 2K

    Nice idea :) Unfortunately, I can't use CallByName in an SQL statement, at least not directly. If I wrap the call inside a function that resides in the .mdb (or referenced .mde), just like the MyFunc example above does with the Replace function, then it can be used, but that brings me back to...
  10. andylec

    Using COM Add-In functions in SQL statements with Access 2K

    I do understand all you say regarding the difference between Access and the database engine it is using, but say I have: ' Test function for illustration Public Function MyFunc(varValue as Variant) as Variant If Not IsNull(varValue) Then varValue =...
  11. andylec

    Using COM Add-In functions in SQL statements with Access 2K

    Bad news? Not at all. I'm no worse off for your comments - I can still do what I need to with the work arounds I'm currently using. Just much more slowly :) But why can I use the very same functions in this manner if I copy/paste the code into a code module of a seperate .mdb and then set a...
  12. andylec

    Using COM Add-In functions in SQL statements with Access 2K

    I've written a COM Add-In for Access 2000. While most of it seems to work OK, I'm having trouble executing any SQL statements (using a Command object) that contain custom functions, e.g. strSQL = &quot;UPDATE MyTable &quot; & _ &quot;SET MyField = StrConv(MyField, vbUpperCase)&quot...
  13. andylec

    timestamp

    Can you set the required property of the date field to True, and the default value to Now()? This works with Access, not sure about others. rgds Andy
  14. andylec

    1 + 1 = 2 not 1 + 1 = 11 ....

    Why not declare the variables properly, eg Dim intA as Integer, or Dim lngB as Long. At the moment you've got them declared as variants. Then use Val(Text1.Text) to assign the value to the variable. rgds Andy
  15. andylec

    WinXP prob. with recursive directory listing function

    Close, but by using finder.dwFileAttributes == FILE_ATTRIBUTE_DIRECTORY it misses any folders marked as Read-Only, System, etc.. If I change the bitwise-AND operator to '==' in the code I was trying to use it has the same effect. rgds Andy
  16. andylec

    WinXP prob. with recursive directory listing function

    I'm trying to list all folders on a system using a recursive function. The following function works fine with Win 9x systems, but has problems on XP (not tried on NT or 2000). It gets to a protected folder named &quot;System Volume Information&quot; and seems to start again from the first...
  17. andylec

    font size for labels

    Try some other fonts. Some go smaller. rgds Andy
  18. andylec

    Variables

    It's all to do with the scope of the variables. If you declare a variable in a procedure you can only use it within that procedure. rgds Andy
  19. andylec

    Change File Association

    Try ShellExecute to open any file with its default application. Search this forum for examples of usage. rgds Andy
  20. andylec

    SetWindowText has a 32KB limit?

    Haven't had a chance to test this in C/C++, but it works fine in VB: SendMessage(hwndOfEditBox, WM_SETTEXT, NULL, string), where &quot;string&quot; is the text you wish to fill the edit box with. rgds Andy

Part and Inventory Search

Back
Top