From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Access Trick (fwd) |
Date: | 2001-01-04 09:52:44 |
Message-ID: | Pine.LNX.4.21.0101041150280.1686-100000@nanu.visionforisrael.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
I got this from my friend.. I'm not sure if we're just doing something
wrong or if this is the workaround for more Access strangeness.
-Cedar
---------- Forwarded message ----------
In order to get a form in Access to refresh you use form.requery, at least
according to the documentation. However in my experience this does not
work. In my case I want to get the back end to do a sort on my data, so I
have changed the SQL of the pass-through query on which the form is
based. Calling requery does not change anything, but the following line in
VB does :
Me.RecordSource=Me.RecordSource
Apparently if you change the record source of the form it automatically
requeries the form, irrespective of whether the value of the RecordSource
property has actually changed...
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Kovacs Zoltan Sandor | 2001-01-04 16:03:41 | ODBC-update, version numbers |
Previous Message | Karel Zak | 2001-01-04 07:03:45 | Re: Numeric and money |