Search results for query: *

I have a table which has a primary key,this key although numeric is not auto increment but is unique, I need to convert this column to an autoincrement field, can some ome help me with the tsql to achieve this.

I have been tasked with the following: Add a button to excel that when pressed will export a subset of data to a new excel spreahseet. I know how to add a new toolbar and button to excel and even how to attach a macro to the button. My question is how do I store the said macro in such a way as...

Help! I have been given a vb6 codebase for an outlook addin and have to make some changes to it, can anyone tell me how to get the source code to run from outlook in order that i may debug and test the add-in, I have set the start up property to be outlook in the vbp properties debugging window...

Does anyone have a 'Hello World' application to write to a console window?

I have a client pc which throws up this error when I try to instantiate a .net assembly via a vb6 application. the 'expose a com' check box is checked and the code all works fine on another client pc. the Constantrs module is simply a list on constants. Anybody got any ideas?

Can anyone tell me if there is an easy way to do this as I have done it a few times and it has proved to be a headache on each occasion. This would make my life sooooooo muuuuch easier if there is a solution.

Help, Can someone tell me how to iterate row the rows in a sheridain grid control? Otherwise, if I can find them, I shall have to hire the A team.

Can anyone tell me if and how to deteect whom has executed some sql when the sql is executed from an application. The purpsose of this is to, using a trigger, update an audit file with whom has changed what in the db.

Does anybody know how to display the execution plan in 2005 ??

Con some clever sole point out the error in the following delete script please: delete from subscriptionmembers inner join contacts on Contacts.contactid = subscriptionmembers.contactid where contacts.categorycode in ('CPAT','NMP','PAT','DEN','PRAC','DOC','TEA') I get the error Msg 156...

Really stupid question i know but in vb6 Dim App As CRAXDRT.Application what is the equivient in vb.net?

Does any body know if, and how to, it is possible to iterate around the list of properties an Object may have. E.G if the object personal has three properties , Title, First name, Surname, is it possible to eamine each property and check its name then extract the value? I hope this makes sense.

I am trying to convert the ID field on the table termdates to be an auto increment id field can one of you clver sorts (Sql sister probably) tell me where/why this is going wrong? alter table Termdates alter column [ID] Identity(1,1) not null

I have a form with a datagrid on it which is databound to a recordset. when i run the applicaion against Access the datagrid is editable when i run it against sql server it is read only . the code base is the same code base Does any body know how to make both the access and the sql server...

Hope someone can help I have a table and on it i have an update trigger, when i update a single row all works well. If i issue a query such as update table set name = 'Daren' i get the error - Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >...

Trigger query... i want to be able to insert a new record into another table when a particulare field is updated on the source table, my trigger code is below but will not create in execution, can some spot the school boy error? CREATE TRIGGER Test ON tbl_ManualItem FOR UPDATE AS IF...

below is a sql query i run in sql server sucessfully, however in access the declare staements are the cause of errorrs can someone help me re-write this query to fix the issue. Thanks in advance. DECLARE @Result INT DECLARE @Search VARCHAR(255) DECLARE @Value VARCHAR(255) set @Search =...

Help Can anyone tell me how to go about creating a vbg to add aa standard exe and dll to to test.

CAn some one tell me how to convert this SQL Server sql Alter Table table1 ADD LinkDate DateTime Default getdate() into the equivilent Access sql Alter Table table1 ADD column LinkDate DateTime ??????

Can any one tell/show me how to reference an elemetn of a control array from inside the controls collection here is what i want to to but it does not work as it requires the index to work out which coltrol to access For intCounter = 0 To Me.Controls.Count Set c = Me.Controls(intCounter)...