Rocky Smolin
rockysmolin at bchacc.com
Fri Oct 11 19:16:50 CDT 2013
Compact on exit works. But there is that annoying lag between exiting and the app actually closing. r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, October 11, 2013 5:13 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Report - One field for one Customer is Missing But be aware of bloat and come up with some way to handle it. On 11 Oct 2013 at 16:55, Rocky Smolin wrote: > I've used that work-around myself when faced with a report that's > going to require overly complex queries. Not your case exactly but I > got the idea of the temp table years ago from this list. I like the > temp table approach because you can lay out the table with exactly the > fields you want on the report and populate t with data instead of FKs. > Use a bit of code to open a recordset to get the basic data - loop > through it filling the target table and walla! Report. > > Rocky > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Friday, October 11, 2013 12:50 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access Report - One field for one Customer is > Missing > > Rocky, David, Gary, Doug, > > Thanks for all of your ideas/insights. > > I used every idea as I tried to debug this problem. > > One thing that I failed to mention earlier is that the underlying > query is pulling data from several other queries. In other words it > is complex. It appears that when the complexity of the queries is > combined with the report (which has sorts and filters), the Access gods are angered. > > I changed the report's query to be a "Make Table" query and then I > changed the report's data source to this new temporary table. This > fixed the problem. > > I don't fully understand what Access does behind the scenes, but > apparently the underlying queries are somehow combined with the report > filters and in some cases that does not work properly. > > I really appreciate all of the help. I am the "Lone Ranger IT person" > with no one else onsite to consult with. Your assistance on this > issue and on many prior problems has been outstanding. > > Thanks again, > Brad > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~ > ~~~ > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Friday, October 11, 2013 11:23 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Access Report - One field for one Customer is > Missing > > All, > > This is one of the strangest things that I have seen for a long time. > > We have a Sales Order report that has been used for several months. > Recently one of our users pointed out that the Customer Name was not > being shown for a specific customer. > > There are 7 fields shown for each customer on the report. All of the > fields are shown for all customers, except one. For this one > customer, only 6 of the 7 fields are shown. > > Here is where things get really interesting... > > When I look at the data from the underlying query, I can see all 7 > fields for this customer. > > In other words, all of the data is visible in the Report's data source > (underlying query), but not all of the data is being shown on the report. > > Any ideas or suggestions would be appreciated. > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > This message was scanned by ESVA and is believed to be clean. > Click here to report this message as spam. > http://h0stname/cgi-bin/learn-msg.cgi?id=F150F27DED.CF9D0 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com