• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Advanced Access 2003 - Forms - Dynamic Field Creation

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.
0
advlegals
Asked:
advlegals
  • 3
1 Solution
 
GRayLCommented:
What about the year?
0
 
advlegalsAuthor Commented:
GRayL:

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.
0
 
GRayLCommented:
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?
0
 
GRayLCommented:
Thanks, glad to help.  I was expecting you to come back, but I guess that was enough to get you going.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now