Search results for query: *

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

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:)

This is a broad example that will hopefully get you started in the right direction. It's looking at a SQL Server database. To connect to Access you would change the connection string. Also to do this you must reference Microsoft ActiveX Data Objects Library. Public Const ConnectionString =...

It appeared to me from what I tried that you could use a query name interchangably with a table name. It seemed to look at them exactly the same. I would try putting in the query name, such as "Select * From Query" just like it was a table. It seemed to work in Access and VB. Hope...

You might consider taking the SQL from the Access query and paste it into the VB str_sql variable. That way you don't have to depend on that query always being there and it gives you a little more control. I'm not sure about the answer to your question but maybe this will help. RKA:)

Great question. I just didn't want to take credit for something I didn't know. RKA:)