Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A grid alternative in Access (Access 2002)

    Hans has kindly informed me that Access doesnt have a native Grid control. I'm looking for an alternative where i dont need to use additional dlls.

    I have a question dropdown and an answer dropdown (populated after the question has been selected). I was hoping the user could add and remove questions and answers from a list as they please. That list would then be used as search criteria. Other than a grid I can't think of a way to store the list.

    If the user didn't need to see it, i'd use a collection. As the user needs to see it the only thing I can think of is to dynamically add labels to a form to display the list. Removing individual items from the list would be too complex for my budget constraints so the user would have to close and re-open the form (thus start again) if they wanted to remove one.

    If anyone can think of an alternative it would be much appreciated.

    The general look (after the user had added some questions/answers) would be (i've seperated the words with dashes as spaces didnt show):

    QUESTION DROPDOWN----------------ANSWER DROPDOWN-------------ADD BUTTON
    Launch Invitee-------------------------------Y
    Items Received------------------------------8
    Telephone Preference Scheme--------N

    etc

    Regards,

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

    Re: A grid alternative in Access (Access 2002)

    You could use a continuous form (or subform) bound to a (temporary) table.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A grid alternative in Access (Access 2002)

    Is it possible to create a table in memory in Access (like you can in SQL)? I did think about creating a temporary table but the database may be used by more than one person at once. In theory they should all be using a seperate front end, but with no dba at their site, and no prior use of access, its possible they wont necessarily follow the rules of Access use!

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

    Re: A grid alternative in Access (Access 2002)

    You could probably construct a recordset in memory, but I don't think a form bound to it would be updateable. But others know more about that.

    *You* design the database, so *you* should split it into a frontend and backend.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A grid alternative in Access (Access 2002)

    I see your point but that isn't quite what I meant.
    I assume the temporary table would be in the front end? What is there to stop 2 users opening the same front end at the same time? I usually set such things up so everyone has their own version somewhere, but people have a habit of not doing what they're told and open things from whereever they happen to be on the network.

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

    Re: A grid alternative in Access (Access 2002)

    You could include the username (network login name or if you have set up user-level security, Access login name) in the name of the temp table, or generate a random name. That would minimize the probability of a conflict.

    Or use a fixed name, and put up a warning if the table already exists.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A grid alternative in Access (Access 2002)

    Ah, I like the 2nd idea! The chances of 2 people searching at one time is minimal anyway so I think that would be the most sensible solution for this case. Usually i'd be up for making it with all the bells and whistles, but this is a freeby on the back of an already cheap database so bells and whistles aren't available.

    As much as I enjoy programming etc, I dont enjoy assigning work to a budget!

    Thanks for your help Hans.

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A grid alternative in Access (Access 2002)

    I have used akGrid before, in lots of situations. It doesn't sound like what you're after, but I thought I'd give it a plug anyway, since it's <img src=/S/free.gif border=0 alt=free width=30 height=15>. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    "akGrid is a lightweight display only grid control created entirely in VB6 using standard controls. This OCX is about 60kb in size.
    This is an unbound grid control. Data is added using the AddItem and RemoveItem methods or by setting the Rows property and then entering data into the TextMatrix.
    With about 25 properties, methods and events this control does all the basics, without all the overhead of the features which you probably wont use anyway."


    Alan

  9. #9
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A grid alternative in Access (Access 2002)

    Thanks for the tip, its always good to hear a recommendation for a great control - especially when its free!

Posting Permissions

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