after I run form query is empty
in [Help]
|
Prev: Access 97 and Windows 7 problem
Next: print documents
From: Co on 28 Mar 2010 13:18 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
From: Salad on 28 Mar 2010 13:28 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.
From: Co on 28 Mar 2010 13:33 On 28 mrt, 19:28, Salad <sa...(a)oilandvinegar.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
From: Salad on 28 Mar 2010 15:11 Co wrote: > On 28 mrt, 19:28, Salad <sa...(a)oilandvinegar.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.
From: Andrew G on 29 Mar 2010 08:00
On Mar 28, 3:11 pm, Salad <sa...(a)oilandvinegar.com> wrote: > Co wrote: > > On 28 mrt, 19:28, Salad <sa...(a)oilandvinegar.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 |