Recent content by rarubio1

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