Threads Replies Last Post 253 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   One combo box controls another How can i have a combo box values change depending on the selection of another combo box... 3 18.08.2006 20:56:02 ???? I have an access database with a label report. On an xp machine the report comes out fine. When the database is on a ME machine is displays ??? any ideas of what is missing or wrong? Dale ... 1 18.08.2006 20:33:34 Prompt for alternate field name I have a field that is being used for two possible values, bond or contingency. If its being used for bond, I'd like the field name to read Bond and contingency when its being used for contingency, is this possible? -- Lori A. Pong... 3 18.08.2006 20:30:02 Multiple Columns in Subreport Greeting all, I'm having an issue printing multiple columns in a subreport. I have read all the other posts and I think I have the reports set up correctly (obviously not). I have a main report that is grouped on LIN (number). I'm printing the LIN and Description in the LIN group header. I have a subreport that prints (is supposed to) serial #'s in 2 columns in the detail section of ... 18 18.08.2006 19:59:12 Report previews behind form I have a button on a form that opens another form that contains a list of reports that can be printed. If I select a report and pick PREVIEW, the report appears but it appears behind the original form. I want the report to appear in front of the original form and not at full size. I do not want the original form closed though. After I preview the report and close it, I want the origin... 2 18.08.2006 16:18:39 Hide / Don't hide Decimal Places on reports. I have a report which is based on a complex query which using groups, sum, expressions etc. On my report I have a field which shows an integer, decimal place and decimal i.e. 312.44 64.00 123.00 122.22 .. What I would like to do is only show the decimal places if they are greater than zero, i.e. 312.44 64 123 122.22 Can this be done?... 3 18.08.2006 16:15:12 Generating Information from Multiple Tables I have two tables: Customers - table has main biz information, the main table MerchantInfo - table has a relationship to Customers using CustomerID. It has owner's info, as there could be multiple owners per one "Customers" record. My question is when you run a report for example and want to embed information into the report from the MerchantInfo table, like say DEAR MERCHANT, etc.... 1 18.08.2006 15:53:25 Need advice on how to format reports I have structured tables to track and calculate StoreDetective schedules, but now I have to make sure I can easily pull the following reports: StoreDetective schedules by FieldManager (5 Field Managers) StoreDetective schedules by Store (100 stores) StoreDetective schedules by District Manager (10 District Managers) StoreDetective schedules by StoreDetective (100 detectives) Any suggest... 1 18.08.2006 15:47:05 Report for all records with end date greater than today I am trying to pull up a report that will filter out any records where a data field, Date_End, is less than the current date. The user will enter information and indication a start date and end for the record. I want to be able to generate a daily report with all records where the current date falls between the start and end date the user entered. I figured the easiest way to do this ... 3 18.08.2006 15:33:33 Running sum with IIF ?? Hi Groupies! I have a report that requires a running sum based on the contents of another field......... My report is sales grouped by customer per month. For this simplified example lets say that we only sell either shoes or socks. The report is set up as shown below: MONTH HEADER August CUSTOMER HEADER ABC Company DEPARTMENT HEADER Shoes DETAIL ... 3 18.08.2006 14:55:57 How to sort by a field which contains "Count(*)" values? Dear pros, I have a report with 2 group levels. I need to sort descending within 2nd group by a field named "tgr" which contains [=Count(*)] values. Help please! Ladi ... 6 18.08.2006 14:55:04 formatting a data chart in a bar graph in Access? I have a bar chart set up in Access with a data chart. How do I format the data chart to show percentages and "%" instead of just raw data. I want to show 2.45%, not .0245. -- Thanks for your help... 5 18.08.2006 14:38:42 field within label Hi, I have a field called "Bearing from [Daughter Site] to Parent Site:" Each record is based on Sites. I would like the report to populate the [Daughter Site] with the current site name within that label. Can this be done? Example: Record 1 Site Name: Auckland Label: Bearing from Auckland to Parent Site: Record 2 Site Name: Wellington Label: Bearing from Wellington to P... 5 18.08.2006 14:38:20 How do I put multuple columns in a report Hello I am trying to create a report to look something like the below Balances EUR GBP USD JPY Broker 1 10.00 20.00 10.00 200.00 Broker 2 15.00 10.00 10.00 100.00 Sub TOTAL 35.00 30.00 20.00 300.00 A/c Bal 35.00 28.00 ... 2 18.08.2006 14:35:05 Hiding Controls I have a report that I would like to hide the lines and logos on (to print to a pre-printed report) I tried the On Print Event but it tells me that the object does not support the property or method. I tried the .Visible = False in the On Print Expression but that hides it in regular view as well. Any suggestions? TIA... 3 18.08.2006 14:32:14 how do i creat a report from Form Hi i have a Form with 2 commands ok and cancel, when i say ok it runs my query and display the results. The query is a crosstab query. When i tried to create a report to give a better look by using wizard the 'Available Fields' the left hand box (when selected the query), where usually you can pick some of the output headings to be diplayed in the report.....is showing nothing, it is just ... 3 18.08.2006 14:02:36 #Error Message in Report The query parameters correctly return no records. The report that is run based on this query returns #Error in the report controls. What is syntax to use so that when the query correctly returns no records a Zero is displayed in the report instead of #Error. Thank you for your help on this. ... 6 18.08.2006 13:58:12 Displaying Yes fields but not NO I hope you can help, Ive looked through the forum but i seem to be a bit stuck as i cant find anything that seems to fix the problem: I have a table which has several fields with a "yes/no" data type. I want to run a report which displays only the fields marked "yes" and ignore/blank out any fields marked "no" Can anyone help?... 5 18.08.2006 13:53:49 Field Repeated on second page I have a report which I made sure all the fields fit onto one sheet. However when i preview and print the report although the report seems fine it has a second sheet which contains one of my text fields again. My report width is set so it comes in just under the page width, and even when i move the field away from the edge it is still repeated on second page. any ideas why? thanks, J... 1 18.08.2006 11:24:02 Report to only pick up relevant worksheet subforms I have a Project table with an auto-number project ID used as PK in relationships. I have 16 worksheet tables which all have the project ID as a FK. A project might use Worksheet 1,4 and 7 while another project might use 16 and 12. How do I build a single project report that for an individual project picks up on and adds in (subforms) Forms 1,4 and 7 but ignores the rest. Do I need a query... 5 18.08.2006 10:42:05 How can i print off Access database when says open report cancele. Hi I'm am using Access database for our company,I would like to print my invoice off but i'm unable to do it as i have a note pop up ' The Open report action was canceled. Please could you help me solve this problem. Thanks. Looking forward too hearing from you.... 2 18.08.2006 09:22:41 view Report with all accounts Hi there, I have a report that when run prompts me enter the name of the account (this is default of query), so only the one account appears in the report. Is there somewhere in the report design i can over ride this so i can view all accounts in the one report? e.g can i enter all the account names in a field so they all appear on the report? Or can this be done from a Form? Many thanks... 4 18.08.2006 04:27:05 Query only returns Colum headings? This is probably a simple fix, but not sure how. I have a querey that searches 1 field from 4 seperate tables (don't ask, its the only way to get it to work). If one of the fields doesn't from the orginial table doesn't have any data, it returns the colum headers only. how do I "trick" the query to return even a null value or a zero. This query is tied to a graph/chart. The grap... 2 18.08.2006 03:10:13 disable print in A2003 We have a report that we want to display on the screen but users should not be able to print anything. I have fixed the menu and toolbar to prevent printing, but how do I prevent the Windows print function CtrP from inside Access? I made in the past a point to educate our users to use CtrP if they lose the print icon on the toolbar (computers not restarted for a long time has created th... 4 18.08.2006 01:24:03 Crosstab I recently researched how to make dynamic crosstab reports, and settled on a solution by Duane Hookum. However, the solution was written in Access97 format, and I seem to be running across a small snag. When I try to compile the database I get an error: "Method or data member not found", and the line ..Edit is flagged. I can give more information if necessary, but figured I'd k... 4 17.08.2006 20:46:17 253 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>