Adding to tables

[Matt Dawson]

To add data to my database, i copy and paste data from an excel spreadsheet
into a table that i receive every week. When i paste it in to the database it
does not have all the records so the check boxes are left blank

When i add new data i automatically need the new records to be set to a
specified check box. Is there anyway of highlighting them all at once and
selecting them all as checked for the relevant box, or is there a formula i
can write?

Many Thanks,
Matt

 

[Jerry Whittle]

Matt,

You've confused me (not that it takes much). Do you receive the Excel
spreadsheet or the Access table weekly? I'm assuming Excel but it sounds
otherwise.

It does not have all the records or all the fields in the new records?

Anyway the easiest way is to set the default value of the check boxes to -1
which is Yes. When you add new records the check boxes will then be checked
automatically.

 

[Matt Dawson]

Yes I receive the weekly Excel file and it does not contain all the fields as
I have added some myself from within the database.

I will set them all as a default value and will this still work if pasting
in hundreds of records?

 

[Jerry Whittle]

If it works as you wish for 1, it will also work for 1 thousand or more.