Data Entry on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My table looks like this:

Timepoint Date On OFF

I have 15 Time Points, how can i show this on 1 page in a form for data
entry. Please be Basic my brain is fried.
 
At the simplest, use a datasheet view in your form.

There may be more elegant solutions to your issues but you haven't
given us much to go on.

HTH
 
My table looks like this:

Timepoint Date On OFF

I have 15 Time Points, how can i show this on 1 page in a form for data
entry. Please be Basic my brain is fried.
Click to expand...

Use a Continuous Form, or a Datasheet Form. Open the form in design
view and change its Default View property from "Single Form".

Note that Date is a reserved word and a BAD choice of fieldname; and
that if you have separate fields named On and Off, you may need to
reconsider your normalization. As shown, there's nothing to prevent a
record from having On and Off conflicting! What's the datatype of this
field? If it's a date/time field, you might consider using the fact
that Date/Time fields store both the date and the time, and using
TimeOn and TimeOff; this would make calculations simpler and prevent
any problems with time points spanning midnight.


John W. Vinson[MVP]
 
Back
Top