Recent content by Morningstarr

The barcode is an excellent suggestion. Pretty much removes user error. Thanks to everyone for your input!

Actually Mike, Bizarre security issue might cover it. Software converts the Hex string to something smaller and prints it to a journal. Should a system failure occur the user will need to enter what has been journaled from a printed report. Then the software needs to convert it back to hex...

Yes 68 characters would be just as bad as 96. 16 or under would be reasonable, but it seems to me there is no way to get it there. Thanks Tom!

I need to convert a Hex string 96 characters long into something printable that can be read and reentered by a user. (A sentence, short string, a few numbers etc) I must then be able to take the string entered by the user and convert it back to the 96 character Hex string. The conversion...

Hi James, That's another problem. It is 8 different databases and at the very least 6 tables per. I'm going to try and consolidate this mess into as few stored procedures as possible. There is one table that is called more than 150 times, which I have already written a stored procedure for...

SonOfEmidec1100 Performance is degraded across the network to the slave when using straight sql statements. James, The stored procedures are probably going to be the way to go but that leaves me with those pesky If Else statements (see previous note) Star for you for query optimizer note...

Hi Vongrunt, Nah no quick code fix, that's what seeks were. Unfortunately I don't make the decisions. The provider decision has already been made. MSDE is it. I was just trying to find a solution that would work for both Jet and MSDE so I don't have to support both types of statements while...

vongrunt, I don't understand your answer, what does this mean? >>>Probably because of over 300 places where this construct is used.<<< thx M

James, Performance from one machine to another I'm told was the reason for the seeks originally. One machine is the server the other(s) is basically a dumb terminal. Pulling entire record sets across the network degraded performance substantially and seek was an easy fix. You do make a good...

I have a VB6 front end that I am moving from MS Jet 4.0 Access DB to MSDE. Within the project there are over 300 places where I use something to this effect: (Pseudo code) rs.Open "tblCust", gConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect rs.Requery rs.index = “lName” rs.seek “Smith”...

Ok granted, that code is SCARY, but remember the old saying "If it ain't broke don't fix it". The application I took over 4 years ago was no where near as bad as what you posted but wasn't good either. We left working code alone, and concentrated on things that were broken. When time...

You may need to use the server name instead of a drive letter. Try: \\<server name>\<share name>\GlobalApps\ICA\PointZero.dll to register it.

I think this is what you are looking for Dim lWidth As Single lWidth = label1.width

In the text box keydown event, Pass in the textbox and keycode to the procedure below Ex. call gFormatToCurrency(txtTravel_Total_Cost, keycode) Public Sub gFormatToCurrency(pTextbox As TextBox, pKeycode As Integer) Dim lNum As String Dim lLength As Integer Dim lInput As String...

In the forms properties, you can set the forms control box property to false. The entire control box will not be shown. Not sure if that is the result you want. Dawn