insert a blank row

[Souris]

It is possible to run a query to inser a blan row in my table?
If yes, can you please let me know how can I riight SQL?
Your help is great appreciated,

 

[John Spencer]

As far as I know, a table should not have a completely blank row, since
good design principles say every record should have a primary key.

Why do you need a blank row in your table? Can you explain the purpose
of doing so?

You could always use a query that looks like the following, to insert a
blank row as long as you didn't have any required fields in the table.

Insert INTO YourTAble(someField)
Values(Null)



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Jerry Whittle]

Probably not.

Does the table have a primary key? If so, you can't have a blank record as
the PK field would need something unique in it.

Do any of the fields have a default value? You would have to make sure to
stop them from populating.

Any Yes/No fields? They would need one or the other.

Any fields with the Required property set to Yes? That would be a problem.

Is the table joined to other tables with Referiential Integrity enabled?
That might be a problem also.

Then there is the big question: Why do you need a blank record in a table?

 

[Souris]

Thanks for the message,
I just prepare a local temp table to populate the report for excel
spreadsheet.
The reason for insert a blank record is to match the format of spreadsheet.

I use following

insert in to mytable (myfield) values (" ") to match the format of
spreadsheet.
If I do not do this then I need to do somthing from excel side.


Thanks again,