Search results for query: *

Basically, I need to control the position of a record I am inserted. I have created TableX with a single column (no index) varchar(8000). Main Stored Procedure calls Stored Procedure 1 which inserts a 'header record' in TableX. The calls Stored Procedure 2 which queries several other...

Summary of what my DTS Package accomplishes: A stored procedure is executed to populate a table in the database with the data I need using an execute sql task. Using a transform data task, I tranform the data to a destination text file. All of these task 'values' are set using the dynamic...

I have an execute process task in my DTS Package that I only want executed if a Global Variable value = Y. Here is my code: Function Main() ' Check global variable from package If DTSGlobalVariables("sZipFlag").Value = "Y" Then Main = DTSStepScriptResult_ExecuteTask Else...

I have created a job that will be executed as a Multi-Server job. The first step is an ActiveX Script in which I need to query the sysdatabases table in order to get a recordset of the databases on that server. In order to run the Select statement, I am creating a connection string that...

I would like to be able to zip a file using WinZip or PKZip as step one of my DTS package. I assume I will need to do this in an active X task as it will require a commmand line call to the winzip or pkzip.exe. Am I headed down the right path or is this beyond the capabilities of DTS? Any...

I created an excel spreadsheet that performs some email tasks using vba for applications. I set the references in the VB editor, but when I send the spreadsheet to someone else, they receive errors until we set the references on THEIR machine as well. Is there a way to 'complile' the...

I searched the forum, but could not find this issue addressed. Access 2000. I have a query in which one field is a date. I have parsed out MyMonth: MyMonth = Month([MyDate]) and now want to perform a function on MyMonth to get the month 6 months from now, My6Month. Example: If MyDate is...

Info: Running Word and Excel 2000 but saving both files as 97 compatible. I have seen this done in Word, but not Excel. I want to create a spreadsheet that has a Word Doc 'embedded' in it. I have created the spreadsheet that will be sent out to various people, now I want the document...

I have created a DTS package that makes one connection and creats 7 .txt files based on different select statements. Each .txt destination file needs to have a path and file name assigned (General Tab on Properties of Text Destination.) I want to be able to manipulate (before or after...

I need to write an ActiveX Script that will be executed via the DTS utility in SQL Server 2000. I create 7 files using DTS but the name of the file is not a variable so it is hard coded. I would like to run a quick script after the files are created to concatenate the date to the end of the...

I have created a spreadsheet with a few checkboxes and radio buttons. I have grouped the cells that lie underneath the objects, but when I collapse the group (click the little "-" next to the row numbers), the radio buttons and check boxes remain on top and visible. Is there a way...

Is there a way to find the exact name of an event - I have a label with a click event - I want to know the name of the event i.e. if the label is label10 and the event is a click event - can I find the string label10_onclick in any property

I am using a form with a number of checkboxes on it. After a user checks some boxes and clicks a button to print, the code should read all the checked boxes and loop through them to get a report name. The loop calls each report in turn and print previews it. Unfortunately, the code opens all the...

I am on my hands and knees here, hoping someone can help me with this problem. Running Access 2000 on W2K. I am using a SQL backend by linking tables through an ODBC connection. I made a lot of changes to my access front end and now everytime I try to do anything (click, select from a drop...

This is probably an Excel 101 question, but I just cannot make it work. I have a complicated worksheet with a zillion formulas that reference a zillion other spreadsheets, workbooks and cells. I would like a print out of the spreadsheet that shows all of those 'formulas' in the cells rather...

Running Access 2000 on a Win 2000 Server (metaframe) box. The .mdb lives on an application server. About twice a day, users get that annoying 'this file needs to be repaired or is not a valid .mdb file.' Funny thing is, some users get that message while others are happily working away in the...

Running Access 2000/W2K Unbound Textbox on a report has the following: Control Source: =IIf([DTCurrAmtGL]=0,[DTCurrRate],[DTCurrAmtGL]) Format: Standard Decimal Places: 3 In the table with these field in them, DTCurrAmtGL is a standard datatype and the data is stored as xxx,xxx DTCurrRate...

I set up conditional formatting on form A and form B and it work exactly as I want it to. But when I imbed the forms as Subforms into form C, the conditional formatting does not work. The conditional formatting is an expression: Expression is [Forms]![frmAsset]![CADetail]="Y" Result...

W2K, Access 2000. Created 15 forms that need to be subforms on Form1. All 15 subforms have Can Grow and Can Shrink set to Yes on Property sheet within Form1. All 15 subforms are continuous forms. Objects are not overlapping on Form1. The problem is, they don't grow and shrink! Say there...

Running Access2000 and W2K. Have multiple subforms on a main form. Can Grow, Can Shrink properties set to Yes on Detail (main form), all subform objects on main form and Detail (subforms). Subforms are continuous forms, main form is single form. Found in help that overlapping controls cannot...