Search results

ok some thing very new to me, i am not sure how that works or how "min" works like that in a query. but it still leaves me not knowing how to get a macro to stop. not in this instance but i do a lot of setvalue stuff with macros.

ops, wrong one

there we go

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

ok great it runs but it is not stopping i said before Criteria, this is wrong, i actually need it for repeat expression or repeat macro?

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

yep got that working fine, simple. it will stop duplicates getting in But i already have duplicates. so next step. i have done this in the past, that was in access 1 days form with filter, ascending and count then <1, that gives all the duplicates. another form with criteria based...

jes that will work. where there are no matching records is null. then append query. the update i think will not work

ok did not get that

ok got it a table to paste into. append query with a new field, ie f1&f2&f3 etc same om table being pasted to but this field is ID no duplicates ok simple just turn off warnings good enough for the blonds in the office

great and thanks i read it understand it not that i could do it. so sill question, i tried to call your module from a macro, run code "Delete Duplicates" didn't work sorry what am i doing wrong?

all fields because the data is pasted from another computer system that i do not have access to. this pasting is also done by other people who at times can not understand the difference between a fortnightly schedule and monthly dates. there are no other fields, but if need be we could...

there we go, and thanks

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