Recent content by clean32

did you like the way o found and deleted duplicates, have any better ideas?

got it working just needed Day([Forms]![yourForm]![field])="1" in general i attached the finished DB

ok firstly, thank you all who helped and attached is the almost finished product need polishing but it works when you all have finished rolling on the floor laughing at all the rules i have broken and how i have done everything the hard/odd.strange way. you then can comment...

thanks, its an IF day, new one to me. but if i leave the end macro blank will it just move onto the next line? or do i actually have to have an end there. or will and end actually stop every thing?

i wish to run a macro only if the day matches from a form with a date. if the day of that date is the 1st, then run macro. if not i assume it will step over to the next line in the macro. which will be the same but the 2nd, then 3rd and so forth

thanks, yes you are correct VBA is over my head, i am not a programmer, i am a Metallurgist or was. i am struggling a bit with access 2007. every thing has moved or i can not locate it. i have wasted 1/2 of this afternoon with some thing called trust?? you showed me where setvale was...

ohh umm, now that makes me feel dum. yes and thanks

http://www.access-programmers.co.uk/forums/showthread.php?t=287554

i have read the post below and its a bit above me. access used to have setvalue in the macro. now it has gone. so what do i do in a macro. to set a value from one form to another form?

i do not know how to run a docmd. however i found RunCommand in the macro and then delete-record. so that working thanks

in a query i have a IDfield and a datee field. next field i have 1 then 2 then 3, for the days of the month. i wish to poke the date from the date field into the field with its corresponding day so i was thinking along the lines of 1: iff (( [datee]"dd")="1",[datee],null) the next query...

ok you learn something every day. this has just answered another problem i have been having and posted else where. ie do not name query and forms "report" i used format. now i am trying to nest that format into an iff 1: iff(( Format([DATE]," dd")="01",[DATE],Null)

hello trying to use the above in a field. example DATE field 12/jun/16. the day function is returning 12/jun/1900 got me stumped ( again) i need just the dat IE 12, so i can do other stuff with it

access 2007 and windows 10 ???

hello i am making a query with criteria from a form i have done this many times before this time i open the builder, forms open/all forms. and there is nothing there? blank what have i done/ turned off?