Results 1 to 2 of 2
  1. #1
    srcacuser is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Location
    Northern Virginia
    Posts
    15

    Yet Another autofill question

    Hello, I'm a newbie that is trying to expand the usefulness of a 2007 DB all ready in place at work. It is a drafting firm. The drawing records with all the data are kept on one large form with everything visible. Drawings have a 3 step lifecycle from inception to delivery.

    What I would like to do is have a large, colored "status" box on a drawing form. This status box would display one of three things: "not started", "in drafting", or "released".

    We already achieve this, but by using three date fields: "date received", "date completed", and "date approved".
    Hard to look at those and determine status fast enough.

    So, ideally:

    "date received"="not started"
    "date completed"="in drafting"


    "date approved"="released"

    Can a user trigger the appropriate status when a date is entered (not null)?

    I'm trying to understand how once a qualifier is met, a new value like that can be added to the record.

    Again, I'm on an Access crash course..any pointers are greatly appreciated.

    thanks
    Sim

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    One can't design any database without reading a textbook, imo, and so you will benefit alot from getting one, easily found at Amazon or any large book store and reading thru it.

    Definitely one can a user trigger the appropriate status when a date is entered... this would the the 'AfterUpdate' event of a text box.

    However depending on how one interprets your post - the better approach will differ if it a single record form vs a continuous form.

    In continuous form then afterupdate approach is the way.

    If single record form then one might instead put 3 colored unbound labels each with the status name in the form header; and then toggle the visibility in the 'OnCurrent' event of the form with something like this:

    If me.[date received] >0 AND isnull(me.[date completed]) then
    me.notstartedlabel.visible = true
    End if

    hope this helps.

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

Similar Threads

  1. Autofill
    By kdcooper88 in forum Access
    Replies: 1
    Last Post: 09-18-2010, 05:52 AM
  2. ComboBox Autofill
    By t_dot in forum Forms
    Replies: 2
    Last Post: 08-19-2010, 06:18 AM
  3. Autofill Duplicate Information
    By JohnnyK15 in forum Forms
    Replies: 2
    Last Post: 06-15-2010, 10:53 AM
  4. date calculation then autofill?
    By nktrygg in forum Access
    Replies: 6
    Last Post: 01-19-2010, 11:04 AM
  5. Autofill with data from another form
    By jacrum in forum Forms
    Replies: 2
    Last Post: 08-11-2009, 11:17 AM

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