insert blank row in datasheet view

R

Rocky

Hi, I am trying to insert a blank row between records in a table that is in
datasheet view. I am pretty sure I have done it before but cannot remember
the correct keyboard combination. Any help would be appreciated.
 
T

Tom Wickerath

Hi Rocky,

Please explain why you are trying to do this. It sounds like you are trying
to apply techniques that are valid for Excel to a relational database. Tables
are used to store data, but should not be used directly. Records should be
added / edited / deleted via forms, and printed via reports. You can easily
offset the appearance of records in a report, for example printing every
other record with a shaded background.

If my answer has helped you, please sign in to Microsoft's Online Community
and mark my post as "Answered".


Tom
http://www.access.qbuilt.com/html/expert_contributors.html
___________________________________________

:

Hi, I am trying to insert a blank row between records in a table that is in
datasheet view. I am pretty sure I have done it before but cannot remember
the correct keyboard combination. Any help would be appreciated.
 
T

Tom Wickerath

Madhivanan:

While your suggestion works, as long as none of the fields have the required
property set to yes, what logical reason in a relational database could there
possibly be for entering blank rows at the table level?

Sometimes, just because you *can* do something, doesn't mean that you
*should* do it.

Tom
______________________________________

:


Control Key + Enter

Madhivanan
 
R

Rocky

I am pulling the records up in an asp page. I just wanted to arrange the
records in a different order.
 
T

Tom Wickerath

Hi Rocky,

You should use a query, with the appropriate ORDER BY clause to specify
order.

Tom
_____________________________________

:

I am pulling the records up in an asp page. I just wanted to arrange the
records in a different order.
_____________________________________


Hi Rocky,

Please explain why you are trying to do this. It sounds like you are trying
to apply techniques that are valid for Excel to a relational database. Tables
are used to store data, but should not be used directly. Records should be
added / edited / deleted via forms, and printed via reports. You can easily
offset the appearance of records in a report, for example printing every
other record with a shaded background.

If my answer has helped you, please sign in to Microsoft's Online Community
and mark my post as "Answered".

Tom
http://www.access.qbuilt.com/html/expert_contributors.html
___________________________________________

:

Hi, I am trying to insert a blank row between records in a table that is in
datasheet view. I am pretty sure I have done it before but cannot remember
the correct keyboard combination. Any help would be appreciated.
 
R

Rocky

The data has no logical order to group or sort with, I want to order it in
a totally random way on the fly. This is to display items that I add to my
resume and I may want to change the order in which they are displayed, this
is not any sort of major database application. Just displaying classes that
I have completed in a quick manner.
 
Top