Threads Replies Last Post 253 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>   Display lapsed time in hours and minutes How do I display total lapsed time in hours and minutes if the total lapsed time exceeds 24 hours? (IE: in a report, a lapse of 25:30 will actually show up as 1:30) I am tracking time in minutes per day, but need to know the total number of minutes for the entire year. Help!... 4 05.09.2006 01:19:54 Visible / non visible fields on report Jeff Boyce MVP, put me onto a neat way of hiding or displaying fields on a report, eg If Forms!frmSpecialMakeResults![Frame108] = 2 Then Me![Name3].Visible = False End If This is in the On Format of the report detail. Is there a way to put this in a module because I have 12 reports which have exactly the same coding. CurtainMary... 3 04.09.2006 22:05:02 I am getting duplicate pages in my report. How can I fix this? The data is correct on each page, but I do not want 2 pages with the same data. I have created an invoice, on the invoice - Owner and in the subreport are the owner properties...this data is correct, however if an owner has 2 properties I am getting 2 invoices with both properties on each page.... 11 04.09.2006 22:04:02 Picking out one item from a list Thanks to the excellent help that many of you here have provided, I've managed to fool my boss into believing that I actually know something about Access. But here's something I don't (yet) know how to do. I'm working on an order-processing application. In the spirit of "Imitation is the most sincere form of flattery", I have extensively plagi\\\\\adapted the Northwinds database stru... 7 04.09.2006 20:29:01 Get BOUND VALUE rather than DISPLAYED value I am running a Query that pulls from a FIELD called BANK in a TABLE called ACCOUNT INFORMATION. The field BANK shows the actual name of my selected bank when viewed in the query. In the REPORT ... the BANK Field shows the BOUND VALUE. How do I get the REPORT to actually show the DISPLAYED rather than the BOUND value? Thanks.... 3 04.09.2006 17:03:02 Dr Watsons Error Code 80 I provide the user with a form to enter a from and to date. I use these dates to gather the required information which I store in tempary tables. It is these tables that are used as the row source to create two pie charts which appear as Unbound Object Frames on my report. I have no problem viewing then closing the report when only the two pie charts are on it. The problem I have is w... 1 04.09.2006 16:45:01 Sub-reports Hello, I have one question related to the sub-reports. When I open the sub-report and I go to preview, it looks as I want it to look like, but when I go back into the main report and I go on the preview, it does not look the same any more. Do you know what could be the problem? Thank you in advance! ... 4 04.09.2006 15:24:24 Number of hours in report Hi I have a report with the following fields: Employee number, Client ID, Meeting Date, Meeting Start Time and Meeting End Time. I counted the number of hours using the function Minutes: DateDiff("n",[MeetStartTime],[MeetEndTime]). It works fine but with a slight problem. When an employee meets two Clients on the same day at the same time , it records two as separate hours and this creates... 8 04.09.2006 15:17:40 Report using selection from a form I want to display a report which is coming from a criteria query. I want to give the criteria from a form (combo box selection. for example: company name). I do not know how to build a report which gets a criteria from a form. ... 10 04.09.2006 15:14:30 How can I make charts of *median* Ys for X ranges in my Access DB? My Access 2003 parameter querries calculate price deltas for about 8000 stock prices in two tables of stock prices at different points in time. I am currently using "Top 50%" to find the median percentage increase (or decrease) for each range of values. I want to create a chart that shows the median % price increase for $5-10 stocks increasing in price, the median % price decrease for $5... 1 04.09.2006 15:10:01 Attendance report and cross-tab query BACKGROUND I wrote a database that tracks weekly attendance by person. Tables are: People = details on individuals Attendance = tracks date and whether they attended on that date. All records get either a true or false value. Date = holds the date of the first Sunday of the quarter, this is changed quarterly by the user. The people and attendace tables are linked. I created a r... 4 04.09.2006 15:08:34 How do I use log scale x-axis I have to plot .028 to 8760 on x-scale on a x-y plot. I am tried to use log scal, but it does not work with numbers less than 10. Can you suggest me some way out. I would like the smaller values on the plot curve to show. The values past 24 are basically a straight line with only 2 to 3 values. Thnaks, Nand... 1 04.09.2006 14:50:02 print text upsidedown (-180 deg) in report using Access can we print test message in test box upsidedown in report?? ... 5 04.09.2006 14:26:27 Automatic Select of Format for Email report Hi Is there anyway I can automatically select the format that a report is emailed to someone rather than having to select it every time? Thanks Colin ... 1 04.09.2006 14:00:26 Email single record on a report Hi I have a form and I am wanting to be able to email the current record that is showing, but it's not wanting to play. This is the code I am using. Dim stDocName As String stDocName = "rptnewsletterdatabase" strWhere = "[Reference Number] = " & Me.[Reference Number] DoCmd.SendObject acReport, stDocName, , strWhere Can anyone help me? Thanks Colin ... 3 04.09.2006 13:56:47 Degree Symbol I want to set up an Input Mask in a table for nautical navigation purposes but am unable to find the "DEGREE" symbol. I.e 036* 40'.52 N ( where * should be the degree symbol ) Thanks in advance for any help Simon... 3 04.09.2006 13:47:20 Suppressing Null in Report Hi to you all: I'm a real novice so I hope my question isn't to elementry. I have a query that generates a "1" or Null to summarize data. When I try to build a report I always get the same information twice. I'm assuming that it is because of the nulls. I don't know if any of this makes sense. Help please Billa... 11 04.09.2006 12:51:57 Hide a section based on contents at run-time I have a report with 2 group headers and one detail section: MODULE BUSINESS DETAIL I always have module info, sometimes business info is empty, but the detail section always has data for both. I'd like to supress the business header and the corresponding detail section data when the business group header is empty. Can you recommend the best way to do this either with VBA i... 7 04.09.2006 08:36:01 Can't Filter a Report Hello: I created a checkbook application that goes back several years so it has a lot of transactions. I only want to print transactions within the last 30 days. I put the following script on the command button, however, Access keeps printing every report. Note: Trans_Date is a field in the child table called tblTransactions Private Sub btnrptChecks_Click() On Error GoTo Err_btnrpt... 10 04.09.2006 07:16:02 Parsing from Form to Report I made an Access2003 db containing monitoring results on a set of patients. I want to make reports listing the results, one with names for my persusal and another report with same contents but no names showing. On my form I have an Option button for Names and one for NoNames. At the moment I am using two reports where the Property for Visible = No for the NoNames report. Is there a neater ... 2 04.09.2006 06:49:02 sub-reports page numbering Hello. I hope you can help. I have a report with about 4 subreports in it. No subreports are nested within each other so the report looks like this --main report (grouped on accountID) --subreport1 --subreport2 --subreport3 --subreport4 --end main report All the subreports relate to an account number grouped on the main report. Each sub report can be more then o... 3 04.09.2006 05:50:45 OLE Object Fields in Reports I have a form which I built that contains 3 small object fields, I didn't change the properties at all. I have copied and pasted some jpg files in the fields in the form and the fields are not big enough to show the entire graphic. I then want to put these object fields in a report, but in the report I want the graphics to resize to whatever size they need to be. All I am getting in... 1 03.09.2006 23:15:01 Average values excluding nulls and zeros Hi, I have a report that is based on a query. On the report footer I have a txtAvg (=Avg([HDays]) which is a calculated field in the query that is on the report. This calculated field is based on two date fields (ie number of days between two dates). If one date isn't entered there is no value. What I want to do is have the average of HDays calculated excluding all values that are equal... 3 03.09.2006 21:16:02 Columns and Grouping I have a table of alumni from a high school. I designed a report that lists the alumni by year, 3 columns per page. I cannt figure out how to make it so each year prints on its own page(s). I've played with the grouping, group header, group footer, etc but just cannt get it right. Any suggestions? Thanks -- Joe... 4 03.09.2006 20:04:50 Page Numbers Is there a way to print the page number of the report for that record at the bottom of the page? eg: If the report has 3 pages but there are 50 records each the first page of each record would say 1 of 3, second say 2 of 3 and so on. At the moment I have a 2 page report but when i print them it says 1 of 220 because it is counting all the pages of every record.... 9 03.09.2006 20:01:22 253 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>