 | |
after I run form query is empty
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
after I run form query is empty -
03-28-2010
, 12:18 PM
#2
| |||
| |||
|
|
Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to open the query again it is empty. How does that happen? Regards Marco |
msgbox me.filter & vbNewLine & me.filteron
if a form's filter is affecting the records displayed.
That would display the form's filter and if it is on or not. Perhaps
your filter is getting changed.
#3
| |||
| |||
|
|
Co wrote: Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to open the query again it is empty. How does that happen? Regards Marco You could try * * * * msgbox me.filter & vbNewLine & me.filteron if a form's filter is affecting the records displayed. That would display the form's filter and if it is on or not. *Perhaps your filter is getting changed. |
When I try to run the query without the form after having opened it
once
all the fields have gone.
Marco
#4
| |||
| |||
|
|
On 28 mrt, 19:28, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to open the query again it is empty. How does that happen? Regards Marco You could try msgbox me.filter & vbNewLine & me.filteron if a form's filter is affecting the records displayed. That would display the form's filter and if it is on or not. Perhaps your filter is getting changed. Well it actually changes the whole query. When I try to run the query without the form after having opened it once all the fields have gone. Marco |
Do you have some inner joins that could make a difference? A "table" in
the query that is actually another query that may have some filter in
it...like a reference to a form variable?
What happens if you close the database, open it, and run the query a
couple of times. Is it always product blank rows?
What happens if you save the query to a temp one, open the temp in
design mode, and start deleting tables one by one and running the query?
Maybe set the relationships to right joins off the main table.
I wish I could offer further advice but I don't know what else to offer.
#5
| |||
| |||
|
|
Co wrote: On 28 mrt, 19:28, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to open the query again it is empty. How does that happen? Regards Marco You could try * * * *msgbox me.filter & vbNewLine & me.filteron if a form's filter is affecting the records displayed. That would display the form's filter and if it is on or not. *Perhaps your filter is getting changed. Well it actually changes the whole query. When I try to run the query without the form after having opened it once all the fields have gone. Marco Very strange. *Same query? Do you have some inner joins that could make a difference? *A "table" in the query that is actually another query that may have some filter in it...like a reference to a form variable? What happens if you close the database, open it, and run the query a couple of times. *Is it always product blank rows? What happens if you save the query to a temp one, open the temp in design mode, and start deleting tables one by one and running the query? * * *Maybe set the relationships to right joins off the main table. I wish I could offer further advice but I don't know what else to offer.-Hide quoted text - - Show quoted text - |
Have you checked Name AutoCorrect under Tools/ Options/ General?
Deselect 'Track name AutoCorrect info', fix your query and see if it
fixes your problem.
Andrew
#6
| |||
| |||
|
|
On Mar 28, 3:11*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: On 28 mrt, 19:28, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but whenI try to open the query again it is empty. How does that happen? Regards Marco You could try * * * *msgbox me.filter & vbNewLine & me.filteron if a form's filter is affecting the records displayed. That would display the form's filter and if it is on or not. *Perhaps your filter is getting changed. Well it actually changes the whole query. When I try to run the query without the form after having opened it once all the fields have gone. Marco Very strange. *Same query? Do you have some inner joins that could make a difference? *A "table"in the query that is actually another query that may have some filter in it...like a reference to a form variable? What happens if you close the database, open it, and run the query a couple of times. *Is it always product blank rows? What happens if you save the query to a temp one, open the temp in design mode, and start deleting tables one by one and running the query? * * *Maybe set the relationships to right joins off the main table. I wish I could offer further advice but I don't know what else to offer..- Hide quoted text - - Show quoted text - Hi, Have you checked Name AutoCorrect under Tools/ Options/ General? Deselect 'Track name AutoCorrect info', fix your query and see if it fixes your problem. Andrew- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - |
That seems to work. What does that function do.
Why does it remove my query when I run it in a form?
Marco
#7
| |||
| |||
|
|
On 29 mrt, 14:00, Andrew G <weit... (AT) gru (DOT) com> wrote: On Mar 28, 3:11*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: On 28 mrt, 19:28, Salad <sa... (AT) oilandvinegar (DOT) com> wrote: Co wrote: Hi All, I have a query that will show my budget for the current year. When I open the query in a form it shows me all the figures but when I try to open the query again it is empty. How does that happen? Regards Marco You could try * * * *msgbox me.filter & vbNewLine & me.filteron if a form's filter is affecting the records displayed. That would display the form's filter and if it is on or not. *Perhaps your filter is getting changed. Well it actually changes the whole query. When I try to run the query without the form after having opened it once all the fields have gone. Marco Very strange. *Same query? Do you have some inner joins that could make a difference? *A "table" in the query that is actually another query that may have some filter in it...like a reference to a form variable? What happens if you close the database, open it, and run the query a couple of times. *Is it always product blank rows? What happens if you save the query to a temp one, open the temp in design mode, and start deleting tables one by one and running the query? * * *Maybe set the relationships to right joins off the main table. I wish I could offer further advice but I don't know what else to offer.- Hide quoted text - - Show quoted text - Hi, Have you checked Name AutoCorrect under Tools/ Options/ General? Deselect 'Track name AutoCorrect info', fix your query and see if it fixes your problem. Andrew- Tekst uit oorspronkelijk bericht niet weergeven - - Tekst uit oorspronkelijk bericht weergeven - Andrew, That seems to work. What does that function do. Why does it remove my query when I run it in a form? Marco- Hide quoted text - - Show quoted text - |
Name Autocorrect is a 'feature' to help a developer track object names
and name changes. I can't answer why it changes your query. I had the
same experience with one of my databases.
Some very reliable Access folks (i.e. Alan Browne) suggest disabling
it routinely. See: http://allenbrowne.com/bug-03.html
Andrew
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.