Search results

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...

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

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?

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

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?

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...

ok if i have a feild in a report. hos can i change the colour of the box ( or any thing for that matter) based on some criteria. IE yes, = yellow, no = orange etc

looking at everyone else questions makes me feel dum. i am having a problem setting a condition for how long a macro will run 1 macro opens a form then calls the second macro. the condition is [Forms]![Count_duplicates]![CAB ID]>[IsNull] seems that isnotnull is not working as well

how do i get around not having domenuitem in access 2007. i wish to delete a record in a form. ie domenuitem delete

ok i have a table, 7 fields. because this data is past append from an different report. some times with the date range of this other report we end up with duplicate records. now in access 1 days i would have made a query with a sort and count, first record. opened that in a form. used...

right, what to say. a kiwi living in Australia, got here ver Thailand Laos china and Russia. long story. back in the days of my early 20s and totally frustrated with the old guys who were married to there aircon box containing the GOD of computing a WANG. while struggling with an 8086 and...