Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2007

Tip: Looking for answers? Try searching our database.

Reminders and inserting pictures

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cpocpo@comcast.net - 14 May 2007 19:19 GMT
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 - 14 May 2007 21:12 GMT
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
resource@pcdatasheet.com

> Hello all!
>
[quoted text clipped - 26 lines]
>
> LostGuy
cpocpo@comcast.net - 15 May 2007 16:10 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.