Search results for query: *

I need to process (run some queries on) data from a series of ASCII files. I have the list of filenames to process in a table. How do I write code to select the proper database, open the table with the filenames, and loop through each name in the table until the last one, running the queries...

I have a 2-column report with a report footer that consists of four boxes that stretch across most of the width of the report. If the report footer fits on page one, it prints across the entire width as it should, but if the footer is pushed to page two, it seems to start using the column...

Bchemist, You could try specifying the header names in the crosstab query by right-clicking in the upper panel and typing in the names you want in the header section i.e. "A_3.1","A_3.2", etc. But remember, Access uses the . to separate table names from field names in query...

Try creating a query of ClientIDs only, set it to unique values only (right-click on top panel-Properties-UniqueValues/Records=Yes). Then use that query to create your one-to-many relationship. I hope this helps, Paul

I am getting an error message (Access 97) that reads "Can't Update. Database or Object is Read Only." while using the Transfer Text feature to transfer table text to an ASCII file for processing by another program. The database is shared over the network, and I can open it and...