Advanced Access 2003 - Forms - Dynamic Field Creation

Posted on 2007-08-06
Last Modified: 2008-03-17
I'm writing an Access reporting engine which is to display the days of the month as columns with the rows being individual users.

I'm trying to source a method/procedure which will dynamically create a header displaying the days in any month as well as rows of text boxes for each day in a month which will be associated with each user.

Behavior: - A month is selected, a form header detailing each day in the month is created and rows of text boxes are created against each user's name.
Question by:advlegals
    LVL 44

    Expert Comment

    What about the year?

    Author Comment


    The year would be important when considering leap years. I'm currently searching for some sort of calendar control which will identify the number of days in each respective month and I thought that this would cater for the year variable also.
    LVL 44

    Accepted Solution

    So you want a report by Month with 28-31 columns and umptyump rows, you have to 'tell' the system which year.  Why not a form with combo boxes for year and month, and a command button which launches the report?
    LVL 44

    Expert Comment

    Thanks, glad to help.  I was expecting you to come back, but I guess that was enough to get you going.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now