APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
in [Tables]
|
From: ALLAN_ASHFORD via AccessMonster.com on 11 Dec 2009 09:58 Hi Gina The macro that has the problem runs from within another macro which is activated by clicking a button on a form. The problem macro has a Repeat Count of 200 and a Repeat Expression in the form of a Form that shows the difference between 2 numbers and runs whilst this difference is >0. Gina Whipp wrote: >Allan, > >Then the Macro Security is not an option if using Access 2000. How is the >macro run? Is it a button on a form? What is the code? > >> Hi Gina >> >[quoted text clipped - 18 lines] >>>>> >>>>>Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
From: Gina Whipp on 11 Dec 2009 10:07 Allan, Have you you tried *Stepping* thru the macro? Also can you post the Actions of the Macro here? Since both databases are connected to the same back-end, are you running them at the same time? -- 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:a06eca20f244e(a)uwe... > Hi Gina > > The macro that has the problem runs from within another macro which is > activated by clicking a button on a form. The problem macro has a Repeat > Count of 200 and a Repeat Expression in the form of a Form that shows the > difference between 2 numbers and runs whilst this difference is >0. > > Gina Whipp wrote: >>Allan, >> >>Then the Macro Security is not an option if using Access 2000. How is the >>macro run? Is it a button on a form? What is the code? >> >>> Hi Gina >>> >>[quoted text clipped - 18 lines] >>>>>> >>>>>>Allan > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 >
From: ALLAN_ASHFORD via AccessMonster.com on 11 Dec 2009 14:14 Hi Gina Have tried stepping but still no success. Sorry to seem so dim, but how do I post the Macro Actions? I am not running the 2 databases simultaneously, they merely sit alongside each other on the local hard drive and the 2 back-ends likewise on the other PC. Gina Whipp wrote: >Allan, > >Have you you tried *Stepping* thru the macro? Also can you post the Actions >of the Macro here? Since both databases are connected to the same back-end, >are you running them at the same time? > >> Hi Gina >> >[quoted text clipped - 13 lines] >>>>>>> >>>>>>>Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
From: Gina Whipp on 11 Dec 2009 14:36 Allan, No need to be sorry... now once you do you will have learned something new today! Unfortunately, no easy way to do this... You have to open the Macro and type each line Action blah Action Arguements blah blah etc... -- 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:a07105549fac7(a)uwe... > Hi Gina > > Have tried stepping but still no success. > > Sorry to seem so dim, but how do I post the Macro Actions? > > I am not running the 2 databases simultaneously, they merely sit alongside > each other on the local hard drive and the 2 back-ends likewise on the > other > PC. > > Gina Whipp wrote: >>Allan, >> >>Have you you tried *Stepping* thru the macro? Also can you post the >>Actions >>of the Macro here? Since both databases are connected to the same >>back-end, >>are you running them at the same time? >> >>> Hi Gina >>> >>[quoted text clipped - 13 lines] >>>>>>>> >>>>>>>>Allan > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 >
From: ALLAN_ASHFORD via AccessMonster.com on 14 Dec 2009 04:17
Hi Gina This is the macro that is giving the problem:- Set Warnings Warnings On No Close Form 20 - FIND HIGHEST/LOWEST DIFFERENCE COUNT FORM Save Prompt OpenQuery 20 - FIND LOWEST UNADDED LINE View Datasheet Data Mode: Edit *************************************************************************************************** OpenQuery 20 - APPEND RAW MATERIALS RE LOWEST ASSIGNED BOM View Datasheet Data Mode: Edit This is the Query that doesn't work in the Macro **************************************************************************************************** OpenQuery 20 - HIGHEST ASSIGNED BOM LINE View Datasheet Data Mode: Edit OpenQuery 20 - FLAG BOM LINE AS ASSIGNED TO RAW MATERIALS View Datasheet Data Mode: Edit OpenForm 20 - FIND HIGHEST/LOWEST DIFFERENCE COUNT FORM View: Form Filter Name: Where Condition: Data Mode: -1 Window Mode: Hidden The Form is needed to give the Repeat Expression condition in the parent macro. Allan Gina Whipp wrote: >Allan, > >No need to be sorry... now once you do you will have learned something new >today! Unfortunately, no easy way to do this... You have to open the Macro >and type each line > >Action >blah > >Action Arguements >blah >blah >etc... > >> Hi Gina >> >[quoted text clipped - 20 lines] >>>>>>>>> >>>>>>>>>Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 |