email recipient address shows twice I have managed to use sendobject to email a report as an attachement and populate the "email to" address however on the email to address shows twice- once as a normal email address and then as that email address enclosed in the hash signs. bobwarden(a)bigpond.com.au#mailto:bobwarden(a)bigpond.com.au# Any help appre... 24 May 2010 09:02
Updating Form==>Query==>Report I have a date form. It has 2 text boxes that pass starting and ending dates to a query to pull appts from that time period. If the report is left open and the dates change in the date from, I have to manually refresh the report. Is there a way that when I click off of the 2nd text box (ending date on date fo... 23 May 2010 20:09
Bound Chart in Report Issues - Access 2007 I have a simple table, containing a count, a status and an agent name. I created a simple report, with a header by agent name. The idea is that the report will display as: Agent Name: Joe Blow Simple bar chart - Horizontal Access Shows Status - In Progress, Complete, Not Started The value will be the count ... 24 May 2010 07:58
Auto-generated Report I have a form with a command button. If the EndUser clicks the button a report [rptUTILITIES] is generated and saved to the hard drive and the EndUser moves to the next form without even knowing the report was generated and saved. How would I code this? Let me thank you ahead of time. Thank you. ... 22 May 2010 20:23
linking queries to create a report is it possible to link queries to create a report? if so how would i do this? ... 22 May 2010 14:57
Calculate beginning balance, but print details on report Hi, I'm using Access from XP Office Pro running under Windows 7. Background ------------------------------------------- I'm trying to implement a simple check book tracking report (like that little book that goes in a personal check book). The check book report can be run for: 1. All months 2. Multi... 22 May 2010 19:18
Format duplicate date in report Hi Groupies How can I use conditional formatting to format a duplicate date in a report? I need the duplicates to show up but I would like them to be obvious. -- Thanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! ... 21 May 2010 23:49
Pie chart troubles I've inherited a DB in Access 2003 and I am trying create a query that will create a pie chart. One table lists [RegularHours Worked] and [OTHoursWorked] by [InputDate]. There is a Separate field called [Activity] which is related to an "Activity" table where a [Category] field exists. I need a pie chart by [C... 26 May 2010 14:43
Modifying legend on graph on report I have a bar graph which displays workers by widgets by months. X axis = Months Y axis = quantity of widgets Bars = worker names The report *must display every month* regardless of whether anyone produced any widgets so my data looks like this after an outer join between a table containing all the months is ... 19 May 2010 23:47
Report using Fields with the same name from different tables Hello all - I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. What is the be... 19 May 2010 14:55 |