Codejock Developer Community : CalendarControl.DataProvider.Create http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 11:13:25 +0000 Fri, 22 Dec 2006 12:40:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5581 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[CalendarControl.DataProvider.Create : Thank you for the.Create method...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18553&title=calendarcontrol-dataprovider-create#18553 Author: elmsoftware
Subject: 5581
Posted: 22 December 2006 at 12:40pm

Thank you for the .Create method update in 10.4.
It works perfectly and is much appreciated.
 
All the best,
 
John
]]> Fri, 22 Dec 2006 12:40:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18553&title=calendarcontrol-dataprovider-create#18553 <![CDATA[CalendarControl.DataProvider.Create : Much appreciated. All the best, John...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18188&title=calendarcontrol-dataprovider-create#18188 Author: elmsoftware
Subject: 5581
Posted: 13 December 2006 at 6:42pm

Much appreciated.
 
All the best,
 
John
]]> Wed, 13 Dec 2006 18:42:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18188&title=calendarcontrol-dataprovider-create#18188 <![CDATA[CalendarControl.DataProvider.Create : For 10.4 method .Create will be...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18185&title=calendarcontrol-dataprovider-create#18185 Author: sserge
Subject: 5581
Posted: 13 December 2006 at 4:35pm

For 10.4 method .Create will be fixed.

For now you can simply export required Calendar tables from the DB created from scratch to your DB using Access Export tool.

--
WBR,
Serge
]]> Wed, 13 Dec 2006 16:35:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=18185&title=calendarcontrol-dataprovider-create#18185 <![CDATA[CalendarControl.DataProvider.Create : Hi Serge, What I did... 1)...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17677&title=calendarcontrol-dataprovider-create#17677 Author: elmsoftware
Subject: 5581
Posted: 27 November 2006 at 11:18pm

Hi Serge,
 
What I did...
1) Open and ran the VB Calendar Sample provided.
2) Choose File/Open/Use DB data provider.
3) Entered the name of a mdb file located in the same directory as the Calendar Sample code.
4) Click OK.
5) The only table added is the 'Schedules' table.
 
I am running VB6 (SP6) using ADO 2.8 on Windows XP Pro computer.
 
Thank you for your patience.
Sorry to rehash this, but I cannot get the .Create to work with a pre-existing Microsoft Access database.
 
John
]]> Mon, 27 Nov 2006 23:18:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17677&title=calendarcontrol-dataprovider-create#17677 <![CDATA[CalendarControl.DataProvider.Create : John,Try the following: open regular...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17674&title=calendarcontrol-dataprovider-create#17674 Author: sserge
Subject: 5581
Posted: 27 November 2006 at 5:56pm

John,

Try the following: open regular VB Calendar Sample, choose File/Open/Use DB data provider, enter the name of your DB file (with your tables exsting, but without Calendar's tables), and press Ok.

As you can see, now the database contains both your tables, and all needed for Calendar.

--
WBR,
Serge
]]> Mon, 27 Nov 2006 17:56:43 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17674&title=calendarcontrol-dataprovider-create#17674 <![CDATA[CalendarControl.DataProvider.Create : sserge wrote: Do not create...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17673&title=calendarcontrol-dataprovider-create#17673 Author: elmsoftware
Subject: 5581
Posted: 27 November 2006 at 5:08pm

Originally posted by sserge sserge wrote:


Do not create tables by yourself, just set a name of your database in the connection string, call Create and they will be created automatically (it uses ADOX internally).

 
Hi Serge,
 
When I call .Create the four tables do not get created automatically.
Only the 'Schedules' table gets created.
That is my experience.
 
I need the .Create method to add the four tables to my pre-existing Access database...not in a blank non-existing database.
  
You helped in previous posts about how the .Create method adds the four tables to a non-existing database but I would like the tables to be created in my pre-existing database.
 
What are your thoughts?
 
Thank you for your time.
 
John
]]> Mon, 27 Nov 2006 17:08:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17673&title=calendarcontrol-dataprovider-create#17673 <![CDATA[CalendarControl.DataProvider.Create : The answer would be exactly like...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17672&title=calendarcontrol-dataprovider-create#17672 Author: sserge
Subject: 5581
Posted: 27 November 2006 at 4:17pm

The answer would be exactly like in a previous post

Do not create tables by yourself, just set a name of your database in the connection string, call Create and they will be created automatically (it uses ADOX internally).

ps: when testing, do not forget to backup your DB

--
WBR,
Serge
]]> Mon, 27 Nov 2006 16:17:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17672&title=calendarcontrol-dataprovider-create#17672 <![CDATA[CalendarControl.DataProvider.Create : Thank you for your prompt responses. We...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17668&title=calendarcontrol-dataprovider-create#17668 Author: elmsoftware
Subject: 5581
Posted: 27 November 2006 at 12:23pm

Thank you for your prompt responses.
 
We have a wedding software program that exists with 40+ tables in an Access database and we want to add this control to our application as well as the four tables.
 
How do I create the four CalendarPro tables in a database that already exists?
 
Do you recommend that I look at the design of the four tables and then create the tables manually in code using ADOX?
 
What are your thoughts?
 
John
]]> Mon, 27 Nov 2006 12:23:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17668&title=calendarcontrol-dataprovider-create#17668 <![CDATA[CalendarControl.DataProvider.Create : elmsoftware wrote: When...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17566&title=calendarcontrol-dataprovider-create#17566 Author: sserge
Subject: 5581
Posted: 23 November 2006 at 10:02am

Originally posted by elmsoftware elmsoftware wrote:

When I run the 'Create' method when pointing to a blank database, no tables for me get created.
...


Do not create a blank database by yourself, just set a name of the database to be created in the connection string, and it will be created automatically.

--
WBR,
Serge
]]> Thu, 23 Nov 2006 10:02:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17566&title=calendarcontrol-dataprovider-create#17566 <![CDATA[CalendarControl.DataProvider.Create : Hello, Environment: VB6 and...]]> http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17565&title=calendarcontrol-dataprovider-create#17565 Author: elmsoftware
Subject: 5581
Posted: 23 November 2006 at 9:48am

Hello,
 
Environment: VB6 and Access database
I purchased the Suite just the other day.
--------------------------------------------------
 
When I run the 'Create' method when pointing to a blank database, no tables for me get created.
 
Create statement
In the example below...
1) CalendarControl.SetDataProvider statement is run
2) 'Set Next Statement' to run the 'Create' method and no tables get created in my blank database.
Note: The .Open method is skipped in this example
 
 
Normal Code Flow
1) SetDataProvider would run.
2) The Open statement would run and the 'Schedules' table gets created.
3) The Open statement returns True so the Create method is not run.
 
What are your thoughts on the .Create statement not working as expected?
 
The controls in the Suite are top notch and we are excited about adding them to our applications.
 
John
]]> Thu, 23 Nov 2006 09:48:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=5581&PID=17565&title=calendarcontrol-dataprovider-create#17565