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 Chriss Miller 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: *

  • Users: swaimdw
  • Content: Threads
  • Order by date
  1. swaimdw

    Unwanted resizing of Word.doc linked as an unbound object

    Problem: An unbound object frame is being stretched and squeezed based on the individual Display Property Settings on PC’s running the DB. Explanation: I have an Access 2002 system I am developing with linked Word.doc letters that the customer will alter as needed (in WORD) and use to generate...
  2. swaimdw

    Access Criteria IIF Filter (Is Null)

    Greetings, I am trying to filter a query using an Is Null within an IIf statement. Based on a response, I need to return a list of all records with a specific field either empty or not. The Is Null placed directly into the Criteria field along with the field name works fine (ie Is Null Or...
  3. swaimdw

    Access Combo Box

    Using Access 2002 Hi, I have a problem with a combo box in a subform. Only one field is displayed and there is room for three lines in the window before the right scroll bar kicks in. That's when the problem occurs. The right scroll bar covers the combo box drop down activator. If I change to...
  4. swaimdw

    Access Form Text Box Scroll Bar is shy

    Hi, Is there a way to configure the scrollbar on a text box to remain even when the text box has lost focus? I am using a text box to display documented help screens and without the scrollbar it is not obvious to the user that the data being shown is not all there is. Clicking any where in the...
  5. swaimdw

    MS Excel date format yyyyddmm to mmddyyyy

    Date reformatting - I have a column of dates in a worksheet that appear as ( yyyyddmm ) I need to convert this field to mmddyyyy but Excel does not recognize the format as a date, therefore Excel will not auto reformat the date unless I manually insert a hyphen between the items, ie yyyy-dd-mm...
  6. swaimdw

    Access 97 Export Spec's

    I have created an Export Spec in Access 97 to export the results of a query as a text file. Two of the fields are data type number which fluctuate in size from 0 to 100. The problem is that the "DoCmd.TransferText acExportFixed" command writes these two fields as if left justified. The...
  7. swaimdw

    Acccess 97 visual basic

    Is there a way to verify a valid drive path or address prior to attempting to make a new directory (MkDir). The CurDir function appears to have problems even identifying the current drive in Access 97 and app.path does not function with 97.
  8. swaimdw

    Access 97 module using DoCmd

    Programmer thrust into Access using VB module. I need to create a one step process of exporting a .txt file using a querry and filtering by one argument. I am working in unfamiliar territory with this one. I have been using the DoCmd to achieve this, but maybe there is a better alternative. My...

Part and Inventory Search

Back
Top