Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

how do I add a blank record row in to the middle of an exi..

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  Search returns nothing in Explorer  
Author Message
Angie

External


Since: Dec 31, 2008
Posts: 1



(Msg. 1) Posted: Thu Feb 04, 2010 9:35 am
Post subject: how do I add a blank record row in to the middle of an existing ta
Archived from groups: microsoft>public>access (more info?)

how do I add a blank record row in to the middle of an existing table

 >> Stay informed about: how do I add a blank record row in to the middle of an exi.. 
Back to top
Login to vote
KARL DEWEY

External


Since: Jan 22, 2009
Posts: 16



(Msg. 2) Posted: Thu Feb 04, 2010 9:58 am
Post subject: RE: how do I add a blank record row in to the middle of an existing ta
Archived from groups: per prev. post (more info?)

It won't work for you. Access stores records like a barrel of bricks.
You gets what you get unless you sort on a field or two.
If you add a field to number the records by 10 then you can add in the
middle by assigning the appropriate number to the record.

 >> Stay informed about: how do I add a blank record row in to the middle of an exi.. 
Back to top
Login to vote
Daryl S

External


Since: Oct 19, 2009
Posts: 13



(Msg. 3) Posted: Thu Feb 04, 2010 10:01 am
Post subject: RE: how do I add a blank record row in to the middle of an existing ta
Archived from groups: per prev. post (more info?)

Angie -

Tables are used to store data, so there would be no reason to add blank
records. Also, there is no "middle" of a table. Maybe you just want to
display something a certain way? Give us more information on what you are
trying to accomplish so we can help you solve your issue.
 >> Stay informed about: how do I add a blank record row in to the middle of an exi.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Blank Reports to not open - Hi I have 3 reports which open from a macro. I would like the reports to be displayed if there is information, however if the report is blank I don't want to open it. Is there a setting which stops blank reports from openning?

record locks - I need to check to see if a user has placed a editrecord lock on a record. Is thier a good way to test for a lock. If I know that thier is a lock set then I can do something. Right now I have the form set to no locks. Thanks OD

Change of Record - What event would describe moving from one record to another in a form? I've incorporated a tab control into my form and I'd like to deisgn it so that when a user is on any tab other than the 1st one, if the user moves to another record (e.g., using th...

Problem creating a form for blank records - I can't even find a suitable title for describing my problem. I have a bunch of Players. each player plays in a number of Games. So assuming I want a table of PlayerScores, the foreign keys of PlayerScores needs to be the primary keys of Players and..

Creating Multiple Record - I was curious to find out how to create multiple records for an employee. I want to be able to select an employee and schedule vacations and multiple days off from work. Here is what my tables look like: tblEmployee Employee ID (PK) NAME ..
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]