Recent content by RAtkison

The first thing I would check is the index on Piece_Num.

The only way I can see that you deleted some rows out of the Addresses Table was to run a delete query. On the Query tab, it would be listed with an X! beside the query name. If you didn't do that, the rows may not be deleted. To find out just double click on the table Addresses, right click...

Are you using ADO? Check out the Dir command in vb. You can use it to find a directory or a file on your hard drive. RKA:)

Make sure the KeyPreview Property of the form is set to True. RKA:)

The mid function will get characters in the middle of a string or it will place characters in the middle of a string. a="123456789012314455" mid(a,6,2) = "RA" ?a 12345RA89012314455 RKA:)

I always install the mdac_typ.exe file myself. RKA:)

Here's something to think about. Dim sLine as String Open sFileName For Input As #1 Open sFileNew For Output As #2 Input #1, sLine Mid$(sLine, 63, 9) = “Your Name” Print #2, sLine Do While Not EOF(1) Input #1, sLine If left(sline,10) = “Visual Basic” then Mid$(sLine, 63, 9) = “Your...

You might try refreshing the data control. RKA:)

In the directory where the setup files are stored should be a file called mdac_typ.exe. For ADO to work properly on the users machine, this file must be installed. Hope it works! RKA:)

Try Me.WindowState = vbMaximized RKA:)

This is what I came up with. cmd.CommandType = adCmdStoredProc Set params = cmd.Parameters params.Append cmd.CreateParameter("@RETURN_VALUE", 3, adParamReturnValue, 0) params.Append cmd.CreateParameter("@code_id", 200, adParamInput, 4) Hope it helps. RKA:)

Create a variable with the old file name and new file name. Then use: FileCopy sSourceFile, sDestinationFile RKA:)

On the text box, be sure to set MultiLine to True. RKA:)

On your form, set the KeyPreview to True. Try this code to see if it will do what you're wanting. Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) If KeyCode = 9 And Shift = 2 Then KeyCode = 0 Shift = 0 End If End Sub RKA:)

The database is separate from the exe file. The data is probably in Access, SQL Server or some other database. Re-compiling the VB application should not have any affect on your data. I don't know anything about your application or your data so please be careful. Always backup your...