From: Co on
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
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
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
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
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
 |  Next  |  Last
Pages: 1 2
Prev: Access 97 and Windows 7 problem
Next: print documents