Programming

[JLT]

I am trying to program a data base that has tab pages on each tab page I have a subform. I have one tab that I want as a calender as a visual summary for data that is in one of my subforms. I have been trying to find a vba code or macro to assist me in doing this with no luck. Any help would be greatly appreciated.

[orange]

Watch this
http://www.youtube.com/watch?v=9Rv0RNwsLuw

[JLT]

great video, but it didn't help me with my question concerning installing a calendar on a tab page to visually display data from a subform.

[orange]

I wasn't sure of the details of the difficulty and offering help re tabbed forms.
What specifically is the problem?

[JLT]

The database that I formatted has numerous tabs and subforms. One subform is titled Treatment Table, the data I have on this subform I want transposed to a calendar that will be on one of my tabs. I can't seem to get a VBA code to work that will take the data from the subform and make visible on a calendar. I have tried all the codes that I can find on the forums and nothing works.

[orange]

Can you post the VBA code to work that will take the data from the subform and make visible on a calendar.

Do you get error messages? Have you tried just getting the treatment table data to show on a calendar (just a form) not complicated with tabs/subforms etc?

[JLT]

I removed all the codes that I had tried, I wasn't getting any error messages, just didn't transpose the data...I would like to start from fresh if I can. I was using an Active X control calendar and it just didn't want to work..the VBA was Me!Treatmenttable = Me!Calender0.

[orange]

Here's a sample in Acc2000 format

I have Acc2003, I can 't read or use accdb type databases.


Have you seen this link?
http://office.microsoft.com/en-us/ac...in=HA001054662

[JLT]

Yes I have read that link and had no results that worked on my db..I can not open the example that you attched, it asks for log in information.

[orange]

It must be something at your end. I know you have Acc2007 and the sample is Acc2003 with database in Acc2000 format.


Can you make a version of your database into Acc2003 format mdb?
Just enough data to show the issue -- take out anything considered confidential/proprietary.


Have you been through this free video tutorial?
http://www.datapigtechnologies.com/f...drcontrol.html

[JLT]

unfortunately I'm not able to convert to 2003 db..
I've tried the following code and it does not update the calender. I want the data that is in my db form treatment_table to appear in the calendar and what am I missing or can it even be done.

Private Sub Treatment_Calendar_Click()
Me.Form.Treatment_Date = Me.Treatment_Calendar
Me.Form.Treatment_Description = Me.Treatment_Calendar
End Sub