Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    england
    Posts
    95

    Unanswered: which way is best?

    Hi guys need some advice:

    I want the students 2 b able to book more than 1 piece of equip out at one time....is it:

    a) more easyier to program - to get them to make one booking in the sys

    b) easier for user (but appa harder to program) - to let the users make a selection??

    on a booking form????

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Have you thought about using a Shared Workbook?

    Then multiple users can access it at once.

    EDIT: Tools-->Share Workbook-->Editing-->Allow changes by more that one User.

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091

    Re: which way is best?

    Originally posted by lucyg_2000
    Hi guys need some advice:

    I want the students 2 b able to book more than 1 piece of equip out at one time....is it:

    a) more easyier to program - to get them to make one booking in the sys

    b) easier for user (but appa harder to program) - to let the users make a selection??

    on a booking form????
    If I understand what you want, you could use a UserForm (relatively easy to setup) to allow booking, but such an approach would require that the student fill in the form for each instrument. Thus, if a student wanted to book three instruments, he/she would click the userform three times.

    Another option might be to have Validation dropdown lists in columns (one column for total number of instruments allowed, i.e. if a student could never have more than four instruments at one time, then have four columns with Validation lists for each column. The Validation list would include all instruments.

    just some thoughts.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1

    Lightbulb

    RE: Which Way is Best

    Referance use of UserForm

    If you used a list control with multi-select option on, then all selection could be made in one hit. You woul have to check the number of selected items if there is a max No.

    If ypur new to Excel/vbforms then this will require a bit of effort!

    Just some thoughts

    MTB

Posting Permissions

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