Develop a Form to look similar to the rpt with combos

[djspod]

Hi ,

I have a Database that pulls all the staff data together from several tables and generates a PDF report rota plan for the week (Shift times, who is on day etc)

Is there a way of display the generated report which is created from a query into an Access Form.

Ideally I want the report rota plan to display in the form as Default Values as it loads that week up but at the same time alow myself to change each value via a combo box to holiday, DIL, Sick, Paternity, Overtime etc.

Update the Table or make a new table and allow myself to reprint the rota pdf with the new changes made to the rota plan.


might sound a little crazy or hard to understand so I have attached the PDF Rota Plan.

I want very similar to this in a form version with combos selection boxes but I want the Rota default values to load in (Their shift pattern)

Essentially each staff member will be in on that week and dates other than the Holiday,Sick ETC.

 

[CJ_London]

reports have different sections, sorting/grouping properties and events to forms.

They also often use crosstab queries which are not editable

Assuming your report is straightforward and does not use a crosstab query for the recordsource, the easiest way would be to create a new form and copy/paste the recordsource and header/footer/detail section controls from the report to the new form.

Then those controls which need to be a combo, right click and select Change To - then populate the rowsource, bound column, column count and column width properties.

If you need an 'editable' crosstab, then you will need to start from scratch and use something such as provided here

http://www.access-programmers.co.uk/forums/showthread.php?t=243278&highlight=crosstab

 

[djspod]

Hi CJ,

Thanks for your support and input.

I'm in work tonight so I will have a look at your suggestions (Thanks)

My goal is:

my Access database is able to pull all the shifts, operatives, rotation of who is in and off by week number/date (the week date is the primary ID for each record)

I now want to develop this further, to have the query feed the form the base plan of who is scheduled in or off as default values but have the ability to alter each text control box to change the default value to a number of items from a list or combo (Sick, Holiday,Auth Leave etc)

Use an update query to update the table ready for the rota report page to be re printed and display the changes.

The staff are then aware that overtime is available in advance.

We currently do this by a mix of Excel and Access.

I now want all in Access if possible?

i have attached a screen shot of Excel printoff and the Access Rota print off which is always static data, the excel version is fed by lookups from tables and has list drop downs to alter each cell but is slow on the network.





Thanks again for your support

 

[CJ_London]

I now want all in Access if possible?

with proper design of tables, pretty much anything is possible