+ Reply to Thread
Results 1 to 4 of 4

Design advice needed

  1. #1
    Registered User
    Join Date
    12-01-2018
    Location
    NJ
    MS-Off Ver
    Office 365
    Posts
    76

    Design advice needed

    Hi Folks -

    I have an MS Access Database with quite a few Functions. Each function serves a different purposes but there are functions where I am re-using most of the same values in arrays. Therefore, rather than maintain each Function, I want to maintain 1 section where I identify the array value(s) and then indicate the Function it should be made available in, if that makes sense?

    For this example, I have (3) functions that all use 90% of the same array values. My hope is to central maintain that list by identifying the full set of values and then indicating what function each value belongs to. And then when the Function is executed, it will read the array value AS WELL potentially another value that checks if this value should be used in "this" array. If so, continue, if not, skip.

    I have attached an excel workbook with the Master List of value and where each value should be used as an example.

    Below is a Function I currently use so I'd need to update based on the suggestions here.

    Please Login or Register  to view this content.
    Any suggestions are greatly appreciated, thank you all!
    Attached Files Attached Files
    Last edited by ausable7400; 10-03-2021 at 09:42 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,622

    Re: Design advice needed

    You've posted to the Excel VBA section - did you mean to post in the Access area? I can move this for you, if so.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    12-01-2018
    Location
    NJ
    MS-Off Ver
    Office 365
    Posts
    76

    Re: Design advice needed

    I'm so sorry, Ali, yes can you please move for me? Thank you so much!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,622

    Re: Design advice needed

    Moved to the Access VBA section.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-04-2021, 04:43 PM
  2. [SOLVED] Design Advice for WorkSheets Color Schemes and Formatting
    By chullan88 in forum Excel General
    Replies: 3
    Last Post: 06-05-2017, 03:40 PM
  3. [SOLVED] Need advice on design of this profit / loss spreadsheet.
    By reddwarf in forum Excel General
    Replies: 4
    Last Post: 12-12-2014, 07:08 AM
  4. Statistical design help needed its emergency
    By Rathi in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 06:15 AM
  5. help advice needed
    By stevencarroll19 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2006, 12:00 PM
  6. advice needed
    By Duncan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 07:06 PM
  7. [SOLVED] Advice needed...
    By Duncan in forum Excel General
    Replies: 3
    Last Post: 01-27-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1