Design View vs Form View
in [General]
|
From: Bill on 15 May 2010 15:31 In Access 2007, I have a graph in Design View which shows differently in Form View. In other words, the information that is plotted in the graph shows differently in the two views. Why is this? Thank you, Bill
From: Al Campagna on 15 May 2010 23:31 Bill, Your probably saying the design data displays an earlier design results, but the form view graph data is correct. The graphs have acted that way for the past Access versions as well. I think the Graphing in Access is borrowed from Excel, and does not update in design view as it should. One way around that, is to run the query behind the graph in design view, and copy and paste the query results into the graph's associated excel spread sheet. That will "smack the graph up side the head", and get the latest values to show in design... as well as form view. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Bill" <Bill(a)discussions.microsoft.com> wrote in message news:6E1FE22D-D0AE-44CD-A648-635869CA55AF(a)microsoft.com... > In Access 2007, I have a graph in Design View which shows differently in > Form > View. In other words, the information that is plotted in the graph shows > differently in the two views. Why is this? > > Thank you, > > Bill
From: Bill on 16 May 2010 00:22 Al: You are correct in your assessment of what is happening with showing old data in design view and current data in form view. Could you please be more specific in what I should do to correct the problem. May be a step by step solution. Thanks, Bill "Al Campagna" wrote: > Bill, > Your probably saying the design data displays an earlier design results, > but the form view graph data is correct. > The graphs have acted that way for the past Access versions as well. > I think the Graphing in Access is borrowed from Excel, and does not update > in design view as it should. > > One way around that, is to run the query behind the graph in design > view, and copy and paste the query results into the graph's associated excel > spread sheet. > That will "smack the graph up side the head", and get the latest values > to > show in design... as well as form view. > -- > hth > Al Campagna > Microsoft Access MVP 2007-2009 > http://home.comcast.net/~cccsolutions/index.html > > "Find a job that you love... and you'll never work a day in your life." > > > "Bill" <Bill(a)discussions.microsoft.com> wrote in message > news:6E1FE22D-D0AE-44CD-A648-635869CA55AF(a)microsoft.com... > > In Access 2007, I have a graph in Design View which shows differently in > > Form > > View. In other words, the information that is plotted in the graph shows > > differently in the two views. Why is this? > > > > Thank you, > > > > Bill > > > > . >
From: Arvin Meyer [MVP] on 16 May 2010 08:09 This behavior has been around since graphing was first introduced in Access and no one has ever considered it to be worthy of trying to change. I don't understand why you consider this to be a problem. Once built, forms and reports should never be viewed in Design View at all. Some of Access's file formats make it impossible to view a form or report in Design View. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Bill" <Bill(a)discussions.microsoft.com> wrote in message news:3F4A9816-23F4-4137-B389-400F55907B28(a)microsoft.com... > Al: > > You are correct in your assessment of what is happening with showing old > data in design view and current data in form view. > > Could you please be more specific in what I should do to correct the > problem. May be a step by step solution. > > Thanks, > > Bill > > > > "Al Campagna" wrote: > >> Bill, >> Your probably saying the design data displays an earlier design >> results, >> but the form view graph data is correct. >> The graphs have acted that way for the past Access versions as well. >> I think the Graphing in Access is borrowed from Excel, and does not >> update >> in design view as it should. >> >> One way around that, is to run the query behind the graph in design >> view, and copy and paste the query results into the graph's associated >> excel >> spread sheet. >> That will "smack the graph up side the head", and get the latest >> values >> to >> show in design... as well as form view. >> -- >> hth >> Al Campagna >> Microsoft Access MVP 2007-2009 >> http://home.comcast.net/~cccsolutions/index.html >> >> "Find a job that you love... and you'll never work a day in your >> life." >> >> >> "Bill" <Bill(a)discussions.microsoft.com> wrote in message >> news:6E1FE22D-D0AE-44CD-A648-635869CA55AF(a)microsoft.com... >> > In Access 2007, I have a graph in Design View which shows differently >> > in >> > Form >> > View. In other words, the information that is plotted in the graph >> > shows >> > differently in the two views. Why is this? >> > >> > Thank you, >> > >> > Bill >> >> >> >> . >>
From: Al Campagna on 16 May 2010 13:33
Bill, As Arvin Meyer pointed out in his post, what a graph displays in design mode is not really a problem, as long as it displays correctly in form view. However... Go into Design View for the chart. Bring up the design grid for the query that is your RowSource for the chart. Run that query from the design grid. Copy the resulting grid/datasheet of records returned. Paste those records into the spreadsheet associated with the chart design. Your design values and view values should now be in sync. Be aware however, that they may not stay in sych, when the "design" data changes. I wouldn't worry about it until the graph was all nailed down, and then sync... just for appearance sake... -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Bill" <Bill(a)discussions.microsoft.com> wrote in message news:3F4A9816-23F4-4137-B389-400F55907B28(a)microsoft.com... > Al: > > You are correct in your assessment of what is happening with showing old > data in design view and current data in form view. > > Could you please be more specific in what I should do to correct the > problem. May be a step by step solution. > > Thanks, > > Bill > > > > "Al Campagna" wrote: > >> Bill, >> Your probably saying the design data displays an earlier design >> results, >> but the form view graph data is correct. >> The graphs have acted that way for the past Access versions as well. >> I think the Graphing in Access is borrowed from Excel, and does not >> update >> in design view as it should. >> >> One way around that, is to run the query behind the graph in design >> view, and copy and paste the query results into the graph's associated >> excel >> spread sheet. >> That will "smack the graph up side the head", and get the latest >> values >> to >> show in design... as well as form view. >> -- >> hth >> Al Campagna >> Microsoft Access MVP 2007-2009 >> http://home.comcast.net/~cccsolutions/index.html >> >> "Find a job that you love... and you'll never work a day in your >> life." >> >> >> "Bill" <Bill(a)discussions.microsoft.com> wrote in message >> news:6E1FE22D-D0AE-44CD-A648-635869CA55AF(a)microsoft.com... >> > In Access 2007, I have a graph in Design View which shows differently >> > in >> > Form >> > View. In other words, the information that is plotted in the graph >> > shows >> > differently in the two views. Why is this? >> > >> > Thank you, >> > >> > Bill >> >> >> >> . >> |