What went wrong?

[Nelson]

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

 

[Ray Cacciatore]

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]

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

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

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

 

[Ray Cacciatore]

Is the textbox “available inventory†a bound control?

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

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

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

 

[Nelson]

Yes, it is bound to a calculated field in the query.

Is the textbox “available inventory†a bound control?

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

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


:


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

 

[Ray Cacciatore]

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?

Yes, it is bound to a calculated field in the query.

Is the textbox “available inventory†a bound control?

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

:

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


:


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

 

[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

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?

Yes, it is bound to a calculated field in the query.

Is the textbox “available inventory†a bound control?

:

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

:

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


:


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

 

[Ray Cacciatore]

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?

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

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?

Yes, it is bound to a calculated field in the query.

:

Is the textbox “available inventory†a bound control?

:

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

:

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


:


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