Search results for query: *

I was looking in the archives at thread702-840818 for an answer and decided to repost it here. -------- I make a lot of use of forms that have the .MoveSize statement in their opening sequence. I usually put it in the OnLoad event. For some reason, a long time ago, I found that they would not...

I have an MS-Access application that manipulates several Office applications AND a 3rd party application via ActiveX using the "createobject" method. So far, I have had no problems controlling the other apps except the pesky problem of having the other app retaining the focus. For example...

Thanks Tony, You are right ... I didn't show the full filepath, but what you didn't see was that I did set the one variable "Initial_File_Save_Name" to the full path (eg. C:\sss\xyz.doc). It gave me the correct filename but not the correct folder.

I am doing some VBA programming in MS-Word for the first time. I followed someone's example on how to call the MS-Word FileDialog "SaveAs" object. Here is my code: Dim dlgSaveAs As FileDialog CurDir (str_Desired_FilePath) Set dlgSaveAs = _ Application.FileDialog(...

Hi! DTS is new for me. I have a rather long running DTS package that I launch from VB/VBA. I want to be able to do 2 things: -- Launch the package and have it proceed asynchronously (ie. NOT wait until the DTS package completes) -- Get information back from the DTS package as to...

I am new at this and need to capture info about my database. Could anyone recommend an easy way to use T-SQL to print out a list of User Tables and the Fields contained in them? Thanks!

Thanks for your quick response! My process drops the temp table and recreates it at the beginning of the DTS package run. The temp table does NOT currently have an Identity column. If the transform task finishs reading and copying 5 rows into the temp table's column 1, when it starts...

I have a process that queries an external API for data that is in a "flat file" format. Unfortunately, the other source only transfers its data one column at a time. My pre-processing (prior to DTS) takes and writes the data out into text files in a known directory with names like "1.txt" for...

Looks good! Many thanks!

I will be using a self join to determine each record's parent from tblCategory (a lookup table). I have been "toying" with an algorithm to do the job in code. I haven't fully thought it out. I suspect that I can use some Access "stored" queries to speed up parts, otherwise, the process would...

I have an MS-Access lookup table that contains various categories and subcategories. The fields are: ------------------------------------------------- TABLE: tblCategory FIELDS: CategoryID (Prime Key) -- Autonumber, indexed Category_Description -- text fkParentID (Foreign Key pointing to...