Results 1 to 2 of 2
  1. #1
    schurst30 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    1

    Populate multiple eXcel documents using a database: is this possible?

    Hi All,



    I have a very simple process which I carry out numerous times per day, every day. I generate an order with an eXcel spreadsheet (order num, job code, material code, date, value, required delivery date, description) and send that order out. Depending on what is ordered (either a plant item, or some materials) means that a summary of that order gets transferred to 1 of 2 other spreadsheets (a plant control spreadsheet, or a material control spreadsheet). All of this takes a lot of time, some of it repetitive which is wasteful.

    I have an idea to save time and be more efficient but just don't know how to implement it or even if it's possible. What I want to be able to do is:

    - Open a database file, select a 'live project' from a drop down menu & press a "raise order" button.
    - New screen pops up where I can insert the necessary mandatory details for the order against that particular job (each time with a unique job reference number)
    - Press generate order once complete, this would then transfer the data input into the fields onto an excel spreadsheet (like a template with company logo on etc) and save it into the correct folder on the server based on what job was selected at the start.
    - At the same time the order is generate the relevant control spreadsheet (material or plant) gets populated with the necessary details (this would be a single row of the document each time an order gets raised - but the document could only ever be updated and not a new document created each time as we need to see how the orders develop throughout the course of the job).

    Is the above achievable? Is it difficult to do or would there be extensive programming required?

    Your thoughts/assistance would be most appreciated.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it is achievable but you need to be a reasonably competent coder.

    The data is not the issue (you can use the transfer spreadsheet function), its the formatting of the excel spreadsheet where the skill is needed - but easiest way is in excel record a macro to format as required, then copy the resultant macro code to an access vba module. You will need to make a number of changes but it will give you the bones of the code

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to print off multiple word documents
    By Ajz1971 in forum Access
    Replies: 10
    Last Post: 01-20-2017, 07:57 AM
  2. Mail Merge Multiple Documents At Once, Albert Kallal
    By David92595 in forum Programming
    Replies: 3
    Last Post: 02-05-2013, 05:25 PM
  3. How do I populate documents using forms?
    By animalcollective in forum Access
    Replies: 1
    Last Post: 05-11-2012, 02:50 PM
  4. adding images & documents to database
    By ksosnick in forum Database Design
    Replies: 2
    Last Post: 10-26-2011, 01:48 PM
  5. Multiple Mailmerge documents
    By sabbo64 in forum Access
    Replies: 0
    Last Post: 09-05-2009, 04:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums