| Thread | Last Post | Replies |
|
| Access 2000 (9.0.6926 SP3) and 5160 labels | 14 Jul 2005 05:14 GMT | 2 |
I know there was a bug with 5160 (3 col, 10 row) labels with an earlier version of Access 2000, but can't find anything on this. Imported addresses data from excel into table. Ran Label wizard in Report. Selected Avery 5160 (also happens on 8160) labels. Works fine except I get
|
| How can I add jpgs to Access record so they'll show up in reports | 14 Jul 2005 03:11 GMT | 3 |
I am trying to create a list of people, with their pictures, so that I eventually can create name tags with their pictures in it. How do I add jpgs so that they're in the DB and more importantly that they'll show up in the report? (Every record would have a different picture.)
|
| Help - Creating Time Series Chart | 14 Jul 2005 02:35 GMT | 1 |
OK, first, I am not extensively experienced with Access, so if this i a dumb question, I apologize. I am using Access 2002. Here is m situation, perhaps someone can help I have about 100 towns for which I have mortgage lending data. Thes
|
| How do I add a filter to an existing report | 14 Jul 2005 01:37 GMT | 3 |
I have a report that pulls directly from a variety of tables. I copied this report and want to filter it to only pull certain records. It seems that I can add an expression to the Data Source Filter property, but I can't find any documentaton that says that is how the Filter ...
|
| Repeating field info at top of each page | 13 Jul 2005 23:42 GMT | 5 |
I've created a report showing who's in what building/location. It sorts by building, but I don't know how to get the info in each field to repeat at the top of each page. So if I have 500 people in the "North Tower", the words "North Tower" only appear once, with everyone ...
|
| How do I save an Access report as a picture / screenshot? | 13 Jul 2005 23:26 GMT | 4 |
I've generated a report in Access 2002, and I'd like to use this image as a picture in a powerpoint file (so I don't actually have to take a digital picture of it). I can't seem to save the image as a picture, and screenshots only produce a fuzzy image (obviously not photo ...
|
| First Page Blank | 13 Jul 2005 23:23 GMT | 1 |
A report is printing the page header and the first group header, then is blank. The rest of the report looks fine. I've checked everything I can think of that might cause this. Please help! FYI: There are multiple grouping levels and 2 subreports.
|
| Calculation on Report | 13 Jul 2005 22:43 GMT | 4 |
Hello, I have a main report and several subreports. I am calculating a field from each one of these subreports into an unbound text box on the main report. =[rptPMRentRollTab1BaseRent subreport].[Report].[rentamount]+[rptPMRentRollTab2BaseCAM
|
| Date Heading | 13 Jul 2005 22:42 GMT | 6 |
Right now I have a 2 text boxes. One has "=Format$([Type Start Date],"mmmm d"", ""yyyy",0,0)" for the control source and the other has "=Format$([Type End Date],"mmmm d"", ""yyyy",0,0) for the control source. In between the 2 text boxes I have a label box saying "through". How ...
|
| Difference between 2 dates | 13 Jul 2005 22:39 GMT | 7 |
Right now I have an annual report with a text box that has "=Format$([Type Start Date],"mmmm d"", ""yyyy",0,0) & " through " & Format$([Type End Date],"mmmm d"", ""yyyy",0,0)" for its control source. I would like the difference between the [Type End Date] and [Type Start Date] ...
|
| DLookUp for Memo field | 13 Jul 2005 21:59 GMT | 1 |
I'm creating a catalog of library materials wherein the material description, or [Notes], is a memo field in table [tbl_Material]. Sorting by First in the underlying query [qry_LibraryCatalog] doesn't solve the 255-char chop problem, so I'm trying DLookUp in either the query or ...
|
| How do I print (Qty) of labels of one record | 13 Jul 2005 21:54 GMT | 1 |
I have a sales order form that when you enter a quantity (field name = [Item_Qty]) it needs to print off [Item_Qty] of labels for that particular order. to complicate the problem even more, there can be several diffenet Items on
|
| Need help creating a calendar report | 13 Jul 2005 21:46 GMT | 6 |
I am trying to create a task list calendar... I have a Publish date and want to dynamically create a list of tasks leading up to that date. For example: Sample product is due to publish on August 15th 2005 I want to dynamically
|
| Link | 13 Jul 2005 20:33 GMT | 1 |
Is it possible to have a link within a report that you can click on and it works? Thanks, Joel
|
| Graph based on Report/Crosstab query | 13 Jul 2005 19:02 GMT | 9 |
I have a report based on a query. The report works fine. I guess what I would like to do is to have a graph for each group(Deptname) I want to show the Series by year with the graph showing weeks/$ amt Can you base a graph on the report results? Do you have to do a graph based
|