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 strongm 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: sandymcrae
- Order by date
-
Using a macro to export a table to dilimeted test
Use a 'TransferText' Action with Action Arguments like these: Transfer Type: Export Fixed Width Specification Name: BACSOut Table Name: qryBACSOut File Name: ="\\servername\foldername\" & [Forms]![frmMenu]![user] & ".txt" Has Field Names: No HTML Table Name: Code Page: In this case the file...- sandymcrae
- Post #5
- Forum: Microsoft: Access Other topics
-
Printing database schema
Hi, You don't need to get involved with the database splitter. Just create an new empty mdb file. Then, go to 'File, Get External Data, Link Tables'. Under 'Files of type', select 'ODBC Databases'. You will then be prompted for an existing ODBC connection or you can click 'New' to create a...- sandymcrae
- Post #4
- Forum: Microsoft SQL Server: Setup and Administration
-
Printing database schema
You can use the Documenter is MS Access. Link your tables to an MS Access database, then run 'Tools, Analyze, Documenter'. It has to be an mdb file. The documenter is not available in an Access project (.adp).- sandymcrae
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Outputting a TXT file with the date as the name
You could use a field (possibly hidden) from an open form. I use a macro with 'Transfer Text' and the 'File Name' set to="k:\" & [Forms]![frmMenu]![List10] & ".txt" Where field list10 contains the name of the file.- sandymcrae
- Post #4
- Forum: Microsoft: Access Other topics
