Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tomatdeepwater

    Problem with Form MoveSize

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

    Keeping Access in focus when using CreateObject

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

    Changing Initial Folder of the FileDialog(msoFileDialogSaveAs) Object

    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(...
  4. tomatdeepwater

    Launch DTS Asynchrously from VB / Get status from DTS

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

    How to print out list of user tables and fields

    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!
  6. tomatdeepwater

    DTS - ActiveX DataTransformation Script Problem

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

    Aggregate and Roll-Up Query

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

Part and Inventory Search

Back
Top