Search results for query: *

I need a T-SQL routine that takes Table1 in this format: ( DUNS [char] (9)-with duplicate values, INDICATOR [char] (4)- ) 111111111 abc1 111111111 abc2 111111111 abc3 ..................... 111111111 abc6 222222222 def1 222222222 def2 222222222 def3 333333333 ghi1 and creates a new table...

Hi all, I have a SQL Server table with 1.2 milion records. All fields are char type with max record length 1066 bytes . I need to export this table into Access 2000.I'm using DTS Wizard and after 500,000 records the process fails with an error: ".... Invalid argument" The Access...

I have a simple select query(Q1) that uses 2 linked tables T1 and T2(from SQL Server 2000): SELECT T1.* , T2.Field1,T2.Field2 FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1 I use then Q1 and T2 to create another query(Q2)- Q2 calls Q1) SELECT Q1.Field1 FROM Q1 INNER JOIN T2 ON...

I have an application with front-end Access 2000 and back-end SQL Server. I am using linked tables through ODBC. I've created a simple select query(qry1) based on 2 linked tables. It worked fine on both system(Win 2k and Win NT) Now if I tried to create another select query based on qry1 and a...

I have a function that takes an Int returns an Int after calculation Public Function OutputDelivered(ProjectID As Integer) As Integer On a form I have 3 controls : R1,[Proposal Traking Number] and the last one [Output_Delivered] In R1_AfterUpdate event , i try to call the function code...

Scenario - Access97/Access2000: I've created a table with one field type MEMO;I upsized the table to SQL Server 2000 using DTS ; The field went to ntext(16) by default, which is correct though; I linked back the table to Access 97/2000 through ODBC (User DSN) and ... the field is NOW type...

I have a table in Access 97(100+ fields) and one of the field is type "MEMO" I upsized the table to SQL Server 2000. The correspondent field on SQL is type "ntext" which is correct. I linked back the table in Access 97 through ODBC. In design view(Access 97) the field is now...

I have a table in Access 97(100+ fields) and one of the field is type "MEMO" I upsized the table to SQL Server 2000 using DTS. The correspondent field on SQL is type "ntext(16)" which is correct. I linked back the table in Access 97 through ODBC. In design view(Access 97) the...

I have a table in SQL Server 2000 that has a field in it of type "ntext". When I try to open the linked table through ODBC using Access97, all that appears for each field in some of the rows is "#Name?" and the error message " ODBC-call failed(error 3146)" Design...

I have a table in SQL Server 2000 that has a field in it of type "ntext". When I try to open the linked table through ODBC using Access97 all that appears for each field in some of the rows is "#Name?" and the error message ODBC-call failed(error 3146) Design view of the...

I have an Access97 application: The front-end is developed in Access97 and the back-end is SQL Server 2000(I migrated all the tables from Access 97 to SQL) When I try to modify/update a record after a while I’ve got ODBC-call failed (Error 3146) I’m not sure , but it seems that the error is...

I have an Access97 db & ABC a query I use the following code code to display the results into an MSHFlexGrid. Why is it displayed JUST the first record ???? What is it wrong ??? Private Sub cmdReport_Click() Dim rs As ADODB.Recordset Dim cmdobj As ADODB.Command Set rs =...

I used automation for sending emails using this function : Sub SendMessage(DisplayMsg As Boolean, CompanyEmail As Variant,AttachmentPath As Variant) Microsoft Article ID: Q161088 I read the CompanyEmail from a table Problem: If DisplayMsg = True - OK - , no metter "how big" is the...

I have a form in a vb6 app. with 3 controls: 1 text box, 1 button, 1 crystalreport I used a stored procedured(SQL 2000) with one parameter - source for my report The report itself works ok if I run it from CrystalReport If I want to pass the value of the text box to the the stored procedure's...

I'm using Automation to send a MS Outlook Message Set objOutlook = CreateObject("Outlook.Application") .... What I intend to do further is to switch between 2 different profiles automatically How can I do this ??? Any help would be very appreciated

I've tried to install SQL 2k EE on win2k. First time I succeeded. After a while I've got an error message and I tried to uninstalled and installed again. But in sqlstp.log file, I got an error message, every time I try to re-install sql 2k. (I deleted the MS SQL folder every time and reboot the...

I have an Access application which open an Excel file and runs the macro inside. Set myXL = GetObject("D:\Book2.xls") myXL.Application.Visible = True myXL.Parent.Windows(1).Visible = True myXL.Application.Run ("Macro2") The macro updates the status bar with...

I've tried a sample code that disable the menu Now when I open Excel ,I don't have the Menu Bar ... and even if I reboot my machine plz help any tips would be appreciate

Hi everyone, Plz,give me an hint. I've written an application in VBA On my machive it works ok.If i run the application on other machine I got the following error: Run-time error 9 Subscribe out of range in the following line : Workbooks("Test").Activate ...