Establishing continuously updating fields

  • Thread starter Thread starter jb2photo
  • Start date Start date
J

jb2photo

I'm new to Access have been unsuccesful in creating a database that allows
for a continously update for contact time for a particular client.

In short, we are trying to track the contact time per student in a subform.
We are using Student ID's to track and link the data in the subforms to the
main database. In addition I have established five check boxes and a notes
field (see below).

What I need to do is have the individual check boxes send the information in
the notes section to it's relevant area of the database.

Here are the types of fields I have set up:

Date Contact Hrs ARD HV D M E Notes
ActiveX Unbound -----Check Boxes----------- Unbound box
Control


There are 11 rows, but if I could figure out the coding for the first line I
think I can adapt it for the subsequent lines. I've tried different
suggestions for coding, but none have worked. In addition I have a calculate
button at the bottom of the form total the contact hours. A submit button is
also on the form, but it would send the contact hrs for each line to the main
database.

If I could get the first part of the form i.e. getting the check boxes to
route the notes section to their area. That'd be great! I'm reading up on
understanding the relationships of subforms to mainforms at this moment.
 
Hi

What do ARD, HV, D, M, and E represent?

Why would there be 11 rows?

Why is Contact Hrs an unbound field?

As far as sending the note to its relevant section of the
database (ie: different tables), why not use one Notes table?

'~~~~~~~~~~~~~~~~~~~

*Notes*

NoteID, autonumber

StudID, long integer

TblID, long integer
(number representing table the note is attached to)

FldID, long integer
(number representing the value of the autonumber primary key
field for the record that the note is attached to)

nDateTime, date, DefaultValue --> =Now()

Subject, text

Note, memo or text

DateCreated, date, DefaultValue --> =Now()
(Locked)

DateModified, date
(Locked)
(use BeforeUpdate event to modify)

'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
To answer your questions:

ARD is a special meeting that needs to be tracked.
HV is marked each time a rep visits the clients home.
D is marked to indicate a direct action for a client but not necessarily
visiting their home.
M is a regular meeting, i.e. with the clients school.
E is an emergency meeting held for a specific need that is not an ARD or M.

The 11 rows would be available for a rep to enter in 2 weeks of data at a
single time.

I hope that helps.

Jim

Hi

What do ARD, HV, D, M, and E represent?

Why would there be 11 rows?

Why is Contact Hrs an unbound field?

As far as sending the note to its relevant section of the
database (ie: different tables), why not use one Notes table?

'~~~~~~~~~~~~~~~~~~~

*Notes*

NoteID, autonumber

StudID, long integer

TblID, long integer
(number representing table the note is attached to)

FldID, long integer
(number representing the value of the autonumber primary key
field for the record that the note is attached to)

nDateTime, date, DefaultValue --> =Now()

Subject, text

Note, memo or text

DateCreated, date, DefaultValue --> =Now()
(Locked)

DateModified, date
(Locked)
(use BeforeUpdate event to modify)

'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
I'm new to Access have been unsuccesful in creating a database that allows
for a continously update for contact time for a particular client.
Click to expand...
[quoted text clipped - 23 lines]
route the notes section to their area. That'd be great! I'm reading up on
understanding the relationships of subforms to mainforms at this moment.
Click to expand...
Click to expand...
 
Hi Jim,

can you specify the tablenames and the fieldnames that the
data is supposed to go to depending on the what is specified?

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)

To answer your questions:

ARD is a special meeting that needs to be tracked.
HV is marked each time a rep visits the clients home.
D is marked to indicate a direct action for a client but not necessarily
visiting their home.
M is a regular meeting, i.e. with the clients school.
E is an emergency meeting held for a specific need that is not an ARD or M.

The 11 rows would be available for a rep to enter in 2 weeks of data at a
single time.

I hope that helps.

Jim

Hi

What do ARD, HV, D, M, and E represent?

Why would there be 11 rows?

Why is Contact Hrs an unbound field?

As far as sending the note to its relevant section of the
database (ie: different tables), why not use one Notes table?

'~~~~~~~~~~~~~~~~~~~

*Notes*

NoteID, autonumber

StudID, long integer

TblID, long integer
(number representing table the note is attached to)

FldID, long integer
(number representing the value of the autonumber primary key
field for the record that the note is attached to)

nDateTime, date, DefaultValue --> =Now()

Subject, text

Note, memo or text

DateCreated, date, DefaultValue --> =Now()
(Locked)

DateModified, date
(Locked)
(use BeforeUpdate event to modify)

'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)

I'm new to Access have been unsuccesful in creating a database that allows
for a continously update for contact time for a particular client.
Click to expand...

[quoted text clipped - 23 lines]
route the notes section to their area. That'd be great! I'm reading up on
understanding the relationships of subforms to mainforms at this moment.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top