Recent content by VBrit

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...

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

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

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...

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

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...

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

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...

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...

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...

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...

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.

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...

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...

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.