Search results

I have a form with 45 different Yes/No fields in, I need to produce totals of those selected. I tried a bog standard totals query but this just gave the number of records in the form regardless of the state of the relevant checkbox. Do I need to do 45 queries each one stating criteria of Yes...

I want to output a fixed length text file each record 525 bytes long. This file would come from 3 different tables. Record1 - From Table1. Records 2+ - From table 2 Last record - From table 3 Is this as straight forward as setting up a report with record 1 in the heading, records 2 etc in the...

Apologies, if this is old hat however Im currently teaching myself Access 97 after years of DataEase. I have 2 macros that run a) a spreadsheet export based on a date selected and then b) a printed report on the same date. However, I cant seem to find a way to ask for the date at the start of...

I have a macro that imports a simple Excel spreadsheet. Yet when it runs I receive a "File not in required format" error. However if I open the file in Excel and then run the Access macro it works!! Why?, what?, how? help!! Peter

I am setting up a database that imports an unknown number of records to a form. The form should ONCurrent is set to run a macro which validates the data and sets certain SetValue's dependant on the validation in the macro. I set the last line of the macro to Go To Record, Next. When run the form...