Results 1 to 4 of 4
  1. #1
    LadyKarenna is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2017
    Posts
    2

    Design shedule worksheet

    I receive orders for plants months in advance. For example November week 47 2017. These plants start as little babes in October 2016 and need to be chopped up numerous times (ie 100 plants will eventually make 10 000 in a year). Each plant variety takes different interval timeframes ie 4 weeks for some and 6 weeks for others.

    To make life extra interesting there are four stages - Initiation which are the original 100 plants - Multiplication which recycles on the time intervals until numbers are reached - Rooting - when growing hormones are relpaced with rooting hormones before exiting to the greenhouse - Storage, which is where extras are placed on nutrient media only in the coolroom

    How do I

    Write code so that a sequence of steps can be communicated to a weekly worksheet for instance nutrient media made, x plants cut up



    Recalculate the process if an order appears in the system part way through the process ie February. Eventually would like this to tell me the order is impossible or possible


    The thought is to use weeks as the calculating point, however plant propagation is my forte and coding is about 4th on the list of my capabilities

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Do you have the initial database already created? Best to paste it here so folks can see your data structures to help with your questions.

  3. #3
    LadyKarenna is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2017
    Posts
    2
    Ok, can someone explain how to paste or upload diagram on this thing.

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    https://www.accessforums.net/faq.php...b3_attachments

    If you will be posting an Access database, ZIP it up first. Limit is 2mb for .ZIP files and 500kb for any other file type.

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

Similar Threads

  1. Worksheet within Excel Workbook
    By rpkfish in forum Macros
    Replies: 4
    Last Post: 05-06-2016, 03:02 PM
  2. Export Worksheet Labels
    By BR549 in forum Import/Export Data
    Replies: 4
    Last Post: 09-05-2014, 07:35 AM
  3. VBA to Import Excel Worksheet
    By bdaniel in forum Programming
    Replies: 2
    Last Post: 11-23-2010, 10:53 AM
  4. How to shedule a access query ... Help me
    By kusamharsha in forum Access
    Replies: 1
    Last Post: 03-04-2009, 01:57 PM
  5. Replies: 0
    Last Post: 02-16-2009, 08:21 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