A
alpapak via AccessMonster.com
Show Image and form
------------------------------------------------------------------------------
--
hi
i am a dentist and i want to make a form which will show me the smile of the
patient before treatment and after.
My images will be save and a folder where my db wil be , with the same name.
My table is:
1) solution 1
tblPhoto
PhotoID
CustomerID
DateBefore
NamePhotoBefore
PathNamePhotoBefore
PhotoBeforeSize
DateAfter
NamePhotoAfter
PathNamePhotoAfter
PhotoAfterSize
Details
2) solution 2
Same time i have only image before or after treatment so i am thing to make 3
tables
tblPhoto
PhotoID
CustomerID
PhotoBeforeID
PhotoAfterID
Details
tblPhotoBefore
PhotoBeforeID
DateBefore
NamePhotoBefore
PathPhotoBefore
PhotoBeforeSize
tblPhotoAfter
PhotoAfterID
DateAfter
NamePhotoAfter
PathPhotoAfter
PhotoAfterSize
which one to use???
---------------------
Look my .Mdb
at the top of the window the DateBefore , DateAfter , NamePhotoBefore ,
NamePhotoAfter , Details
at the rest of the window the 2 images (right-left)
if i have only one image to show me just one big frame.
1)How can i make this work?
2)i want to add image when i doubleclick at the NamePhotoBefore or
NamePhotoAfter.
To open a Form , find my image , click open and copy the image to my Folder ,
rename it using at this format " [CustomerId]_[Surname]_[Name]_dd/mm/yyyy_hh:
mm:ss" , save it at my tbl(fill the field NamePhoto , PathPhoto , PhotoSize)
and last a msg to confirm everything vbOK "Image "..." complete."
my images are .jpeg , .bmp.
sample file save:
34 Smith John 03022006 153223.jpeg
CustomerID = 32
Surname = Smith
Name = John
Today = 3/2/2006
Time = 15:32:23
3)to delete image using the button
show me confirm msg vbOK cbCancel
if VbOK to show me msg to delete file from the folder vbOK vbNo
4)to open PhotoDetail form using button ===This is i know it.
thxs in advance
for a sample db post email or visit
http://www.mdbmakers.com/forums/showthread.php?t=19917
------------------------------------------------------------------------------
--
hi
i am a dentist and i want to make a form which will show me the smile of the
patient before treatment and after.
My images will be save and a folder where my db wil be , with the same name.
My table is:
1) solution 1
tblPhoto
PhotoID
CustomerID
DateBefore
NamePhotoBefore
PathNamePhotoBefore
PhotoBeforeSize
DateAfter
NamePhotoAfter
PathNamePhotoAfter
PhotoAfterSize
Details
2) solution 2
Same time i have only image before or after treatment so i am thing to make 3
tables
tblPhoto
PhotoID
CustomerID
PhotoBeforeID
PhotoAfterID
Details
tblPhotoBefore
PhotoBeforeID
DateBefore
NamePhotoBefore
PathPhotoBefore
PhotoBeforeSize
tblPhotoAfter
PhotoAfterID
DateAfter
NamePhotoAfter
PathPhotoAfter
PhotoAfterSize
which one to use???
---------------------
Look my .Mdb
at the top of the window the DateBefore , DateAfter , NamePhotoBefore ,
NamePhotoAfter , Details
at the rest of the window the 2 images (right-left)
if i have only one image to show me just one big frame.
1)How can i make this work?
2)i want to add image when i doubleclick at the NamePhotoBefore or
NamePhotoAfter.
To open a Form , find my image , click open and copy the image to my Folder ,
rename it using at this format " [CustomerId]_[Surname]_[Name]_dd/mm/yyyy_hh:
mm:ss" , save it at my tbl(fill the field NamePhoto , PathPhoto , PhotoSize)
and last a msg to confirm everything vbOK "Image "..." complete."
my images are .jpeg , .bmp.
sample file save:
34 Smith John 03022006 153223.jpeg
CustomerID = 32
Surname = Smith
Name = John
Today = 3/2/2006
Time = 15:32:23
3)to delete image using the button
show me confirm msg vbOK cbCancel
if VbOK to show me msg to delete file from the folder vbOK vbNo
4)to open PhotoDetail form using button ===This is i know it.
thxs in advance
for a sample db post email or visit
http://www.mdbmakers.com/forums/showthread.php?t=19917