Search results

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

You could use a tab control and separate data elements on specific tabs...

Dont know if this is what he means, but this came up in search Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd.tttttt . This is called a serial date, or serial date-time.

1. Have you tried just using App1? 2. Tried " ' " & App1 & " ' " ? 3. Using Option Explicit to make sure var name is correct?

:confused: I am trying to create an xml file from a query. I ran the query then selected Export - xml file (using Access 2010). The query generates 637 recs having 9 columns. While it takes about a minute to process, I am only getting the following in my xml file that gets created: <?xml...

:cool: Well....the above is NOT accurate --- I managed to totally not see that the data was NOT getting entered for two fields into the table that was the source for the query for the datamerge file. I changed the code that was preventing this so the data would get added --- and the problem has...