Half-witted dimwit seeks help

[tcarter]

Hi,

Having read the microsoft manual and not found or understood the answer I
humbly ask the following questions.....

I have a form for filling in fields in a table. How do I get the form to
send the information to two identical but differently named tables? (One
table deals with part-time workers and the other with full-time workers)

On the form is a comment box. Access limits the number of characters users
can enter to 255. Is there any way of increasing this or more preferably is
there any way of displaying on the form a countdown of the number of
characters left?

And finally.........

Could someone please point me in the direction of a really simple
explanation of how to query which employees have been reported on in the
previous 12 months. As I read it I started to understand it, really I did,
but by this stage my eyes had irretrievably glazed over and I was rocking in
my chair.

All contributions gratefullly received.

Many thanks

TC

 

[Douglas J. Steele]

Answers in-line.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi,

Having read the microsoft manual and not found or understood the answer I
humbly ask the following questions.....

I have a form for filling in fields in a table. How do I get the form to
send the information to two identical but differently named tables? (One
table deals with part-time workers and the other with full-time workers)

That probably isn't a good idea. Rather than having two separate tables, add
an extra field to a single table so that you can distinguish the part-time
workers from the full-time workers.

On the form is a comment box. Access limits the number of characters users
can enter to 255. Is there any way of increasing this or more preferably
is there any way of displaying on the form a countdown of the number of
characters left?

Likely you've made the bound field a Text field, which does have a limit of
255 characters. Change that to a Memo field.

If you do have a Memo field already, do you have an Input Mask, or any
formatting? Remove them if so.

And finally.........

Could someone please point me in the direction of a really simple
explanation of how to query which employees have been reported on in the
previous 12 months. As I read it I started to understand it, really I did,
but by this stage my eyes had irretrievably glazed over and I was rocking
in my chair.

Not sure what you mean by "been reported on in the previous 12 months".
Perhaps you can explain how you would do it manually.

 

[tcarter]

Thanks Doug,

For the last question I mean that no matter when, in the future, I need to
ask / query who (i.e. which units in a table's field) have had an entry made
about them.....then it can tell me. I have an idea as to how to find those
not reported on by using the unmatched query wizard but not the others.

Regards,

Tony Carter

 

[Douglas J. Steele]

Assuming you've got a date field in the table that's updated when changes
are made, your criteria on that field will look like

BETWEEN DateAdd("m", -12, Date()) AND Date()