Report

  • Thread starter Thread starter microsystems
  • Start date Start date
M

microsystems

I would like to create a report that captures all the fields from my MS
ACCESS database that are not entered. If
additional information is required then let me know, and
thanks in advance.

Liviu
 
Would you mind entering a few records in a reply and how exactly you would
expect them to appear on a report? Keep in mind the difference between a
database (mdb file) and a table.
 
I want to capture the fields left empty from every form, so i will have
the user name that entered and stating what fields are left empty.

Liviu
 
Forms don't really have fields. Forms have controls and tables have fields.

There is no way that Access identifies who (user name) entered or didn't
enter information.

Code could be written that would loop through all tables and fields and
"capture" nulls in fields in tables.
 
Any thoughts on the code that would loop through all tables and fields
and
"capture" nulls in fields in tables.Thanks.
 
I suppose you could use DAO code to loop through all non-system tables and
the fields in each table to create a SQL statement. The sql would select
from the table where field1 is null or field2 is null or field3 is null,....

Take the results from each sql statement and pass them print them out.

Do you really have a legitimate reason for doing this? I have rarely seen an
MDB file where it is expected that every field of every table of every
record contains data.
 
Back
Top