Dates in Tabs

[armyofdux]

Hey guys I am stuck on a possible way to automatically update dates based on the current date. For example today is 13 Nov 2014. I need an 8 week projection buildout of each week from the current date. So the next tab should read 20 Nov, 27 Nov and so on. I need a way to automatically update those tabs either via a button or macro. Macros and VBA are my weakness when it comes to this. By the way these dates are in a table and the dates are in the column headings. Thanks in advance.

[ranman256]

Putting dates on form tabs is a bunch of vb work.
can you just make a Crosstab query with dates as col. headers?

[June7]

What do you mean by "dates are in a table and the dates are in the column headings"? This smells like non-normalized data structure.

You are use a Tab control?