Unanswered: Need to start new form entry with default image but be able to modify for each entry
I work at a cancer research lab. The current method of recording autopsy data on our lab mice is all on paper, and my job is to replace this system with a database that can be used on a tablet PC while the autopsy is taking place.
Everything is elementary data fields except for (I'd assume) a rather unique problem - we need to be able to draw on a mouse diagram to mark the location of tumors. This means each new data entry in the form needs to load a default image of a mouse. Then, as the necropsy is taking place, we need to be able to double click and draw on the image which OLE is actually pretty nice for.
I have some concerns...is it possible to write a macro that will automatically insert the default mouse diagram for a new form entry? Using setValue didn't seem to work with object-based data fields. I am also concerned of the size and speed of the database once ~2,000 mouse autopsies are stored. I would gladly use DBPix instead of OLE, but OLE is much simpler in cracking the image open with paint to scribble on the diagram where the tumors are.
Any suggestions? Should I even use Access for this? Your input will help cure cancer!
I personally wouldn't be storing the images inside the Access database, I'd be keeping them in a folder somewhere and referring to each image from the database.
This would mean that you could use ANY graphic manipulation package to edit it... just an alternative.
I second that.
Store them outside and use relative path mapping to get them from your interface. Do not store the full path as if you happen to move the database you probably won't have the same tree structure.
Besides, this will help keeping your database in a reasonable size (as Access really doesn't like large datasets) while giving you great flexibility not only the programs you can use to edit your pics, but also in terms of definition and storage of the pics.