Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Access

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-02-2008, 02:05 AM
=?Utf-8?B?VlRNMw==?=
 
Posts: n/a
adding new record

I imported about 30 records to a blank database from Excel. I continued
adding more records to the available blank rows of which there were about 15.
I have more records to enter, but no more blank rows. How do I create more
blank records to continue entering data? The last row says NEW in the first
column (PK column), but I am unable to figure out how to get more blank rows.

Thank you!
Reply With Quote
  #2 (permalink)  
Old 07-02-2008, 03:05 AM
pietlinden@hotmail.com
 
Posts: n/a
Re: adding new record

On Jul 1, 8:05*pm, VTM3 <V...@discussions.microsoft.com> wrote:
> I imported about 30 records to a blank database from Excel. *I continued
> adding more records to the available blank rows of which there were about 15.
> *I have more records to enter, but no more blank rows. *How do I create more
> blank records to continue entering data? *The last row says NEW in the first
> column (PK column), but I am unable to figure out how to get more blank rows.
>
> Thank you!


that cute little button with the asterisk on it.
Reply With Quote
  #3 (permalink)  
Old 07-02-2008, 04:10 AM
John W. Vinson
 
Posts: n/a
Re: adding new record

On Tue, 1 Jul 2008 18:05:00 -0700, VTM3 <VTM3@discussions.microsoft.com>
wrote:

>I imported about 30 records to a blank database from Excel. I continued
>adding more records to the available blank rows of which there were about 15.
> I have more records to enter, but no more blank rows. How do I create more
>blank records to continue entering data? The last row says NEW in the first
>column (PK column), but I am unable to figure out how to get more blank rows.
>
>Thank you!


Type data into the row that says New. Move off it (tab out of the last field
or click into some previous row)... hey presto, you'll get a NEW New row. You
don't have to "do" anything.

What you were doing was not creating new rows, but instead editing existing
rows which happened to contain NULL values in all their fields. These were
clearly created when you imported the spreadsheet (you probably imported 30
data records and 15 blank records).

--

John W. Vinson [MVP]
Reply With Quote
  #4 (permalink)  
Old 07-09-2008, 09:39 AM
Aaron
 
Posts: n/a
Re: adding new record



"VTM3" <VTM3@discussions.microsoft.com> 在郵件張貼內容主旨
016B8473-76E4-4F9E-A7AF-72802EB7CCC2@microsoft.com ä¸*撰寫...
> I imported about 30 records to a blank database from Excel. I continued
> adding more records to the available blank rows of which there were about
> 15.
> I have more records to enter, but no more blank rows. How do I create
> more
> blank records to continue entering data? The last row says NEW in the
> first
> column (PK column), but I am unable to figure out how to get more blank
> rows.
>
> Thank you!




hello nice to meet u
im working test sorry to bother u

Reply With Quote
  #5 (permalink)  
Old 07-10-2008, 12:40 AM
Larry Linson
 
Posts: n/a
Re: adding new record

You'll find a .test newsgroup, specifically for "working test". Please use
it, because extraneous posts in the actual public newsgroups do interfere
with their usefulness. Thank you for your future consideration.

Larry Linson
Microsoft Office Access MVP

> hello nice to meet u
> im working test sorry to bother u



Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Access


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 07:14 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Xbox Mod Chip | Loans | Property for sale in Spain | Vienna Austria Hotels | Lampy



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114