|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have been using a form for showing the “available inventory†and orders
that need to be shipped from this inventory. The forms data source is based
on 2 nested queries, each time the user releases goods to be shipped the
available inventory is reduced.
The code for this is as follows;
[Forms]![frmCMAOpenToRelease].Requery
Recently I have updated the form with cosmetic improvements, and now this
statement does not work. The code runs with no errors, however the form does
not update with the new “available inventory†qty.
Any ideas as to how to resolve?
Thank you
Nelson
|
|
What I would do in a case like this is:
Make a copy of the query that feeds your form and save it under a temporary
name.
Then, add a breakpoint on this line:
[Forms]![frmCMAOpenToRelease].Requery
Run the application until it stops at the above line.
Go to the database window (F11) and run the temporary (copy) of the query.
See what it gives you. Does it give you the results you want?
I usually use this technique when I'm stuck with queries. You'd be surprised
how often I found bugs this way.
Ray
"Nelson" wrote:
[Quoted Text] >
> I have been using a form for showing the “available inventory†and orders
> that need to be shipped from this inventory. The forms data source is based
> on 2 nested queries, each time the user releases goods to be shipped the
> available inventory is reduced.
> The code for this is as follows;
> [Forms]![frmCMAOpenToRelease].Requery
>
>
> Recently I have updated the form with cosmetic improvements, and now this
> statement does not work. The code runs with no errors, however the form does
> not update with the new “available inventory†qty.
>
> Any ideas as to how to resolve?
>
> Thank you
> Nelson
>
|
|
I should have mentioned that I've already tried this, the problem is that the
query runs fine however the form does not update. I've also tried putting in
a line of code to refresh the form aftert he requerry with no success.
Thank you
Nelson
"Ray Cacciatore" wrote:
[Quoted Text] > What I would do in a case like this is:
> Make a copy of the query that feeds your form and save it under a temporary
> name.
> Then, add a breakpoint on this line:
> [Forms]![frmCMAOpenToRelease].Requery
> Run the application until it stops at the above line.
> Go to the database window (F11) and run the temporary (copy) of the query.
> See what it gives you. Does it give you the results you want?
>
> I usually use this technique when I'm stuck with queries. You'd be surprised
> how often I found bugs this way.
>
> Ray
>
>
> "Nelson" wrote:
>
> >
> > I have been using a form for showing the “available inventory†and orders
> > that need to be shipped from this inventory. The forms data source is based
> > on 2 nested queries, each time the user releases goods to be shipped the
> > available inventory is reduced.
> > The code for this is as follows;
> > [Forms]![frmCMAOpenToRelease].Requery
> >
> >
> > Recently I have updated the form with cosmetic improvements, and now this
> > statement does not work. The code runs with no errors, however the form does
> > not update with the new “available inventory†qty.
> >
> > Any ideas as to how to resolve?
> >
> > Thank you
> > Nelson
> >
|
|
Is the textbox “available inventory†a bound control?
"Nelson" wrote:
[Quoted Text] > I should have mentioned that I've already tried this, the problem is that the
> query runs fine however the form does not update. I've also tried putting in
> a line of code to refresh the form aftert he requerry with no success.
>
> Thank you
> Nelson
>
> "Ray Cacciatore" wrote:
>
> > What I would do in a case like this is:
> > Make a copy of the query that feeds your form and save it under a temporary
> > name.
> > Then, add a breakpoint on this line:
> > [Forms]![frmCMAOpenToRelease].Requery
> > Run the application until it stops at the above line.
> > Go to the database window (F11) and run the temporary (copy) of the query.
> > See what it gives you. Does it give you the results you want?
> >
> > I usually use this technique when I'm stuck with queries. You'd be surprised
> > how often I found bugs this way.
> >
> > Ray
> >
> >
> > "Nelson" wrote:
> >
> > >
> > > I have been using a form for showing the “available inventory†and orders
> > > that need to be shipped from this inventory. The forms data source is based
> > > on 2 nested queries, each time the user releases goods to be shipped the
> > > available inventory is reduced.
> > > The code for this is as follows;
> > > [Forms]![frmCMAOpenToRelease].Requery
> > >
> > >
> > > Recently I have updated the form with cosmetic improvements, and now this
> > > statement does not work. The code runs with no errors, however the form does
> > > not update with the new “available inventory†qty.
> > >
> > > Any ideas as to how to resolve?
> > >
> > > Thank you
> > > Nelson
> > >
|
|
Yes, it is bound to a calculated field in the query.
"Ray Cacciatore" wrote:
[Quoted Text] > Is the textbox “available inventory†a bound control?
>
> "Nelson" wrote:
>
> > I should have mentioned that I've already tried this, the problem is that the
> > query runs fine however the form does not update. I've also tried putting in
> > a line of code to refresh the form aftert he requerry with no success.
> >
> > Thank you
> > Nelson
> >
> > "Ray Cacciatore" wrote:
> >
> > > What I would do in a case like this is:
> > > Make a copy of the query that feeds your form and save it under a temporary
> > > name.
> > > Then, add a breakpoint on this line:
> > > [Forms]![frmCMAOpenToRelease].Requery
> > > Run the application until it stops at the above line.
> > > Go to the database window (F11) and run the temporary (copy) of the query.
> > > See what it gives you. Does it give you the results you want?
> > >
> > > I usually use this technique when I'm stuck with queries. You'd be surprised
> > > how often I found bugs this way.
> > >
> > > Ray
> > >
> > >
> > > "Nelson" wrote:
> > >
> > > >
> > > > I have been using a form for showing the “available inventory†and orders
> > > > that need to be shipped from this inventory. The forms data source is based
> > > > on 2 nested queries, each time the user releases goods to be shipped the
> > > > available inventory is reduced.
> > > > The code for this is as follows;
> > > > [Forms]![frmCMAOpenToRelease].Requery
> > > >
> > > >
> > > > Recently I have updated the form with cosmetic improvements, and now this
> > > > statement does not work. The code runs with no errors, however the form does
> > > > not update with the new “available inventory†qty.
> > > >
> > > > Any ideas as to how to resolve?
> > > >
> > > > Thank you
> > > > Nelson
> > > >
|
|
That is very strange. When you say it "does not update the new “available
inventory†qty" what happens? Does it keep an old value? is it blank?
What were the "cosmetic" changes you made?
"Nelson" wrote:
[Quoted Text] > Yes, it is bound to a calculated field in the query.
>
> "Ray Cacciatore" wrote:
>
> > Is the textbox “available inventory†a bound control?
> >
> > "Nelson" wrote:
> >
> > > I should have mentioned that I've already tried this, the problem is that the
> > > query runs fine however the form does not update. I've also tried putting in
> > > a line of code to refresh the form aftert he requerry with no success.
> > >
> > > Thank you
> > > Nelson
> > >
> > > "Ray Cacciatore" wrote:
> > >
> > > > What I would do in a case like this is:
> > > > Make a copy of the query that feeds your form and save it under a temporary
> > > > name.
> > > > Then, add a breakpoint on this line:
> > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > Run the application until it stops at the above line.
> > > > Go to the database window (F11) and run the temporary (copy) of the query.
> > > > See what it gives you. Does it give you the results you want?
> > > >
> > > > I usually use this technique when I'm stuck with queries. You'd be surprised
> > > > how often I found bugs this way.
> > > >
> > > > Ray
> > > >
> > > >
> > > > "Nelson" wrote:
> > > >
> > > > >
> > > > > I have been using a form for showing the “available inventory†and orders
> > > > > that need to be shipped from this inventory. The forms data source is based
> > > > > on 2 nested queries, each time the user releases goods to be shipped the
> > > > > available inventory is reduced.
> > > > > The code for this is as follows;
> > > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > >
> > > > >
> > > > > Recently I have updated the form with cosmetic improvements, and now this
> > > > > statement does not work. The code runs with no errors, however the form does
> > > > > not update with the new “available inventory†qty.
> > > > >
> > > > > Any ideas as to how to resolve?
> > > > >
> > > > > Thank you
> > > > > Nelson
> > > > >
|
|
The form keeps the old values.
The changes were throughout the database and for all users. In all cases I
standardized the appearance of the forms, (standardize fonts, colors, size of
controls, use windows themed controls etc). On many applications I reworked /
cleaned up old code, eliminated queries ofr sql statements etc.
On this particular form the only changes were the cosmetic ones, (standard
colors, fonts etc). There was no change to the data source or code.
Any help is greatly appreciated.
Thank you
Nelson
"Ray Cacciatore" wrote:
[Quoted Text] > That is very strange. When you say it "does not update the new “available
> inventory†qty" what happens? Does it keep an old value? is it blank?
> What were the "cosmetic" changes you made?
>
>
>
> "Nelson" wrote:
>
> > Yes, it is bound to a calculated field in the query.
> >
> > "Ray Cacciatore" wrote:
> >
> > > Is the textbox “available inventory†a bound control?
> > >
> > > "Nelson" wrote:
> > >
> > > > I should have mentioned that I've already tried this, the problem is that the
> > > > query runs fine however the form does not update. I've also tried putting in
> > > > a line of code to refresh the form aftert he requerry with no success.
> > > >
> > > > Thank you
> > > > Nelson
> > > >
> > > > "Ray Cacciatore" wrote:
> > > >
> > > > > What I would do in a case like this is:
> > > > > Make a copy of the query that feeds your form and save it under a temporary
> > > > > name.
> > > > > Then, add a breakpoint on this line:
> > > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > > Run the application until it stops at the above line.
> > > > > Go to the database window (F11) and run the temporary (copy) of the query.
> > > > > See what it gives you. Does it give you the results you want?
> > > > >
> > > > > I usually use this technique when I'm stuck with queries. You'd be surprised
> > > > > how often I found bugs this way.
> > > > >
> > > > > Ray
> > > > >
> > > > >
> > > > > "Nelson" wrote:
> > > > >
> > > > > >
> > > > > > I have been using a form for showing the “available inventory†and orders
> > > > > > that need to be shipped from this inventory. The forms data source is based
> > > > > > on 2 nested queries, each time the user releases goods to be shipped the
> > > > > > available inventory is reduced.
> > > > > > The code for this is as follows;
> > > > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > > >
> > > > > >
> > > > > > Recently I have updated the form with cosmetic improvements, and now this
> > > > > > statement does not work. The code runs with no errors, however the form does
> > > > > > not update with the new “available inventory†qty.
> > > > > >
> > > > > > Any ideas as to how to resolve?
> > > > > >
> > > > > > Thank you
> > > > > > Nelson
> > > > > >
|
|
Try creating a new textbox that is bound to the same field in the query, see
if that works. Use plain black and white colors. Could it be that your
background color is equal to your foreground color in the field?
"Nelson" wrote:
[Quoted Text] > The form keeps the old values.
>
> The changes were throughout the database and for all users. In all cases I
> standardized the appearance of the forms, (standardize fonts, colors, size of
> controls, use windows themed controls etc). On many applications I reworked /
> cleaned up old code, eliminated queries ofr sql statements etc.
> On this particular form the only changes were the cosmetic ones, (standard
> colors, fonts etc). There was no change to the data source or code.
>
> Any help is greatly appreciated.
>
> Thank you
>
> Nelson
>
> "Ray Cacciatore" wrote:
>
> > That is very strange. When you say it "does not update the new “available
> > inventory†qty" what happens? Does it keep an old value? is it blank?
> > What were the "cosmetic" changes you made?
> >
> >
> >
> > "Nelson" wrote:
> >
> > > Yes, it is bound to a calculated field in the query.
> > >
> > > "Ray Cacciatore" wrote:
> > >
> > > > Is the textbox “available inventory†a bound control?
> > > >
> > > > "Nelson" wrote:
> > > >
> > > > > I should have mentioned that I've already tried this, the problem is that the
> > > > > query runs fine however the form does not update. I've also tried putting in
> > > > > a line of code to refresh the form aftert he requerry with no success.
> > > > >
> > > > > Thank you
> > > > > Nelson
> > > > >
> > > > > "Ray Cacciatore" wrote:
> > > > >
> > > > > > What I would do in a case like this is:
> > > > > > Make a copy of the query that feeds your form and save it under a temporary
> > > > > > name.
> > > > > > Then, add a breakpoint on this line:
> > > > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > > > Run the application until it stops at the above line.
> > > > > > Go to the database window (F11) and run the temporary (copy) of the query.
> > > > > > See what it gives you. Does it give you the results you want?
> > > > > >
> > > > > > I usually use this technique when I'm stuck with queries. You'd be surprised
> > > > > > how often I found bugs this way.
> > > > > >
> > > > > > Ray
> > > > > >
> > > > > >
> > > > > > "Nelson" wrote:
> > > > > >
> > > > > > >
> > > > > > > I have been using a form for showing the “available inventory†and orders
> > > > > > > that need to be shipped from this inventory. The forms data source is based
> > > > > > > on 2 nested queries, each time the user releases goods to be shipped the
> > > > > > > available inventory is reduced.
> > > > > > > The code for this is as follows;
> > > > > > > [Forms]![frmCMAOpenToRelease].Requery
> > > > > > >
> > > > > > >
> > > > > > > Recently I have updated the form with cosmetic improvements, and now this
> > > > > > > statement does not work. The code runs with no errors, however the form does
> > > > > > > not update with the new “available inventory†qty.
> > > > > > >
> > > > > > > Any ideas as to how to resolve?
> > > > > > >
> > > > > > > Thank you
> > > > > > > Nelson
> > > > > > >
|
|
|