Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mainly a Rant (2002)

    <img src=/S/ranton.gif border=0 alt=ranton width=66 height=37> VBA Instructors who give Assignments where the information needed is NOT in the assigned reading material should be hanged, drawn and quartered then put on a spit over a low fire. <img src=/S/rantoff.gif border=0 alt=rantoff width=66 height=37>

    Just in case any of you needed to be reminded what it is like to be a student.

    Could someone tell me how to use the search engine to see if I can find the information I need? I wouldn't feel right just asking for Code.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Mainly a Rant (2002)

    To use Search, just click Search up above, and type into the Search For some words that describe what you are looking for!

    The default search method is andwhich means that it looks for posts containing all your words.

    Have you tried this ? What is the problem with searching?
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    Now that I've calmed down - just a bit, the problem isn't the search engine. It's me. I really don't know what to ask for.
    One thing you generous folks might be able to help with, without damaging anyones ethics, is a list of the integers that correspond to colors.
    I'm really not joking. In the five chapters I've read in the last two days, there is not one word that relates to the assigned exercise.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mainly a Rant (2002)

    You can go into the VBE window (Ctrl + F11) and bring up the object browser. Search for the item "acColorIndex", and you will find a list of system constants for colors. Clicking on any one of them will display the constant value for that item below the classes/Members panes.
    Attached Images Attached Images
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    Thank you Charlotte,
    This will at least get me started.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mainly a Rant (2002)

    They can't even spell - acColorIndexFuschia <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    The ColorIndex constants can be used in only a few places. HyperlinkColor and FollowedHyperlinkColor are the only ones I can think of. Mostly, Access uses RGB colors, and only 8 color constants are available for that: vbWhite, vbBlack, vbRed, vbGreen, vbBlue, vbYellow, vbCyan, and vbMagenta.

  7. #7
    New Lounger
    Join Date
    Nov 2003
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    I opened Help in Access 97, typed in "Color" in the Index selection box, explored the topics that came up, and got a number of references. Color is used a number of places with different meanings and values: QBColor for colors equivilent to old basic, RGB() for generating a custom color, a list of color constants, system color constants, etc.

    The simplest way to find information is to look in the simplest way.

    Instructors should actually fold "Using Help" into their classes extensively, routinely going through and showing students how to look up things in the help files. Every week. It's a prime key to success. I rarely have to ask anyone for help becuase help files usually contain everything I need.

  8. #8
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    I couldn't agree with you more. My biggest problem is I usually can't find what I need in Help, or on a Search Engine. I usually do find out later that it was there all along.

  9. #9
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    Thank you Hans, that little piece of info just saved me time and frustration.
    You are appreciated.

    Okay - one big question. Is it even POSSIBLE to change the color of the Form Footer based on the position of the mouse when the Mouse Down event occurs?
    If so - would you feel comfortable giving me a hint where to start looking?

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mainly a Rant (2002)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> I forgot another list: the system color constants; you can look them up by typing systemcolor in the search box in the Object Browser. These constants, such as vbButtonFace, vbWindowBackground etc., do not stand for fixed colors, but for the colors set by the user in the Appearance tab of the Display Properties control panel. If you set the color of an object to vbWindowBackground, it will have the color set by the user as background color for document windows. This may be white (the default) on one PC, and sofy yellow on another, and black on a third (if the user has an inverted color scheme)

  11. #11
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    They can't spell colour either <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mainly a Rant (2002)

    That's a sensitive issue - we can debate that endlessly, but "fuschia" is plainly and unmistakably wrong.

    Yes, I know that you're going to say that "color" is plainly and unmistakably wrong, but I won't go into that. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  13. #13
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Mainly a Rant (2002)

    Yes it is possible.

    Three things to look into:

    * Me.FormFooter.BackColor = can be used to set the background colour of the form footer.

    * The mouse down event looke like this: Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    where X and Y represent the position of mouse when the event occurs.

    * Look up the RGB function in Help.
    Regards
    John



  14. #14
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Mainly a Rant (2002)

    <img src=/S/artist.gif border=0 alt=artist width=34 height=29>
    "Colour" is correct, and I can prove it!
    (Hmm, wait a minute; I think Hans helped me create that table)
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mainly a Rant (2002)

    That table was originally created by <!profile=SteveH>SteveH<!/profile>, from Harrow, nr. London, UK. So there...

    <img src=/S/jollyroger.gif border=0 alt=jollyroger width=29 height=18>

Page 1 of 2 12 LastLast

Posting Permissions

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