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

    help with module to export fixed-width text file

    ok - so my next break in the compiler was at this line: Open "C:\windows\desktop\Today.txt" For Output As intFile I have commented out the Dim intFile As Integer and the intFile = FreeFile lines. Now I need to know how to output the file to the appropriate file location/name. I'm...
  2. jsanderson

    help with module to export fixed-width text file

    I am writing a module to export the results of a query to a fixed width text file. I am using the MSKB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210052 as an example. The only difference that I can see is that the example is based on a table with a primary key and mine is...
  3. jsanderson

    Exporting to Fixed Width text file - formatting problems

    Also - how would I declare "%USERPROFILE%\desktop\today.txt" instead of "c:\windows\desktop\today.txt" to be WinOS version independent?
  4. jsanderson

    Exporting to Fixed Width text file - formatting problems

    I have a query designed that creates all of the data in the proper order and formatting (mostly). On my main form I have a command button with the Click event set up as follows: Private Sub cmdRunReport_Click() DoCmd.TransferText transfertype:=acExportFixed, _...
  5. jsanderson

    Probably a simple question re: table design

    Actually, this database has an extremely simple task and, it may be short-sighted to say so but, it never will be extended. My main form is a payment entry form in which the property number is entered in cboPropertyNumber, the unit number (not ID) is chosen from cboUnitNumber, the payment...
  6. jsanderson

    Probably a simple question re: table design

    Each Property Number has multiple Units (think Hilltop Estates, Unit 2, Redwood Estates, Unit 2) So to copy one of the posts and modify: PropertyNumber UnitNumber UnitID 1 2 AutoNumber 1 3 AutoNumber...
  7. jsanderson

    Probably a simple question re: table design

    I have two sets of data to store: Property Number and Unit Number. Property number is unique but Unit Number may duplicate across multiple properties. So in my table, I have a UnitID field set to autonumber to keep each unit separate. The problem is this: How do I keep the data entry form from...
  8. jsanderson

    Linked Combo Boxes

    I have a two table database (tblUnits, tlbPayments) with two forms (frmUnits, frmPayments). The fields of tblUnits are UnitID(primary key), PropertyNumber, UnitNumber, FirstName... The fields of tlbPayments are PaymentID (primary key), UnitID, PaymentAmount.... There is a one-to-many...

Part and Inventory Search

Back
Top