MSGROUPS.NET | Post Question | About | Groups | Contact | Register | Login



microsoft public excel misc (9093)

microsoft public outlook general (7339)

microsoft public excel programming (6569)

microsoft public word docmanagement (5607)

microsoft public excel worksheet functions (5040)

microsoft public access (4768)

microsoft public windowsxp general (3874)

microsoft public windows vista mail (2957)

microsoft public windows vista general (2783)

microsoft public windows live mail desktop (2699)

microsoft public office misc (2268)

microsoft public access queries (2122)

microsoft public powerpoint (2030)

microsoft public greatplains (1998)

microsoft public windows server sbs (1972)

microsoft public dotnet languages csharp (1964)

microsoft public access formscoding (1932)

microsoft public mac office entourage (1868)

microsoft public sqlserver programming (1861)

microsoft public access forms (1798)

microsoft public internetexplorer general (1706)

microsoft public mac office word (1699)

microsoft public access modulesdaovba (1691)

microsoft public outlook calendaring (1436)

microsoft public dotnet framework aspnet (1375)

microsoft public project server (1356)

microsoft public windowsupdate (1353)

microsoft public sqlserver server (1332)

microsoft public project (1285)

microsoft public excel (1277)

microsoft public access reports (1249)

microsoft public windowsxp help and support (1204)

microsoft public exchange admin (1185)

microsoft public windowsmedia player (1165)

microsoft public mac office excel (1160)

microsoft public windows server general (1100)

microsoft public dataprotectionmanager (1096)

microsoft public outlook (1035)

microsoft public word vba general (1029)

microsoft public vb general discussion (1001)

microsoft public outlook contacts (953)

microsoft public windows server active directory (930)

microsoft public development device drivers (911)

microsoft public dotnet languages vb (843)

microsoft public outlook installation (820)

microsoft public word newusers (808)

microsoft public word pagelayout (783)

microsoft public windowsce platbuilder (757)

microsoft public excel charting (733)

microsoft public publisher (728)

microsoft public excel newusers (711)

microsoft public windows powershell (697)

microsoft public pos (658)

microsoft public vc mfc (651)

microsoft public access gettingstarted (630)

microsoft public word application errors (629)

microsoft public sharepoint general (604)

microsoft public office setup (584)

microsoft public onenote (556)

microsoft public sqlserver reportingsvcs (550)

microsoft public outlookexpress general (539)

microsoft public frontpage client (532)

microsoft public access tablesdbdesign (529)

microsoft public scripting vbscript (528)

microsoft public windows 64bit general (513)

microsoft public outlook program vba (502)

microsoft public windows live messenger (434)

microsoft public windowsxp hardware (416)

microsoft public money (397)

microsoft public windowsxp basics (367)

microsoft public dotnet general (316)

microsoft public windows mediacenter (300)

microsoft public windows inetexplorer ie6 outlookexpress (276)

microsoft public mac office (272)

microsoft public win98 gen discussion (243)

microsoft public sharepoint setup and administration (225)

microsoft public windows vista hardware devices (183)

microsoft public windows vista music pictures video (178)

microsoft public nntp test (163)

microsoft public windows vista performance maintenance (148)

microsoft public dotnet framework (148)

microsoft public visio (128)

microsoft public access 3rdpartyusrgrp (68)

microsoft public access conversion (64)

microsoft public dotnet xml (58)

microsoft public pt windowsxp (38)

microsoft public access developers toolkitode (34)

microsoft public windows live photogallery (32)

microsoft public dotnet faqs (19)

microsoft public dotnet framework aspnet datagridcontrol (16)


microsoft.public.access.reports Post New
Items(1243) /25 Next >> Last >|
Subject Posted Replies From
IIf works in query but not in report

Does the IIf function work differently in queries from the way it works in reports? For example, this works in a query: lastName: IIf([Last]="Smith",Null,([Last])) (I can hid the last name "Smith" in the lastName field.) However, I cannot use the same IIf as a control source in a report. It generates a circular reference error message. = IIf([Last]="Smith",Null,([Last])) (If the name is not "Smith", then print it.) Is this just how IIf works?

6/7/2010 10:30:37 PM 0 =?Utf-8?B?YWs0OQ==?= <a...@discussions.microsoft.com>
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?

6/7/2010 6:36:59 PM 1 =?Utf-8?B?SmFuaWU=?= <Ja...@discussions.microsoft.com>
First Letter of each word

I have the following in a text box field: =IIf([Comp Entered By] Is Null,"",Left([Comp Entered By],1) & Mid([Comp Entered By],InStr(1,[Comp Entered By],",")+2,1)) the field "Comp Entered By" is based off of a lookup table of names. I want the above code to only give me the initials of any given name like: Christian Many would be CM and the above code is giving me Ch. What should I change on the above code? Thanks in advance

6/7/2010 5:48:31 PM 1 =?Utf-8?B?UEo=?= <...@discussions.microsoft.com>
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?

6/7/2010 5:30:42 PM 3 =?Utf-8?B?QWxhc2thMQ==?= <Alas...@discussions.microsoft.com>
Automatically name a report when exporting to PDF

Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, the default file name is the name of the actual report within Access. I've used VBA to change the report caption to match a field on my form called PROGRAM. However, this does not transfer over when I want to save my report to pdf. How can I make it so that when I click export to pdf/xps, the default file name is named after a text box called PROGRAM? Please let me know. Thanks

6/7/2010 4:17:19 PM 1 shm135 <shmou...@gmail.com>
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"

6/7/2010 3:28:21 PM 1 "arathra" <u60...@uwe>
PageSetup properties keep changing

Hello All I recently had some mdb corruption problems, that I THINK I've solved - by creating a new mdb and importing all objects. A new problem has now started that is either coincidental or is somehow related to my having done the mdb rebuild. The page setup properties of various reports changes, periodically, 'by iteslf'! I have been able to repeat this behaviour to some extent: 1. preview report - discover that the page setup properties are completely wrong 2. close the report 3. select the report in the main database window, go File>Page Setup, correct the properties 4.

6/7/2010 1:39:33 PM 2 "PayeDoc" <enquir...@gppayroll.org.uk>
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?

6/7/2010 1:58:45 AM 1 =?Utf-8?B?TGlhbTAzNjQ=?= <Liam0...@discussions.microsoft.com>
Trying to calculate difference between two times in an access repo

I am trying to calculate the difference between two times in an access report and don't know what the correct expression is. My report has a column of "Start" and "End" that has the start time of the project and the end time of the project. I need the difference between the 2 so I created an expression for "Total production time" - =timediff("h",[end],[start]) but a box keeps appearing when I try to view the report which means I have an error and I don't know where I went wrong

6/6/2010 6:26:46 PM 2 =?Utf-8?B?amFja2ll?= <jac...@discussions.microsoft.com>
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

6/6/2010 9:42:08 AM 1 =?Utf-8?B?cGluY2hpbjE=?= <pinch...@discussions.microsoft.com>
actualizaciones automaticas

ola jordy

6/6/2010 7:41:14 AM 0 =?Utf-8?B?b2xhIGpvcmR5?= <ola jo...@discussions.microsoft.com>
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

6/4/2010 10:18:44 PM 3 =?Utf-8?B?R29sZGFy?= <Gol...@discussions.microsoft.com>
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

6/4/2010 9:38:29 AM 0 money mania <texaspes...@gmail.com>
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

6/4/2010 9:37:34 AM 0 money mania <texaspes...@gmail.com>
filrter several reports

I create an unbound form to filter a report and i paste the following code in the filter button of the form, and it works perfectly; but my problem is that I need to build this filter to most of my reports so what I don´t want is to create a form of this type for each report. My question is: Is There an easy way to use this form to all these reports? Thank you in anticipation Private Sub cmdSearch_Click() Dim varWhere As Variant Dim rst As DAO.Recordset ' Initialize to Null varWhere = Null ' OK, start building the filter If Not IsNothing(Me.

6/3/2010 6:51:42 PM 2 "JOSELUIS via AccessMonster.com" <u58...@uwe>
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...

6/3/2010 5:31:08 PM 10 =?Utf-8?B?S0c=?= <...@discussions.microsoft.com>
Report only displaying some info

Background first: I have a database for tracking contracts. Some contracts are straightforward and only cover one service but the bulk cover multiple services that will be performed at different times. I have the following tables: Customer Contract ContractLine Services Under each Contract, if it has multiple services I connect the Contract and the ContractLine tables. Now to my issue....I need a report that will display all Contracts whether it contains multiple services or not. I have been able to run a report where it will display all the contracts with mult

6/3/2010 5:17:05 PM 1 =?Utf-8?B?SmVu?= <...@discussions.microsoft.com>
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.

6/3/2010 3:59:54 PM 1 =?Utf-8?B?QW5u?= <...@discussions.microsoft.com>
Need Specific Data

I want to be able to count data in a field in my database. The field is called ATTENDANCE. Under attendance are options like ATTENDED and REFUSED and SICK etc. I want to sum up all of a persons attendance on a report to show they attended 6 classes, refused 2 classes, etc. It seems this should be a lot easier than I'm making it out to be.

6/3/2010 2:27:56 PM 3 =?Utf-8?B?TnVyc2UgTWF0dGhldw==?= <NurseMatt...@discussions.microsoft.com>
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

6/3/2010 7:07:49 AM 2 =?Utf-8?B?WmlrYXI=?= <Zi...@discussions.microsoft.com>
Printing a report 2-up

How do I go about creating a report that retrieves data from my table and produces a report of that data 2-up (side by side). ! record on the left and the next record on the right? -- Thank you for your help.

6/2/2010 10:47:37 PM 3 =?Utf-8?B?QmlsbA==?= <B...@discussions.microsoft.com>
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

6/2/2010 9:02:39 PM 0 grupy <gr...@domain-xyz.in>
Count funtion in report-I'm too rusty!

I know this is simple, but I'm rusty and haven't worked with 2007 yet, so it's looking a bit foreign, too. I am trying to do a VERY simple report that shows by state how many people reponded to what questions. The data I have comes from a survey where people had to select one of four answers to a question (let's say "yes", "maybe", "no", or "N/a"). So I have those four fields in each record, but only one of them is "checked". I did a query to pull only those fields I need for the report: State, ID#(which is my problem somehow..) and the four fields above. When I build the repo

6/2/2010 8:03:13 PM 1 =?Utf-8?B?S01N?= <...@discussions.microsoft.com>
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

6/2/2010 7:08:04 PM 1 =?Utf-8?B?Q2hyaXN0aW5h?= <Christ...@discussions.microsoft.com>
Display multiple records from same ControlSource

I am trying to display multiple records in one text box on a report. I can get it to work if I put the text box in the "Details" section of the report, but I need it to be displayed at the bottom of the report. Is there a way to move the "Details" Section to the bottom of the report? Is there a way to get more than one resord to be displayed in one text box? Thanks like always for the help... -H-

6/2/2010 5:43:43 PM 1 =?Utf-8?B?U3VtbWl0U2Vla2Vy?= <SummitSee...@discussions.microsoft.com>
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

6/2/2010 5:43:42 PM 1 =?Utf-8?B?TWljaGFlbCBPIG5lZWRzIHlvdQ==?= <Michael O needs ...@discussions.microsoft.com>
Report formatting hangs

I have a report (rptHV) that uses a query (qryHV) as its record source. The user opens a form (frmHVClient), chooses a name from a combo box, and then clicks a command button (cmdClient) to run the report. The report works fine as long as certain client names are not chosen. If those certain client names are chosen, a progress bar appears in the status area with the message, "Formatting report - press ctrl + Break to stop..." and the report hangs and never formats at all. Coincidentally (or not) the clients that cause the issue are all assigned to the same staff member. I'v

6/2/2010 5:23:07 PM 3 =?Utf-8?B?VGFyYQ==?= <T...@discussions.microsoft.com>
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

6/2/2010 4:36:18 PM 2 =?Utf-8?B?U3VtbWl0U2Vla2Vy?= <SummitSee...@discussions.microsoft.com>
Colored Flags

I would like to print a red,yellow or green flag based on the value of another field. I'd like to use the flags in the Excel 2007 icon set. Is there a way to import these images into Access?

6/2/2010 3:50:01 PM 0 =?Utf-8?B?Q0M=?= <...@discussions.microsoft.com>
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

6/2/2010 11:47:01 AM 5 =?Utf-8?B?UGVkcm8=?= <Pe...@discussions.microsoft.com>
Error in totals when no data in subreport

Good Evening: I have a report ("Invoice") which has 2 subreports, one for parts and the other for labor. When either has no data the calculations for totals on the main report show #error. I am having difficulty making the data from the offending subreport zero (0). Any ideas as to how to force the situation when no data exists in the particular subreport? Thanks much for reading this. Barry

6/2/2010 1:48:01 AM 1 =?Utf-8?B?QmFycnk=?= <Ba...@discussions.microsoft.com>
me

-- shirly

6/1/2010 11:29:06 PM 0 "shirly" <safiro_...@msn.com>
blank subreports appearing on every record of report

I have a report with many records, and only on a few records there will be a subreport displayed. This works fine, except that a little sliver of the subreport shows up on every record of the report. Each little sliver is blank, but adds a bit of height to each row, and generally looks ugly. I've set all of the 'Can Shrink' properties to yes, including the various sections, controls, and subreport reference on the main report. All the header & footer sections are zeroed out. Isn't this what the 'Filter On Empty Master' property is supposed to do? It has no effect. Thanks in

6/1/2010 8:01:01 PM 0 =?Utf-8?B?YmljeWNsb3Bz?= <bicycl...@discussions.microsoft.com>
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!

6/1/2010 5:05:01 PM 1 =?Utf-8?B?TXMuIE15?= <Ms. ...@discussions.microsoft.com>
Subreport Keeps Repeating Itself

Hello, I am having a problem with a report. I am trying to print out paystubs for employees over a given time period. I have a start up form in which the user types in the “StartDate” and the “EndDate” of the pay period which is 2 weeks. I need to be able to calculate the regular/overtime hours for each week so I created two queries, “qryPayrollWeek1” and “qryPayrollWeek2”. Each of these queries contains the same fields: Operator/DateWorked/HoursWorked/RegularHours(Calculated Field)/OvertimeHours (Calculated Field). Both of these queries work great. When I type in a StartDate a

6/1/2010 4:52:04 AM 6 "Joel_123 via AccessMonster.com" <u59...@uwe>
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.

5/31/2010 5:36:01 AM 0 =?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
Resource For Help With Access

I provide help with Access applications. I specialize in designing the tables for a new database and fixing problems and adding new functionality in existing databases. My fee could be as low as ten dollars. If you need help and can no longer connect to a newsgroup, I can help you. Contact me at my email address below. Steve santus@penn.com

5/30/2010 7:03:59 PM 13 "Steve" <notmyem...@address.com>
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

5/29/2010 3:06:01 PM 1 =?Utf-8?B?TS5L?= <...@discussions.microsoft.com>
output to pdf-select pages

i have a 3 page report in ms access. for one audience, the third page is not needed, but for another audience it is needed. what is the best way to accomplish this using the 3 page report template 1) is it possible to generate pdf of just the first two pages....docmd.outputto. etc. (i dont think so, but might as well check) 2) i am at a lost as how to delete via vba code at runtime delete my pagebreak and subreport. many thanks ken

5/29/2010 12:15:01 PM 0 =?Utf-8?B?a2Vu?= <...@discussions.microsoft.com>
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

5/29/2010 7:02:01 AM 0 =?Utf-8?B?dWxyaWNoMTk0Nw==?= <ulrich1...@discussions.microsoft.com>
Printing report with many fields

Hi guys, I am printing a page legal size, is not a regular report where the data is shown 1 line after the other, I have around 40 fields, I will spread those fields over the report in around 15 different lines, I will print maximum 5 records in a page, but not all the fields holds data, this means that I need to maximize the space, example: if I there is 1 field or a couple of fields with no data I need to move the next field with data to this space even if the field is located in another line. I will really appreciated any help

5/28/2010 8:30:01 PM 0 =?Utf-8?B?TWFyYWNheQ==?= <Mara...@discussions.microsoft.com>
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

5/28/2010 4:49:01 PM 10 =?Utf-8?B?c2Ft?= <...@discussions.microsoft.com>
Count in a report

Hi, I have a report in Access 2003. The fields are Requestor, Mod and WD. I need a total for all the patients seen by the requestor and to display only the ones that meet the Mod or WD criteria. I can get the report to display the Mod and WD but am having some difficulty getting the total count to work. Thanks,

5/28/2010 3:57:01 PM 2 =?Utf-8?B?U3RldmU=?= <St...@discussions.microsoft.com>
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

5/28/2010 3:52:19 AM 1 "Chris75 via AccessMonster.com" <u54...@uwe>
Strange page breaks in report

I am building a report that is designed to give organization by organization answers to a survey that we did. We want to be able to have sheets that show the answers given in a survey for each organzation. THe report designe seems simple. I have it grouped by organization# and then a large detail section that has each of the questions and the answers give to each. The strange thing is that there is a page break after/before one question even thought it's only part way down the page and other questions and answers run into the page header and page footer. I've gone through the pro

5/27/2010 10:02:13 PM 0 =?Utf-8?B?S01N?= <...@discussions.microsoft.com>
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

5/27/2010 9:48:56 PM 0 =?Utf-8?B?anVidQ==?= <j...@discussions.microsoft.com>
How to make detail section expand/contract relative to number of l

My report contains various numbers of lines in the detail section, but the report is always the same length. How to make it shrink/expand as needed.

5/27/2010 9:41:39 PM 0 =?Utf-8?B?RG9nbWFEb3Q=?= <Dogma...@discussions.microsoft.com>
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

5/27/2010 9:40:08 PM 2 =?Utf-8?B?U1NpMzA4?= <SSi...@discussions.microsoft.com>
Print A Report to an IP Address

Is there a way to print a report to a specific IP Address? I am using Access 2003. Thanks. -- M. Shipp

5/27/2010 9:36:41 PM 1 =?Utf-8?B?U0hJUFA=?= <SH...@discussions.microsoft.com>
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

5/27/2010 9:28:47 PM 0 =?Utf-8?B?S01N?= <...@discussions.microsoft.com>

Pages: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25









Newest Articles

pagefile necessary?
24 min. 16 sec. ago

Hi,ICopiedSomeTextAndPhotosFromAWebsite+PastedThemInAnEmailFromThi
1 hour 37 mins ago

Recover Format 400GB External Hardive
2 hour 33 mins ago

KEVIN J0HN PANNZKE WON the BATTLE
3 hour 16 mins ago

Cross apply from function not working
3 hour 59 mins ago