Ask Your Question

Tips for displaying or entering calendar based data? [closed]

asked 2014-06-16 16:19:10 +0200

CEAuke gravatar image

Hi guys

I would like to collect and report on calendar based data. E.g. data with limited attributes but where I want to display it in a nice calendar.

e.g. I have a database table called timesheet. The date field is unique and I have columns for location and hours.

How can I display this information in a report/form in a nice calendar layout with ideally the option to modify the location and hours values.

Basically I need a multi-record display but in a form layout (as opposed to a table layout). If that is possible I can probably write a marcro to move the fields in the right place.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 18:11:36.404015

1 Answer

Sort by » oldest newest most voted

answered 2014-06-16 17:16:03 +0200

JPL gravatar image

I need a multi-record display but in a form layout (as opposed to a table layout)

This functionality, called "Continuous forms" in MSAccess, is not available in Base. The closest to the layout that you want is to make use of grid controls. F.i. for a weekly timesheet, put each task in a separate row and day-in-the-week as columns. Feasible for displaying the data in a specific week, more difficult to manage for data updates.

Success. JPL

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-06-16 16:19:10 +0200

Seen: 463 times

Last updated: Jun 16 '14