Prev: Access 97 and Windows 7 problem
Next: print documents
From: Co on 30 Mar 2010 01:48
On 29 mrt, 14:00, Andrew G <weit...(a)gru.com> wrote:
> 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- 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
First  |  Prev  | 
Pages: 1 2
Prev: Access 97 and Windows 7 problem
Next: print documents