Re: How do I combine all datarecords in one field into another fi
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Tue, 6 Sep 2005 17:23:22 -0700, "Lisa"
<Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Hi...
>
>I am from Mariana's office. We like the idea of using a query because of
>the simplicity, the problem is... none of what has been given seems to work
>in Access 2003. It seems they are all Access 2000 related.
>
>Does anyone know how to query this in Access 2003? If not, the code should
>be Access 2003 also, thanks for your help.
This cannot be done efficiently in a Query. You must use VBA code.
And the VBA code that works for A2000 works just fine in A2003, unless
you have something wrong. There are very few code differences between
the two versions; code written for A2000 should run just fine in
A2003. If it doesn't, please post the code that you're using and
indicate in what way it "doesn't work".
John W. Vinson[MVP]
.
Relevant Pages
- Re: Build Dynamic Query from Form
... I didn't follow the bit about why you "really need to this in the query" *instead* of in VBA code. ... Declare the parameters in your query, so JET knows their data type. ... I got it working in my Report, but all it does now is filter for dates, the ... Dim strDateCondition As String ...
(microsoft.public.access.modulesdaovba) - Re: How do i count and store "selected" check boxes in a query?
... it takes me to the VBA code and highlisted my new line of code. ... the "IsGroup" check and so when i print label for the orders; ... To use an insert query, you will have to use VBA code (as a procedure ...
(microsoft.public.access.queries) - query returning oldest record only
... This is the query as run in Access which returns bad results. ... I also get proper results when I use ADO. ... Working continous form VBA code. ...
(microsoft.public.access.queries) - Re: Concatenating the same field from multiple records
... It's better to use the Execute method of CurrentDb for executing queries ... Dim dbs As DAO.Database ... if i was to take the SQL for the append query and use it in VBA code, ... it be better to execute the query, or can i use docmd.sql " my sql here" ...
(microsoft.public.access.queries) - Re: CrossTab Query with Parameter
... - The parameters are not recognised as parameter, because in xTab1 I do not ... In the cross-tab report, the parameter is not filled properly in the ... 'underlying query'. ... using VBA Code if need be, but please try to provide me with as much ...
(comp.databases.ms-access) |
|
