Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grey Bar on Form (XP)

    I have three forms which display the same feature, namely, a vertical bar on the left-side (See attachment).
    Questions:
    1# What is it?
    2# How can I remove it?

    I've looked at all of the form properties but nothing stands out.

    Thanks
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Grey Bar on Form (XP)

    It's called a record selector, you can turn it off, it's in the properties of the form. When you click on this bar it gives you the ability to delete the current record.

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grey Bar on Form (XP)

    Thanks Pat. Long time no speak. I hope you are well.
    Is there a way of turning off the "you are about to delete n records" prompt?
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Grey Bar on Form (XP)

    Hi Rob, yeah I'm feeling great, how about you?

    If you are deleting records in VBA code there is the DoCmd.SetWarnings command, but if you are deleting records manually, I don't know of a way to turn it off.

  5. #5
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grey Bar on Form (XP)

    Feeling good, too!

    I'm deleting the record through this code:

    Private Sub DeletePlace_Click()
    On Error GoTo Err_DeletePlace_Click


    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

    Exit_DeletePlace_Click:
    Exit Sub

    Err_DeletePlace_Click:
    MsgBox Err.Description
    Resume Exit_DeletePlace_Click

    Would you supply the" DoCmd.SetWarnings command" to do this?

    Thanks
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Grey Bar on Form (XP)

    The DoCmd.SetWarnings would be used for the DoCmd.RunSql and the like commands, I'm not too sure if it would work in your situation.
    But why not try it. I is used like:

    DoCmd.SetWarnings False
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
    DoCmd.SetWarnings True

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grey Bar on Form (XP)

    Hi Rob,

    DoCmd.DoMenuItem is a function remaining from the previous versions.
    You should use :

    DoCmd.SetWarnings False
    DoCmd.RunCommand acCmdDeleteRecord
    DoCmd.SetWarnings True

    This is more readable.
    Francois

  8. #8
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grey Bar on Form (XP)

    Thanks for your help, Francois.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •