Search results for query: *

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.

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

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.

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

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

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