Reminders and inserting pictures

[cpocpo]

Hello all!

1) On frmEmployeeData, I have a Bound Object Frame named "Photograph".
I also have a tblEmployees with a field named "Photograph". What I
would like is to be enter to put a person's picture on the form and
then it updates the table for that person. The data entry person would
copy a picture from their desktop or wherever and then paste it into
the field on the form. When I try this, it freezes up. If I double-
click on the field, I get the "OLE Object is empty" error. is there
something simple I am missing? BTW, there are only 20 employees so I
want to store the pictures with the dbase instead of linking to
external files.

I was looking for what Mark did for his comics: http://home.att.net/~rarecomics/software.htm
(inserting the cover of the comic in each record.)

2) Also, I have a list of 40 requirements and their associated due
dates for those 20 employees. How can I do a popup form after the
splash screen but before my dashboard that makes a list like "The
following employees have the following recurring items due within 15
days:" and "The following employees have overdue items". This captures
stuff like birthdays, annual physicals, vaccinations, annual training,
etc., as well as overdue stuff.

Appreciate the help!

V/R

LostGuy

 

[Steve]

The Northwind sample database has employee pictures in a form. Look at that
to see how it is done.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[cpocpo]

Steve,

Thanks! I forgot about the Northwind database example. The only bug I
had with it was the "msoFileDialogFilePicker" which was looking for
the Microsoft Office 11.0 Object Library. (I only had the Microsoft
Access version loaded.). Once I loaded the right one, it worked fine.

Any help on the recurring item popup reminder/report?


V/R

LostGuy