Search results

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?

ok number of days between and average days i can do easy. just i have this report going to some area managers who only just know how to turn on there computers, let alone read a date. do the report has to be realy dum and in a format that they are accustom. or they will complain that they do...

there we go

uummm very good question how about if we forget about the date ranges and do it by day. i can make this look pretty in a report so it appears to be a week range. but my thought would be that we would have to show all dates ID 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18...

ok maybe i should start again, possibly i am not approaching the problem correctly i have a fields ID Date there could be multiple dates for each ID i need to flip this around so that if the date falls within the first week it is shown in the first field. second week second field and...

i have a Table with a long list of dates also a form with a date part 1 what i want is 4 columns in a query based on these dates column 1 form date and + 7 days column 2 between form date=7days and form date +14 days column 2 between form date=15days and form date +21 days column 2...