Want to get status of fields where fields are empty

[rehanemis]

Hi Professionals,

I am working on MS Access program where i import data from Excel and i would like to generate a report in MS Access where the fields are empty. Like the MS Access generate a table of errors when we import data and shows information like field name and row number along with Type Conversion label.

Can i generate similar table from an MS Access table where fields are null.

Waiting of your response.

Best,

rehan

 

[vbaInet]

If you want a specific kind of report that does that, then you would have to build your own and write code to highlight specific things, otherwise, the simplest way is to build a query that displays those fields that are Null or "".

You will of course need to import into a temporary/staging table and run your query off this table, then run an append query from this temp table to your main table eventually.

 

[rehanemis]

Thanks,

Can I develop a form in MS Access with drop down menu with field names so that we can choose particular field and see the empty fields. If yes, Can you tell how can i do.

Thanks.

 

[vbaInet]

I can't give a tutorial on how to do the whole lot but I can answer specific questions or challenges that you face. Start off by creating the query, then create a form based on the query and include a combobox that lists the field names.