Recent content by JoanneJames

FYI: I had a problem with a REPORT - and as you know, there is no where clause there. I was able to resolve by setting the filter AFTER I had changed the recordsource. In previous versions of Access that was not necessary.

I have starting looking into the same problem as well. We moved from Access 2003 to 2010 - and now, a query that took 5 minutes to run prior (has many left-joins), now takes 30 minutes to run. I believe that this has to do with either the new version of Access or perhaps an OS update. I...

Just to report on this: my query was accessing linked Progress tables and I thought that it might be where the bottleneck lie. So, I first created a query to move the data to a table - then did the export to xml from there. It then worked.

I suggest you start studying Access help then. In the meantime, to get you started, here are some links: http://www.brainbell.com/tutorials/ms-office/Access_2003/ http://www.meadinkent.co.uk/accqueryjoins.htm

I believe the only way to do that is via my original recommendation. Creating a filter on a recordset that has already been constructed just displays the record(s) you want to see.

If the query for the second form has thousands of records, then each of those records would have to be transferred over the network, even though you would be accessing only one of them, hence best practice to create queries that get only the records you need.

I'd suggest doing this in your query using an iif stmt to create the extra field, so the data will be available for your report.

Don't know if you a visual person or not, but at this link are diagrams showing how tables are interconnected. Basically to get data from multiple tables in one query, you have to 'join' those tables via foreign keys (FKeys). These diagrams illustrate some of those joins...

If you want to minimize # of recs you have available for a form (best practice to do), then another option is to pass the key that identifies the record to the new form and in the open event of that second form, re-create or modify the query that generates the data for the form and requery so...

Is your query linked to the tables you think they are supposed to be linked to? i.e.: Are you looking in the correct table to verify results? ie test vs. production?

Have you tried looking up Union queries in help? There should be plenty of examples out there...

Appreciate your response. I sent a recent post on this - and see it isn't appearing, so here I go again: I had tried this previously -written up a function using this method and it still doesn't work.

what union query? All you have are two tables...

In before update event, you could try applying the original value against the new value with some kind of bit-wise operation that would retain the values in the other positions (of course assuming the pattern is always the same)

try adding rst.movenext after updating