| Thread | Last Post | Replies |
|
| A bunch of SQL | 21 Sep 2005 08:06 GMT | 1 |
I am not sure if what I am about to ask is the best way to do something or not but here goes... I have a database with survey answers for 22 different questions. Each question was multiple choice with answers ranging from 1 to 5 (there are a
|
| How can I print Access reports with lines? | 21 Sep 2005 02:51 GMT | 1 |
I can not figure out how to put lines in my Access reports.
|
| Reports in MS Access Object Library 11.0 | 21 Sep 2005 01:51 GMT | 2 |
Hello, I am writing an application (C#). I need to get a report (created earlier by a user), possibly unbound, and save it to XML format. Please, tell me how can I do it, using MS Access Object Library.
|
| create a report for each entry in Access DB? | 21 Sep 2005 00:36 GMT | 2 |
I have all of our contracts in the Access DB. I want to create a single report for each entry to conduct contract evaluations. Is there a simple way to accomplish this, or do I have to first create the report once and copy for each additional entry?
|
| Report with multiple records per page | 20 Sep 2005 23:22 GMT | 1 |
I imported an excel file into a table, that now has 1300 records. There are multiple records for each person, i.e. 1. Steven Petrozola, Jazz Park 2. Steven Petrozola, McDonalds
|
| Report with multiple entries per name on each report | 20 Sep 2005 21:57 GMT | 2 |
I need to create a report that has multiple records per page- I would like the report to have their name and multiple referrals per name. How do I do this?
|
| Removing extra spaces from the middle of a text field | 20 Sep 2005 21:17 GMT | 3 |
I have a text field on my report that consists of [FirstName]&" "&[MI]&" "&[LastName]. However, if the person does not have a middle initial, it comes out with two spaces between the first and last names (e.g. "Fred Glutz" instead of "Fred Glutz"). Is there any way in Access ...
|
| Change subreport recordsource in VB | 20 Sep 2005 19:01 GMT | 6 |
I want to run the following to change the recordsource of a subreport. The parameters of firstqtr will change (in reality it is not hard coded). How many things am I missing? Also ,where do I put this? I thought it was in the report open, but ran
|
| Not all records on report | 20 Sep 2005 18:56 GMT | 1 |
I have a report based on a query. The query runs and produces 18 records. The report runs and produces 17 records. The missing records has been identified. It does not have all of the information the other records do, but it needs to appear on the report. The only criteria
|
| more #Error | 20 Sep 2005 18:47 GMT | 3 |
I have a text field [FoodContact] that I want to appear only if it's value is "Yes." I can't seem to work this out. Here's the control source I'm using, however, it returns the dreaded #Error. =IIf([FoodContact]<>"Yes",Null,"")
|
| printing subreport header | 20 Sep 2005 17:22 GMT | 4 |
using a2k i created a main/subreport combination and i would like the subreport to print the column headers. there is only going to be but one record/line printed in the subreport (since it's based on a query which computes/identifies the data for a patient's most recent visit). ...
|
| Control Source | 20 Sep 2005 17:08 GMT | 4 |
Please bear with me I am new to Access I currently have a expression in the Control Source =[Forms]![frmPersExperience]![Combo2] were Combo2 is from a combobox. I keep getting error msg. on report #Name and also I want to place an "X" in another
|
| Incorrect default field width in reports | 20 Sep 2005 17:04 GMT | 1 |
I have a co-worker that is getting started with access. She has a problem that when she creates reports, she always seems to need to adjust the field width of even smallish fields. Is there any system setting that can change that?
|
| Report Detail OnPrint -- Does it occur for each value/page? | 20 Sep 2005 17:02 GMT | 3 |
I am trying to understand a bit more about the OnPrint event of a report detail. Does it occur for each new detail section in a report? In my situation, the report detail is sized so that each value in the
|
| How can I fit all my details in a report | 20 Sep 2005 17:00 GMT | 3 |
How can I fit all my details in a report. The report is based is a form that has boxes around the detail and page breaks. I received an error "The control or subform control is to large for this location". How can I correct this.
|