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

    I need to export data into a sequential text file.

    I need to export data into a sequential text file. Does anyone know how of some vba code that would do this? Eg of file format. Header Block Text Block Trailer Block Enf of File Block eg of a File with 2 records. Header = ddmmccyy Txn Ref = ABC001 Currency= GBP Amount = 125.30 Trailer =...
  2. StevieB01

    Storing a value from an input box for further use

    Function Positions_History_Download() On Error GoTo Error_Handler Dim StaticFileName As String Dim StrInput As String DoCmd.SetWarnings False DoCmd.OpenQuery "Trading_Positions_Delete_Qry", acViewNormal DoCmd.SetWarnings True StrInput = InputBox("Enter Required Business Date YYYYMMDD")...
  3. StevieB01

    Export Data from Access into a Sequential Flat File Format

    I need to export data into a sequential text file. Does anyone know how of some vba code that would do this? Eg of file format. Header Block Text Block Trailer Block Enf of File Block eg of a File with 2 records. Header = ddmmccyy Txn Ref = ABC001 Currency= GBP Amount = 125.30 Trailer =...
  4. StevieB01

    Storing a value from an input box for further use

    Chrisstiaan, I have created a module that prompts the user to enter a date in a text format of "yyyymmdd" into an inputbox. the variable is declared as DIM as String. This variable is then used as part of a file name and destination and is used to import a csv into access and create a table...
  5. StevieB01

    Storing a value from an input box for further use

    I have created an inputbox for users to enter a string. How can I add this value to a query

Part and Inventory Search

Back
Top