Welcome to SPN

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

Sign Up Now!

How can I hide previously entered data

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

  1. jlan

    jlan
    Expand Collapse
    Guest

    Hello all! I've been lurking for some time but now I have a question I
    woudl like to ask myself. I have a form and subform which is designed
    to enter time sheet data. The main form is for the eployee info and the
    subform is the timesheet data which is in the spreadsheet format. I
    would like to be able to hide or somehow not display past data in the
    form. IE when I enter this weeks timesheet data I don't want to scroll
    down the spreadsheet past all the previously entered data to enter this
    weeks. Also, I don't want anyone else entering to see previous data and
    possibly modify it. How can I hide it?
     
  2. Loading...

    Similar Threads Forum Date
    World War 1 To show their contempt for death, some Sikhs had refused to hide in the trenches History of Sikhism May 14, 2014
    Opinion Underneath The Turban: Why Sikhs Do Not Hide Breaking News Aug 23, 2012
    Opinion Underneath the Turban: Why Sikhs Do Not Hide? Breaking News Aug 13, 2012
    UK Hideously diverse Britain: What makes a Sikh join the far right? (Editorial) Breaking News Jun 17, 2010
    Politics Stephen Harper's Canada Chided For Cowardice (Sikh Chic) Breaking News Jun 6, 2010

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    jlan wrote:
    > Hello all! I've been lurking for some time but now I have a question I
    > woudl like to ask myself. I have a form and subform which is designed
    > to enter time sheet data. The main form is for the eployee info and
    > the subform is the timesheet data which is in the spreadsheet format.
    > I would like to be able to hide or somehow not display past data in
    > the form. IE when I enter this weeks timesheet data I don't want to
    > scroll down the spreadsheet past all the previously entered data to
    > enter this weeks. Also, I don't want anyone else entering to see
    > previous data and possibly modify it. How can I hide it?


    If you set the DataEntry property of the form used in the subform control to
    Yes then it will not display existing records and will only allow entry of
    new records.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. jlan

    jlan
    Expand Collapse
    Guest

    Rick Brandt wrote:
    > jlan wrote:
    > > Hello all! I've been lurking for some time but now I have a question I
    > > woudl like to ask myself. I have a form and subform which is designed
    > > to enter time sheet data. The main form is for the eployee info and
    > > the subform is the timesheet data which is in the spreadsheet format.
    > > I would like to be able to hide or somehow not display past data in
    > > the form. IE when I enter this weeks timesheet data I don't want to
    > > scroll down the spreadsheet past all the previously entered data to
    > > enter this weeks. Also, I don't want anyone else entering to see
    > > previous data and possibly modify it. How can I hide it?

    >
    > If you set the DataEntry property of the form used in the subform control to
    > Yes then it will not display existing records and will only allow entry of
    > new records.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  5. jlan

    jlan
    Expand Collapse
    Guest

    Perfect, Thanks!!
     
  6. Ron2006

    Ron2006
    Expand Collapse
    Guest

    However, if you are going to want to see (and modify)THIS weeks data
    but NOT last weeks, then add a date range as criteria on the query you
    are using to show this weeks data. That way they can see and modify
    this week's info but not last week's.

    Ron
     

Share This Page