APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
in [Tables]
|
From: Gina Whipp on 14 Dec 2009 12:16 Allan, If the query is dependent on the form to run why does it open after the query is set to run. Might be a timing issue? -- 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:a091868c5a4e5(a)uwe... > 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 >
From: ALLAN_ASHFORD via AccessMonster.com on 14 Dec 2009 14:33 Hi Gina The Form contains a numeric value which is the current difference between the Lowest & Highest Unadded Lines in a table. Whilst this is >0 the macro will run, hence the reason for closing the form and then reopening so that the test can be carried out in the Repeat Expression ([Forms]![20 -FIND HIGHEST/LOWEST DIFFERENCE COUNT FORM]!{Expr1])>0 in the parent macro. I have tried putting a MsgBox in the troublesome macro immediately before the OpenForm command, but to no avail. Allan Gina Whipp wrote: >Allan, > >If the query is dependent on the form to run why does it open after the >query is set to run. Might be a timing issue? > >> Hi Gina >> >[quoted text clipped - 78 lines] >>>>>>>>>>> >>>>>>>>>>>Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
From: Gina Whipp on 14 Dec 2009 19:13 Allan, To no avail, does that mean the message box didn't even open? Also, have you considered refreshing the value in the form as opposed to closing and then opening? Once the query opens it's static, it won't look for... oh a form opened and I need that value... -- 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:a096e8e75eb4d(a)uwe... > Hi Gina > > The Form contains a numeric value which is the current difference between > the > Lowest & Highest Unadded Lines in a table. Whilst this is >0 the macro > will > run, hence the reason for closing the form and then reopening so that the > test can be carried out in the Repeat Expression ([Forms]![20 -FIND > HIGHEST/LOWEST DIFFERENCE COUNT FORM]!{Expr1])>0 in the parent macro. > > I have tried putting a MsgBox in the troublesome macro immediately before > the > OpenForm command, but to no avail. > > Allan > Gina Whipp wrote: >>Allan, >> >>If the query is dependent on the form to run why does it open after the >>query is set to run. Might be a timing issue? >> >>> Hi Gina >>> >>[quoted text clipped - 78 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 15 Dec 2009 03:59 Hi Gina The MsgBox opened OK. To no avail referred to the fact that the problem query still did not append the data it should. Going back to the start we have the situation that the problem query will run on its own but not from within a macro yet on the original database which sits alongside it exactly the same macro works OK. So the question is basically why exactly the same query will not run off a macro in one database but will run off a macro in another databse which has exactly the same structure and runs the same queries in this regard. Yes, the 2 databases do have differences as effectively the database that is OK is a "parent" to the one with the problem, but those differences are elsewhwre and indeed are working OK. Allan Gina Whipp wrote: >Allan, > >To no avail, does that mean the message box didn't even open? Also, have >you considered refreshing the value in the form as opposed to closing and >then opening? Once the query opens it's static, it won't look for... oh a >form opened and I need that value... > >> Hi Gina >> >[quoted text clipped - 21 lines] >>>>>>>>>>>>> >>>>>>>>>>>>>Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
From: Gina Whipp on 15 Dec 2009 12:12
Allan, There is SOMETHING different and I'll be d***ed I can't figure it out. Any chance I get look at the *bad* database? -- 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:a09df1afa5ec2(a)uwe... > Hi Gina > > The MsgBox opened OK. To no avail referred to the fact that the problem > query > still did not append the data it should. > > Going back to the start we have the situation that the problem query will > run > on its own but not from within a macro yet on the original database which > sits alongside it exactly the same macro works OK. > > So the question is basically why exactly the same query will not run off a > macro in one database but will run off a macro in another databse which > has > exactly the same structure and runs the same queries in this regard. > > Yes, the 2 databases do have differences as effectively the database that > is > OK is a "parent" to the one with the problem, but those differences are > elsewhwre and indeed are working OK. > > Allan > Gina Whipp wrote: >>Allan, >> >>To no avail, does that mean the message box didn't even open? Also, have >>you considered refreshing the value in the form as opposed to closing and >>then opening? Once the query opens it's static, it won't look for... oh a >>form opened and I need that value... >> >>> Hi Gina >>> >>[quoted text clipped - 21 lines] >>>>>>>>>>>>>> >>>>>>>>>>>>>>Allan > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 > |