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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: VBrit
  • Order by date
  1. VBrit

    MSComm.Output with multiple keystrokes (Ctrl+Shift+B)

    It would be best to use the mscomm components. Otherwise you will have no interaction with your hardware. Ctrl-Shift-B initiates or opens the connection. Ctrl-Shift-C closes or hangs-up the connection. Try this code on a form with an msscomm control. With MSComm1 .CommPort = 3...
  2. VBrit

    Creating multilingual Registry entries

    Look up %ProgramDir% which is the environment variable for the Program fIles folder. Are you sure you want to do it like this though? Not sure if you can use environment variables in static .reg files? VBrit
  3. VBrit

    updating Text field---very slow

    Hi DotNetGnat, Had a play, I'm stumped..... ntext is a pain. I'll try again with this later! Sorry!
  4. VBrit

    SP which take where clause as parameter

    I'd like to add that using D-SQL in this way, as in Rhys666's solution would definitely be quicker and run faster, but look aesthetically untidy. This is because although D-SQL is not compiled, the SQL engine will have lots less to do because it knows exactly which fields it will be using. This...
  5. VBrit

    Verify FileCopy

    As a little task to keep me busy (bored at work), do you want me to write a version of this for you?
  6. VBrit

    Verify FileCopy

    waytech2003, I am sure that the only way you can verify the contents of the file is to do just that. Load the source files contents, load the target files contents, and make sure they're the same! You could stream the files, and compare after each 1024k(for example) if you wanted a progress...
  7. VBrit

    CloseWindow Function

    Does the window have any dialog boxes or modal forms open that were spawned from it? I think that would cause this behaviour. VBrit
  8. VBrit

    Scrollable Form / Control instead of Reporting Tools

    On your MDI Child draw a picture box. This needs to be resized to however big you want it. Place horiz and vert scrollbar controls on the form. Dump some controls in your picturebox that are positioned inside the pb but outside the form original size... Change the position of the...
  9. VBrit

    updatetext + stored procedure

    Ok got an idea. Take your string manipulation code, and put it in a user defined function. Then from your select statement call the user defined function. Now there are no cursors so it should speed up performance considerably. Also, you may not want to introduce patindex into your where...
  10. VBrit

    updating Text field---very slow

    Ok got an idea. Take your string manipulation code, and put it in a user defined function. Then from your select statement call the user defined function. Now there are no cursors so it should speed up performance considerably. Also, you may not want to introduce patindex into your where...
  11. VBrit

    Convert date to month name

    Hi Dwight, easy as: SELECT datename(m,getdate()) + ' ' + cast(year(getdate()) as char(4)) OR SELECT datename(m,getdate()) + ' ' + datename(yyyy,getdate()) I would guess that the 2nd version might be a bit slower, but not sure what SQL is doing internally to return the year...
  12. VBrit

    Verify FileCopy

    Hi waytech, One thing you could do, although it would slow your application down a lot, would be to load both files into a ByteArray and compare the value of each element with eachother. Any discrepancies would indicate something has gone wrong saving to your Zip drive.
  13. VBrit

    Executing SQL Server Stored Procedures from Visual Basic 6.0

    something like this (parameters may not be in correct order but intellisense will let you know) dim conn as adodb.connection dim cmd as adodb.command dim prm as adodb.parameter dim rs as adodb.recordset set conn = new adodb.connection conn.connectionstring = "driver=SQL...
  14. VBrit

    Obtain Net User Logged-on From Computer Name

    When people open your database, write to a table that you can query using some code, that inserts their NTlogin. Query the last updated row for the details. When they log out youd probably mark this recoird inactive. But what happens if access crashed (as it does - a lot!)?? The ldb file is not...
  15. VBrit

    Keyboard macros

    Write an add-in yourself? Or just use the mouse!! Seriously, write your own add-in to do things you want on keypresses, you can capture alt and ctrl keys so use that mask.
  16. VBrit

    Recursion preventing events from firing

    Silly question, but why not just use the supplied Format$ function in VB? It will be a lot faster. Don't know why your recursion isn't working, probably because when you update your textbox string it will be repeadtedly calling afterupdate event and running your code all over the place. I'll...
  17. VBrit

    Executing SQL Server Stored Procedures from Visual Basic 6.0

    Look up stored procedures VB6 ADO on google. You could use the SQL-DMO, which provides a COM interface to some of the management functionality.
  18. VBrit

    Storing a PDF in a SQL field & printing in Crystal Reports

    Have a look at Acrobat Distiller maybe? Or perhap ask UPS if they can change the way they provide your data? Surely you would ideally want 2 flat files? Just some ideas...
  19. VBrit

    VB 5 - no Round fcn?

    You don't need to use VB in order to write user defined functions for Crystal reports. There is built in functionality in Crystal to allow you to write functions. I would suggest that you check the Crystal documentation. VBrit
  20. VBrit

    Method '~' of object '~' failed

    Have you checked that you are not setting anything as 'New' and you are using the getobjectcontext to set the object? Just to be sure....

Part and Inventory Search

Back
Top