Re: Out of Response Time Calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi John,

I have attempted to build the database as you describe but I must be doing
something fundamentally incorrect.

I have built the tables as you described, I have then built a form with the
TimeOpened and TimeClosed on, built the Combobox pointing to the Priority
table and then entered the two text boxes, one for the OOR and the other for
the TimeOpenedMet. I double click these text boxes and enter the expression
as you describe here. I have tried entering in both the "Control Source" and
"Before Update" but, I cannot get it to work. The fields remain blank.

Now I have built the tables and form, would it be acceptable to you that I
send you the database so you can ascertain where I am going wrong. This was
really the idea behind my request for someone to send me such a DB so I could
determine and learn on a DB that actually worked.

Thanks for you continued support.

Colin

"John Vinson" wrote:

> On Thu, 6 Oct 2005 04:24:02 -0700, "Colin DIxon"
> <ColinDIxon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Hi,
> >
> >Would one of you experts be so kind as to provide me with a table and form
> >that has just 5 controls on.
> >I would like;
> >
> >1. Time Opened (Short time and entered automatically)
> >2. Time Closed (Short time and to be entered manually)
> >3. Priority 1, 2, 3, 4, and 5 ( This would be a drop down list. 1 would be +
> >4 hrs from Time opened; 2 would be + 8hrs from Time opened etc.
> >4. Out of Response time (Short Time display of Time Opened + hrs dependant
> >on Priority 1,2,3,4 or 5
> >5. Out of Response met (A yes/no or true/false
> >
> >If you could design this in a table and Form, I can then more fully
> >understand how to enter into my database. I have previously tried some
> >suggestions provided in the form in the "before update" but, I am unable to
> >make it work.
> >
> >I am on broadband so file size is not a problem. My email address is
> >colin.dixon@xxxxxxxxxxxxx
>
> Well, I sympathize but I have to agree with Baz that you're being
> somewhat unreasonable. I (like Baz and everyone else who answers
> questions here) am donating my time free of charge and without
> remuneration; I'm a freelance database devloper, and I do indeed build
> forms and write code - for paying clients. So I'm sorry, but I am not
> in a position to do THAT much (actually creating a .mdb file for you)
> in this newsgroup.
>
> However... I'll be happy to make some suggestions that you can try
> implementing, and to respond to questions or problems you have in
> doing so.
>
> The starting point would be your Table. It should NOT contain any
> derived data such as [Out Of Response Time] or [Out Of Response Met]
> since they can be calculated on demand from the other three fields.
> The tables should resemble:
>
> ResponseTimes
> ResponseTimeID Autonumber Primary Key
> TimeOpened Date/Time; set its Default property to Now()
> TimeClosed Date/Time
> Priority Number, Integer
>
> Priorities
> Priority Primary Key, Number Integer
> HoursExpected Number Integer
>
> On your Form you would have textboxes for TimeOpened and TimeClosed,
> named txtTimeOpened and txtTimeClosed (you may want to set the Enabled
> property of txtTimeOpened to False, and its Locked property to True,
> so the automatic timestamp can't be editied), and a Combo Box named
> cboPriority, bound to Priority, based on the Priorities table. Use the
> Combo Box wizard to set this up.
>
> The Form (or any Report that you want to use to print out this
> information) would have two additional calculated textboxes: the Out
> Of Response Time textbox would have a control source
>
> =DateAdd("h", cboPriority.Column(1), txtTimeOpened)
>
> and for TimeOpenedMet, use a Control Source
>
> = (Me!txtTimeClosed <= Me!txtOutOfResponse)
>
> This expression will evaluate to TRUE if the TimeClosed value is less
> than the OutOfResponse textbox value, and to FALSE if it's later (or
> if either of the textboxes is still blank).
>
> John W. Vinson[MVP]
>
.

Relevant Pages

  • Re: How to import certain fields from access database?
    ... I added the code but its not displaying any values in the textboxes. ... The first imports data from a database ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to import certain fields from access database?
    ... I added the code but its not displaying any values in the textboxes. ... The first imports data from a database ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to import certain fields from access database?
    ... want column data to appear in textboxes. ... The first imports data from a database ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Command Button Wizard
    ... make sure the database is in a trusted location via: ... > built with the Wizard all work. ... > settings) and the command buttons built with the Wizard will not work - ...
    (microsoft.public.access.formscoding)
  • Re: How to import certain fields from access database?
    ... what will be the code for importing fields into from/word from access? ... Then if the use types the word into the combobox, ... from the database, e.g. have a textbox where user types in cust. ... i made a form using ms word 2003 vba with few textboxes, ...
    (microsoft.public.word.mailmerge.fields)