Search results for query: *

You were right jebenson, there was something wrong with my sql query. I had mispelled one of the columns wrong. My code works fine now. Thank you all. RR :-)

I made the changes to the code. Here is what it looks like now: Public Function SaveUpdate(ByVal strWO As String, ByVal strProcess As String, _ ByVal intPTI As Integer, ByVal intQty As Integer) As Integer Dim cn3 As New SqlConnection 'Initialize...

I need help updating a record using ADO.Net. I get the following error whenever I attempt to update: An unhandled exception of type 'System.InvalidOperationException' Occurred in System.Data.Common.dll Additional information: Update unable to find TableMapping['Table'] or DataTable 'Table'...

I have developed a VB.Net smart device application for a Pocket PC device. I am using an ADO.Net to retrieve data from SQL Server. The application works fine when ran from the Pocket PC emulator. I now need to package and deploy my app to the Pocket PC device. I want to use a wireless...

Thanks Jan11, I will use your suggestion and let you know hot it goes. R.Rubio :-)

Hello everyone, I used the following ADO/OLEDB connection string to connect to a SQL Server database using VB6: Dim SQLserverCn As ADODB.Connection Set SQLserverCn = New ADODB.Connection SQLserverCn.Open "Driver=SQL Server;Server=Server1;" & _ "Database=Scheduling;UID=SA;PWD=User1" This...

Thank you all. Hypetia, the code you provided is exactly what I was looking for, THANK YOU!!!!!!!! RR :-)

I guess I did not state my question correctly. App2 is not an instance of App1. App2 is a totally different app and therefore App.PrevInstance will not work. Thanks, RR :-)

I have written a VB app (app1) that works both as a stand alone app but may also be executed from within another app (app2) via the Shell command. When app2 is running, updates made to app1 need to refresh the information displayed on app2. How can my app1 know if app2 is running or not...

Thank you. Your input was very helpful.

I have written a VB application that is opened by two different VB apps via the SHELL command. The data that my application displays changes depending on the application that opens it. What I need to know is if there is a function that whill let me know which application is the one that opened...

I have written a VB6 application that retrieves and saves information to a SQL Server database. Everytime the application tries to save to the database I get the following error: cannot start more than one transaction on this session. Can anyone please let me know how to get rid of this...

I have written a VB6 application that retrieves and saves information to a SQL Server database. Everytime the application tries to save to the database I get the following error: cannot start more than one transaction on this session. Can anyone please let me know how to get rid of this...

My SELECT query needs to format a field whose datetype is smalldatetime. The values returned by my query look like this: 1/1/1900 9:40:00 AM. I need the values to look like this: 9:40 AM How can I write my query so that it formats the field for me? Thanks, RR :-)

I would like to display the following error message in bold font: MsgBox "You are about to delete critical data." How can I do so? Thanks! RR :-)

I am creating a table in Access that uses an auto number field as the primary key field. My supervisor has asked me to format this key field into a four digit number so that now the number 1 becomes 0001, 2 becomes 0002, and so on. Can anyone help with this task? Thanks in Advance, RR :-)

I wrote a trigger that inserts or updates a record when the value of the "Secured" field is equal to 1. Here is a step-by-step of the trigger: Step 1: Check to see if the "Secured" field of the updated record has a value of 1. If it is, then proceed with the trigger otherwise do nothing...

Thanks, I will try it and let you know if it worked. RR

I don't have the option to change the column to a DateTime datatype. That's why I need to know how to convert string 8:20 A.M. into a time value. I tried CDate() but that did not work. Thanks anyways. RR :-)

I am working on an application that allows a user to select a time value from a combo box. A sample of the values in the combo box are as follows: 6:00 A.M., 12:00 P.M., 8:30 P.M., etc…. The value selected by the user is then stored in the database as a string (varchar) value. This was not a...