Search results for query: *

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

I would also go with SWI's solution. The thought behind my answer was if he was getting the values from someplace or if they change, he could load them into an array. If they are hardcoded then I agree the select case is the best way to go. Dawn

store values in an array like this arrNums(1)= 6 arrNums(2)= 12 arrNums(3) = 17 then use a loop to check them for i = 0 to ubound(arrNums) if intX = arrNums(i) then 'do what you want to do 'exit the for loop end if next i hope this helps Dawn

I found the solution, I'll post it here in case someone else ever has the same problem. Thanks again, Dawn 'To Run task 2 and shut off task 1 Function Main() Dim oPkg Dim oStep USPump = &quot;DTSStep_DTSDataPumpTask_1&quot; PRPump = &quot;DTSStep_DTSDataPumpTask_2&quot; Set...

I have a DTS package in SQL Server 7, within the package the steps are: an active x script, SQLServer source, text file destination and three datapump tasks running from source to destination. I want to have the active x script in the begining, stop two of those datapumps from running by...

Excellent!! Thank you both