Replies

i’ve never tried it in a query but in a form i use this code
Textbox = DateDiff(“yyyy”, [BirthDate], Now()) + Int(Format(Now(), “mmdd”) < Format([BirthDate], "mmdd"))

is there code behind the button that opens the form
is there a query for the form
if there is check to see if these have been changed

have you checked to see if any records are still in the table

if you are going to keep the old pc
you could network the two

just use the pre tag

in the 1-click tagpanel

go to table design and set the fields format to mm/dd

you could creat a pop up form to enter the data and set the query criteria to the popup
then in the popup you could use the imput mask

instead of having an ole field i save the path to the pictures in a table
and save the pictures in a directory outside of the database
if you can do this with yours the jpg should work
they do in my database

have you tried an image control instead of a bound or unbound object frame

do you have a boot disk

on the on click event click on this line you will see a box to the right with three dots in it click this box then a popup window will appear click on code builder then place the code
for the dmax here at least that is the way in acc2000 i’m at work right now and only have acc2000 here hope this helps

just go to windows explorer and copy the database to the directory you want then right click on the database and uncheck the read only attribute

did you try charlottes decompile trick before zipping the database

i don’t see the attachment

do you have any other code in this onclick event
other than the dmax statement