Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98


Discussion in 'Information Technology' started by row insertion, Jul 28, 2006.

  1. row insertion

    row insertion
    Expand Collapse

    please help it's very urgent
  2. Loading...

    Similar Threads Forum Date
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    update Blogs Oct 16, 2015
    Update Wikipedia enteries on Sikh Socio-Political Topics Breaking News Jul 19, 2015
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014

  3. Craig Alexander Morrison

    Craig Alexander Morrison
    Expand Collapse

    If you mean insert in the same way as Excel...then you cannot.

    What you will need to do is select field or fields and sort the table
    (actually you are better doing this in a query unless the sort field(s) are
    the Primary Key).

    In other words if you want to Insert




    make that field the field that you sort on.


    Craig Alexander Morrison
    Crawbridge Data (Scotland) Limited
    "row insertion" <row insertion@discussions.microsoft.com> wrote in message
    > please help it's very urgent
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse

    row insertion wrote:
    > please help it's very urgent

    You add a new record. Since Access Database is a development tool and
    not a ready to use tool, each completed database can be very different. You
    can add new records in a query or a form, or even a table, but it is not
    recommended. You may not may not even see a table or query depending on how
    the developer crafted the database. You may or may not be allowed to add a
    new record depending on how the database was designed.

    I suggest you contact the persons responsible for creating or
    maintaining the database for instructions. Often access is limited

    Joseph Meehan

    Dia duit
  5. Alex Dybenko

    Alex Dybenko
    Expand Collapse

  6. John Vinson

    John Vinson
    Expand Collapse

    On Tue, 25 Jul 2006 04:30:02 -0700, row insertion <row
    insertion@discussions.microsoft.com> wrote:

    >please help it's very urgent

    I see you're getting some answers, but your question isn't very clear.

    What is the structure of your table?
    What are you trying to accomplish? I'm GUESSING - as some other
    respondents have - that you're thinking of a table as if it were a
    spreadsheet (it's NOT), and that you're trying to insert a record at a
    particular row in the middle of a table.

    Tables don't work that way. A Table is best viewed as an unordered
    "heap" of records. If you want to see records in a particular order
    you must - no option!!! - use a Query sorting the records into that
    order. You can add a new record to the end of the table, and (if
    necessary) requery the Form on which you're displaying the data (using
    a Query on the table), and it will re-sort the records moving the new
    record to its appropriate location.

    If I'm misunderstanding your subject line - please post some useful
    details (rather than just a plea) in the text area.

    John W. Vinson[MVP]
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page