Results 1 to 2 of 2
  1. #1
    KWHAT is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    15

    How to create this type of form


    I want to create a form with a checkbox option where the user can select either a 12 or 24 time format, followed by an listbox option where they will then select a time interval either an 30 min or hour up to 12 (ex 30 min interval 9:00am - 9:30 am - 10:00am and so on), followed by inputbox option to enter a start time and end time, in return i want the results to display the whole complete time schedule from the options they chose, including a field from a table where the time field from the table match the time intervals chosen. How do I go about creating this?

  2. #2
    Mackie is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Location
    Wiltshire, UK
    Posts
    2
    I think I would do the following:

    First make a drop down menu with 12/24 items, and make a macro that enables the next item that initially is hidden (Visible False) to visible. Then make an interval option that does the same thing for the next inputbox etc...

    I may be wrong but enabling objects bit by bit seems a simple logical way of doing it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Login form type mismatch
    By rafal in forum Access
    Replies: 11
    Last Post: 12-24-2010, 01:49 PM
  2. Which type of Form layout is recommended?
    By yes sir in forum Access
    Replies: 3
    Last Post: 09-03-2010, 09:43 AM
  3. XP Logon type form
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 02:00 AM
  4. Replies: 2
    Last Post: 03-18-2010, 08:24 PM
  5. Replies: 0
    Last Post: 02-15-2009, 09:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums