reports

  1. Y

    VBA: Dynamically update form controls

    Hello, why doesn't this work? I am trying to update several fields on a form, the problem is this: Forms![frm_CreateContract].strField Here is my code: Set db = CurrentDb Set tdf = db.TableDefs("tbl_Adendumn") i = 1 For Each fld In tdf.Fields strField = "ITM_1" & i & "_" & fld.Name...
  2. M

    Pivot report based on two related tables???

    I have two tables, one has the [Sales data] (Customer and Sales Dollars), the other table has [Order Details] (Product line and SKU). Both are related with a 1:1 key. I want a pivot report to show Customer (from sales) in the column, SKU (from orders) in the next column, and Product line...
  3. E

    Splitting one document to many and saving to pdf

    Hey Guys, I was wondering if there is a way to accomplish this in VBA? I have an excel document that I use mail merge to create a bunch of different reports. After completing the mail merge I want to be able to save each individual file as a pdf. Currently I am using this to split the pages...
  4. E

    Accounts Receivable Tracking and Reports

    I just upgraded to Windows 8 and my accounts receivable software is no longer supported by the operating system. I was hoping to create a workbook in Excel that can achieve the same results as my software. I have a list of clients and I.D.'s matched to them that I have already set up into the...
  5. U

    Sequency of IFs not working

    Hello there, I am new at VBA and Access and I was making a DB that needs to print a determined number of different labels depending on the options given. When I use macros it is quite easy to choose the labels and it all works but I found out code that works fairly well and it becomes faster...
  6. K

    Report Showing Primary Keys instead of Names!

    I have a report based on a Query. The Query, when run, displays the Project Names and Task Names. When creating the report (report wizard), Access reverts all the Project and Task Names back to thier primary keys. The report is broken down as such: Project Task Activity Sum...
  7. L

    Excel macro to Generate a new Worksheet with 'Task' wise Report as mentioned below

    I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Example Source table and Target table in attached file. Target: Need a Excel macro to Generate a new Worksheet with 'Task' wise Report as mentioned below...
  8. E

    Automatically Create List/Table from data that changes often

    Hello All Excelions! Here my problem: (cause I'm a TOTAL newbie/excel idiot) I have a client list/table that gets new data each day. I need to create separate lists/tables on new sheets from the main data sheet (ALL) base on certain conditions/criteria... The All sheet has different...
  9. D

    Saving Reports into Different Folders With Different Logos and Title

    I have 40+ reports that I generate weekly for different clients. I have the workbook set up so that each report is in a new sheet/tab and have a macro that runs through and saves each report as a PDF using the file name I desigate in a cell within the sheet. My clients are now wanting the...
  10. P

    Complex data capture for a report

    After watching many youtube videos, I am still stuck on trying to fit the right function/formula into what I am trying to accomplish. I have many worksheets all linked together and giving me great reports, but the last report I need I can not seem to capture the data I need. I need a report...
  11. M

    VLookup

    how do I use VLOOKUP to move whole columns of data from one report to the other.
  12. H

    email integration and report gneration from a spreadsheet

    Hi folks. I'm investigating the possibilities of extending a spreadsheet I've been working on to manage data in a school. I've already completed the first stage of the process, creating the management system on a spreadsheet, but ideally I'd like to generate weekly reports of recent data from...
  13. Y

    Need the specimen copy for MIS or CSC file

    I am often getting this Two name of the Excel funtion books from my friends who are talking regarding the reports generation but i could not see that as it was confidential. Any possibilities from your side??
  14. M

    Either this is too easy or difficult report question

    I have a database with many tables and a manager who likes a weekly report update. My table fields are FT/PT PGCE/CERT and I need to include SITE and STATUS (Status' are ACCEPTED/WITHDRAWN/IN PROCESS) i need a report to show all the fields on one page - not as a list of students and I don't...
  15. M

    Report Problem with Multiple Value Field

    I am stuck with what to do, and may have to create a few tables to fix the problem, but I thought that before I did that I would consult with the experts! I am generating a report based on a query of a table that has three fields that can contain multiple values. For testing purposes, I have 4...
  16. S

    Linking Spreadsheets in Excel 2007

    I have 4 little daily report and 1 master report; I am trying to link them together so that when someone enters a total on the little report it will change the master report, any advice… <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> thx
  17. S

    Access reports, unexpected parameter

    While running a report (one which has several groups, and several subreports) I get one parameter I expect ("Enter ID number you wish to report on") as well as a parameter I did not expect to see. It just says "Catalogue". Which is the name of a table which the main report is based on and the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top