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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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 =...- StevieB01
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
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")...- StevieB01
- Post #6
- Forum: Visual Basic (Classic)
-
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 =...- StevieB01
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
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...- StevieB01
- Post #3
- Forum: Visual Basic (Classic)
-
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- StevieB01
- Thread
- Replies: 6
- Forum: Visual Basic (Classic)
