Search results for query: *

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

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

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

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

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

Here is the problem, I have the exact same table, “tblParts”, that lives in two different databases. The only difference is that one database holds manufacturing info for secured parts and the other one holds manufacturing info for general parts. I want to create a view that lists part...

I have written a trigger that uses a Linked Server connection, but when it executes it gives me the following error message "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection." I do not know how to set the ANSI_NULLS and ANSI_WARNINGS, please...

I have written the following trigger to update the status field of a record, when the record is updated. Now I have to rewrite the trigger so that it only updates that status when the record is closed. Can someone please help me with the syntax for this conditional trigger? The following is a...

Can VB6 be used to develop and application for use with a PDA or do I have to use VB.NET? Thanks, RR :-)

Table tblWO2 is a duplicate of tblWO1. Today I discovered that some of the work orders in tblWO1 do not exist in tblWO2. What query can I run to figure out which work orders exist in tblWO1 and not in tblWO2. Thank, RR :-)

I need to multiple instances of my application from executing. I read a prior thread and used their sample code: If App.PrevInstance Then Dim S As String S = Caption Caption = "Something else..." AppActivate S Unload Me Else 'start...

I have written a VB6 application that is a able to open a second application through the use of the Shell() command. The second application always appears minimized in the task bar. How do I get the second application to open up maximized on the screen? Thanks in advance, RR :-)

I need to write a query that will return the Work Order,first step, and step description from the following table where its Copletion date IS NULL. WorkOrder Step Description CompletionDate WO001 1 Mat. Injection 5/1/04 WOO01 2 Deburring 5/2/04 WO001...