Search results

hi again, DateAdd("m",[valid_for],[Medical]) AS valid_until should do it, check DateAdd in the help if u need more, it'll explain it better than me anke

you should be able to use something like WHERE (((f_date_probs.xDate) Between "01/01/" & Format(Date(),"yy") And "31/12/" & Format(Date(),"yy"))); hth anke

You've spelt myresponse/myrespsonse differently in the code to the declaration - leave in option explicit at the top and any errors like that will be flagged for u. Also a correct entry will change the capitalization of the var to its declaration Anke

hehe, what was it? anything interesting?

erm, you used "c:\accessgps\sketches\1.bmp" as the source? - you need it to be available to everyone as a url ie on a server on the net somewhere - not ur local drive, then u can do it anke

Hi Mike, i came across this but haven't used it at all so can't tell you if it works or not best wishes anke

Hi os1, that looks like ADO which i don't know much about, but if you pasted that from code then you need to change FORM to FROM best wishes Anke