Cross Tab Query Into a sub form dynamically | Access forum

Resolved · Urgent Priority · Version 2016

Sat 9 May 2020, 19:50 Delegate Manny said...

Manny has attended:
Access Intermediate course
Access Advanced course

Cross Tab Query Into a sub form dynamically

Hi all,

I have a cross tab query with a partition that will return results in a specific interval.

i want the user to be able to view the cross tab in the subform. the problem is that the column headers will change as when when data is available (nature of a cross tab). how can i dynamically alter the columns everytime the user opens the parent form, with the subfrm in a tab control.

Thanks, Manny

Mon 11 May 2020, 10:58 Trainer Jens said...

RE: Cross Tab Query Into a sub form dynamically

Hi Manny,

Thank you for another simple:-) forum question. I hope you had a nice long weekend.

I will need a little bit of time for this one. I try to do it today, but not later than tomorrow. I hope it is ok.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 11 May 2020, 11:33 Delegate Manny said...

RE: Cross Tab Query Into a sub form dynamically

Hi jens!

I actually managed to resolve it this morning :)

Apologies i hope i didnt waste your time.

Thanks, Manny

Mon 11 May 2020, 11:37 Trainer Jens said...

RE: Cross Tab Query Into a sub form dynamically

Thanks Manny,

If all the forum users were as clever as you, I would be out of work. Well done again.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 18 May 2020: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips