Kamis, 10 September 2015

Re: [MS_AccessPros] Report Not Updating With Query Data Set

 

Hi John,
There is only one form and query in the DB at the moment. qryControl_Chart_Inputs query calculates the Mahalanobis Distance (MD) from the Stains and Stain_Data Table inputs. The query has a criteria reference from the Forms![frmStain_Selection]![Stain] field. Which updates OK upon Open. The Control Chart is found inside the Report  "MD Control Chart".

I hope this helps.

Greg



On Thursday, September 10, 2015 11:20 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Greg-

It would help to know the name of the form and report to which you are referring.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Sep 10, 2015, at 6:38 PM, blue xenon xenon.blue@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thanks, John.
I just uploaded the associated files.

Greg



On Thursday, September 10, 2015 8:52 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Greg-

I just gave you authorization to upload files.  Go to the website / Files and upload your file to the 2_AssistanceNeeded folder.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Sep 10, 2015, at 5:44 PM, xenon.blue@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi There!
I hope everyone is having a "You Beaut" day!
I am working on an application that store raw data and performs calculations in a query on the raw data to display on an embedded chart in a report. The query criteria is controlled by a unbound field combo box and updates fine with the changes in criteria. However my report whose Record Source is the same query does not update the chart. Can someone please help me by taking a look at my application ? I appreciate your help. I'm not an expert in VBA coding so please be kind and explain for a dummy like me :)


Best Regards,

Greg

PS I'm not sure if I can upload my application from here for you to look at






__._,_.___

Posted by: blue xenon <xenon.blue@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar