Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    22

    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!


    edit: we use Access 2003

  2. #2
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    Take a look on this link, it might help
    http://www.lebans.com/paintprogram.htm
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    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.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2008
    Posts
    29
    Quote Originally Posted by StarTrekker
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •