Invalid Sheet Name on Export

When I export a report from Access to Excel via DoCmd.OutputTo I get an error from Excel saying Invalid Sheet Name. What can be causing this and how I do to keep this error from happening?

Crosstab Graph Report not showing Parameters in text box

I have a report using a crosstab query in a graph. The query is asking for parameters. When I try to pass the parameters to a text box on the graph they will not pass through. I am building it in text box in an expression. Any suggestions?

stLinkcriteria no longer working (since 2007 upgrade)

We have just upgraded to 2007 and are having a few minor problems. I've seen similar threads online but can't find the solution exactly for us. If I open a report then it shows the report with ALL the records. If I open it with a button with this code, it shows ALL the records: Dim stDocName As String stDocName = "rCertificate" DoCmd.OpenReport stDocName, acPreview However, the moment I add stLinkcriteria it fails. This used to work under the old Access but simply won't work now, i.e. NO records show up: Dim stDocName As String stDocName = "rCertificate"

easiest way to create gridlines in an Access 2003 report

Does anyone know an easy way to create gridlines in an Access 2003 report so that it resembles a spreadsheet, other than manually drawing vertical and horizontal lines?

Access report date problem.

I have created a lot of graphs to show various information. The problem I'm having is that I need the graphs to show the last 14 days of data. The criteria I have used is >Now()-15. This seems to work fine until it comes to the end of the month and then it will not cross over into the next month untill it has 14 days for that month instead of, say, 23/5/10 - 6/5/10. it only shows up to 31st. Any help would be greatly appreciated. Thanks

Prevent skip to new page after last page prints

I have a page header section, a group header section, a group footer section and a page footer section on my report. The group header I am trying to use separates groups of records and skips to a new page after each group prints (the page break is in the group footer). My problem is where to put the page break so that it doesn't skip to a new page after the last group has printed. Any help? Thanks

PLAY CAR RACE GAMES

PLAY CAR RACE GAMES:- PLAY CAR RACE GAMES ON MY WEB SITE AND ENJOY UR MIND FRESH AND U CAN DOWN LOAD ALSO MY GAMES VISIT http://andhraonlinegames.blogspot.com

Firstname plus Middlename??

Apologies if this is a silly question. I'm trying to combine Lastname, Firstname Middlename in a report. I have =([surname]+", "+[firstname]+" "+[middlename]). The only time it works is if all three fields contain values. As the majority of players don't have middle names in the database, most of the report is blank. Can anyone tell me what I'm doing wrong? Thanks so much for your help. Kind regards...

Opening Report Closes Database

I have a report with a subreport that closes the database every time I try to Preview it or open it in Design View. The subreport will also do this if I try to open it independently. The queries work fine. The report wasn't doing this for the last couple of days, then this morning it started doing it if the window was maximized. If I clicked to restore the view to a smaller size and then closed the report this didn't happen. Now it happens every time. I have tried to compact and repair with no luck. Is there anything I can do besides recreate these? Thanks in advance.

Merge a field data for all records in a table into one output

Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the output of one specific selected record. Example, I have 10 period records in a table with (Field D) that contains data but not necessarily for all of the 10 periods. I would want to print the output of any specific period record which generates the data of all the fields for that record with exception of (Field D) which I want to output its merged data that comprises the data of the selected period record plus all the da

Creating a Report using Tables (that have no relationships)

Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp

Create Categories

I have data in a table which I imported from a Survey Monkey excel file. I have begun to create a report (in design view) using the fields from this table. My problem is I don't know how to separate (or group) the fields by category based on the data I have in the table. Each question in the survey is one of the fields in the Access table. Unfortunately, there is no way to tell what fields belong to which category based on the data in the table. The survey had 37 questions which were grouped by category: Professionalism - 6 questions Quality of Work - 10 questions Contribution

Highlighting a word when it shows up on a report

Hello experts. This may be wishful thinking, but can access do the following: Potential scenario... lets say I have a table with 5 fields and the data in each field is at least an entire sentence (excluding a PK). I run a report that displays each of the 5 fields and the data in each. The record source of this report is a select query that finds all the records Where [FieldName] LIKE "*Some Word*". For example, say the word is "ship". This report will find all the records where "ship" appears in any of those fields. My question is...is there a way in Access to have "sh

Multiple Queries...?

Hello all... This question may be in the wrong place and sorry if so... This delima throwing me for a loop and any help is appreciated. Our clients make multiple payments for the same order. They may make a deposit with a Check then pay the balance with a Credit Card. I am trying to make a section on the invoice that shows the date of each payment and the last 3 digits of the card used or the check number. I have a querie that finds all records in the "Payments" table with the same "OrderID". How can i make a section on the Invoice that will display ony the payments f

Report made of a query cross table

Hi everyone It must be very simple for you guys but i can't find it: How to make a report, made of a query cross table, but only show records that the total of all months are diferent than zero (0). Negative and positive values. That report sums the sales for each person, each months and i want to know who sell and who's not selling. Tks in advance Pedro

me

-- shirly

Same graph, different data for each record

I have a database with several hundred providers. My report displays correctly on each page for each provider; however when I try to add a graph, it doesn't refresh on every page with each provider's information. I have one graph on the first page that totals all the data for all providers. Please help!

Allen Browne's Has the Rcd been Printed - Taking it further

Hi, I'm using Allen Browne's code from Has the Rcd been Printed and all of that is working great. I'm now trying to implement the Taking it Further - Track each time a record is printed. (This has been cross posted to queries. I only did this because there is only one day left on this forum.) I am trying to write an SQL statement that will Copy the keys from member table to member print audit table and set a value in the member print audit table. Here is SQL like statement that I want to do: INSERT INTO tblBatchMember (AcctNo, SET BatchID = 999) SELECT qryMemberRpt.

report in access (Count)

If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH Sunday ABCD Saturday MMM Friday ABCD Monday EFGH Monday I want report show like Saturday Sunday Monday Tuesday Wednesday Thursday Friday ABCD 3 0 1 0 0 0 0 EFGH 0 1 1 0 0

Subtotal in pagefooter deriving from a subreport

Hi everybody using a report for invoicing. Detail section contains a subreport in which i accumulate certain field (price, qty, result of qty * price) overGroup and in another textbox overAll, e. g. "AmountSum" for subtotalling per page i use in the pagefooter another textbox with "=SubReport!AmountSum" as controlsource. the problem i have is, that in the pagefooter is not shown the true total of the page (which shows up properly in the Detail Section - if i display it) but the true total of the page PLUS the value of the first line of the following page. (Example: accumul

PLEASE HELP: Refresh columns displayed in a report from a query ou

Hi All, I have a report whose record source is a query, the query consists of dynamic Select and Where clause and so the columns are user driven (based on what user selects on a form) I am able to display the data to the report, however I am not able to refresh the columns in the report, For eg: My SQL is: strSQL = Select Student_Id, Student_FName, Student_LName & strSelect1 & strSelect2 & strSelect3 FROM Students_Table WHRE strWhere1, strWhere2, strWhere3 Now, I am able to display the specific columns in the query based on what users select in addition with Studen

Multiple

Hello, Within a report, I have a textbox called Absence. This textbox gives me a list of five possible absences (present, sick, vacation, training and stat holiday). Within this report, I am able to get the total of each absence for a period of time. However, I would like to divide only two of these individual totals by five (present and vacation). Present has an AbsenceID value of 1 and Vacation has an AbsenceID value of 3. Right now, to get the totals, I have a text box called Count *. This gives the total count for each absence in the period I have selected. I also have a

Business card formatting problems

I posted an earlier question, but perhaps my subject was too confusing to know what I am requesting, so I am trying to re-word it. I have an Access 2007 database that stores training records for a number of employees. We would like to use a business card size report with the employee name and the list of training topics for that employee. I am having trouble getting it to format correctly for people who have more than 8 training records (using very small font). We would like the "overflow" to print on a second card which will later be laminated to the first. The second card

Entering Report Parameters through a Form

I created a form called frmWeeklyReport and added 2 unbound text boxes one for start date and one for end date. There is also a button that is set to run the report. I open the form, enter the dates and click the button. I then get an Enter Parameter Value dialog box Start Date and End Date. My Report includes a main report and a subreport each based on different queries. I think I know where to look for the error, but am not sure what to look for. When running each query directly, with the form open and the dates filled in, the first query is fine, but the second query is pr

Unwanted page breaks in detail section of report

I'm not sure how to describe this. I am trying to create a report that lists the organization by organization results of a survey we did. We want to be able to print out the answers to the questions asked so reps can look up the organization and see their needs, etc. I just have it grouped by the org# and then a big detail section of all the questions and answers. In the detail section, the page is breaking after a particular question and answer even though it is only about half way down the page. And a few of the other questions and answers run into the page footer and page h