Recent content by Peter Whitfield

Cheers guys, you're both stars!!

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

How about, In your main table, have an additional field that defaults to "Seen It". Then insert a subform in the 2nd form which links on the Person and Title and displays only the new "Seen It" field. If they have had it before it will show, if not its blank!!

Cheers mate, your a genius!

Apologies if this sounds patronising, but you have told it to print ALL pages and not just the first? In Print Preview you have to click the next page on the Navigation buttons to see a second page. Try running the report from a macro with Print selected rather than Preview. Again, apologies...

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

If its really important you do this then assuming the max number of rows is always the same e.g. 20 rows over 3 columns (giving a maximum # of entries of 60.) Take the number of records to be displayed and divide by the number of columns, append this number of records to the new table and x...

Is it not a case of creating a select query to pull the relevant records based on company number. Then a second query with query1 as its data source which appends the relevant table with everything but the company number, the company number would be appended as the second pop up question...

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

Not at all familiar with Visual Basic yet but isnt there an IF Exist statement which would then run the delete macro?

Jack, In one table there are approximately 70 different validations being carried out, Im fairly new to this but it seems to me that I would have to carry out a large number of queries to perform the validation in this code. Am I correct in that assumption or just missing an easy way via Queries?

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