My users don't like to type

C

Clddleopard

I have a "daily records" database. One of the things that is recorded is who
works each day. Currently, the way that is recorded is just to type the names
into a memo field. However, I do have a table with everyone's names in it. Is
there a way to create a multi-select list box or a checklist that will paste
names selected from this table (either by highlighting or checking a box next
to the name) into a memo field? The memo field that I want to store the info
in is in a table called AnimalRecords and the field is called AnNote. The
table with the names is called KeeperInfo and it has FirstName and LastName
fields. Just the FirstName field needs to go into the memo, but if it could
be both First and last, that would be great. I am a complete newbie when it
comes to VBA, but I'm willing to try!
 
T

tina

recommend you *don't* store the names in a memo field. that is a violation
of normalization rules, and also makes the data practically unusable. what
if you want to know who worked on a certain day? or how many days each
person worked with a particular animal or animals? a nightmare to get this
data out of a memo field.

you've given us almost no information about your tables setup, other than
the KeeperInfo table, so i can only tell you in very general terms that
you'll want to use the primary key of the KeeperInfo table as a foreign key
in another table to record each keeper - for each day, i'm guessing; with
one record per keeper.

for more specific table structure suggestions, we'll need more specific
information about your tables, and about *what* you are tracking.

hth
 
C

Clddleopard

The information regarding who worked which day is probably the least
important aspect of the whole system, thus, it's not normalized (or hasn't
been until now). The keeper initials go with each record they write, which is
how we keep track of who does what with whom, and is why I even have a Keeper
ID info table. After the report for the day gets e-mailed, it almost doesn't
matter who worked each day. But, if I set up a table to record who worked
each day, how can I set up a check list or something where a simple mouse
click indicates who worked?
BTW, the Keeper ID Info table does also have a numeric KeeperID in addition
to FirstName, LastName, and Initials.
 
T

tina

you can "pre-load" a form with a record for each keeper, and a checkbox
field, so the user can go thru and checkmark the keepers who worked on a
given day. the form (or subform, as appropriate) would be bound to the table
that stores those records. then you could run code when the form closes to
delete the records that were not checkmarked.

hth
 
T

Tom Ventouris

Not clear on what you are doing, but here's how to get names from a list into
the memo field:

Create a list box with the names of the people who might work. You can get
these from a table if there available or type them into the Value List.

Place this code in the Click event of the List:

Private Sub ListName_Click()
Me![MemoName] = Me![MemoName] & " " & Me![ListName]
End Sub

This uses space as a name seperator. Use anythin you like here, or
additional space.
 
C

Clddleopard

This is exactly what I was looking for. I know it's not great database
design, but work with what you've got! Thanks!

Tom Ventouris said:
Not clear on what you are doing, but here's how to get names from a list into
the memo field:

Create a list box with the names of the people who might work. You can get
these from a table if there available or type them into the Value List.

Place this code in the Click event of the List:

Private Sub ListName_Click()
Me![MemoName] = Me![MemoName] & " " & Me![ListName]
End Sub

This uses space as a name seperator. Use anythin you like here, or
additional space.

Clddleopard said:
The information regarding who worked which day is probably the least
important aspect of the whole system, thus, it's not normalized (or hasn't
been until now). The keeper initials go with each record they write, which is
how we keep track of who does what with whom, and is why I even have a Keeper
ID info table. After the report for the day gets e-mailed, it almost doesn't
matter who worked each day. But, if I set up a table to record who worked
each day, how can I set up a check list or something where a simple mouse
click indicates who worked?
BTW, the Keeper ID Info table does also have a numeric KeeperID in addition
to FirstName, LastName, and Initials.
Click to expand...
Click to expand...
 
Top