From: Gina Whipp on 22 Dec 2009 17:20 Allan, Just say thank goodness it works! Happy Holidays! Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ALLAN_ASHFORD via AccessMonster.com" <u56735(a)uwe> wrote in message news:a0fcbd65df3d1(a)uwe... > Maybe no longer stumped!! > > The table that I was trying to append the data to was, as you know, copied > over from the fully functional database. As such it did contain well over > 100, > 000 redundant records. So I deleted the lot, did a repair & compact and > hey > presto everything appears to be OK. Only problem now is - trying to > remember > what I was trying to do when the problem hit!! > > Many thanks for all the input - have a great Xmas. > > Allan > > Gina Whipp wrote: >>AccessVandal, >> >>In the macro yes those settings are required and the other options are not >>an option. The subject line is kind of deciptive because those queries he >>is referring to are actually, make table and update queries. Oddly, >>enough >>the macro runs in one database FE/BE set-up but not the other. He sent me >>a >>copy of the database and I was looking for some reference to a table or >>query that existed in the one database but not the other and after >>reviewing >>MANY queries, found one. So now I am as stumped as he is. >> >>> Gina, >>> >>[quoted text clipped - 17 lines] >>>>There >>> snip... > > -- > Message posted via http://www.accessmonster.com >
First
|
Prev
|
Pages: 1 2 3 4 5 6 7 Prev: Look up tables vs. value fields via combo box on form Next: Linking Tables |