planner/ reminder program

[dark_shadow]

hey guys
i'm gonna be starting on making a planner program using the MonthView Control. i've got when you click on the date and click add reminder a form comes up with 3 textboxes one for the event, one for the time it starts and the time it ends. i'm not sure exactely what i should use to save the data for the reminders in any ideas would be appreciated thanx

[MartinLiss]

A database would be the usual choice.

[dark_shadow]

alright lol your gonna have to bare with me as i have absoutely NO experience with databases and such i'm assuming you would use MsAccess to do the job?

[MartinLiss]

Yes that is perhaps the most popular choice.

[dark_shadow]

alright would you know of any examples on how to use databases that i can take a look at?

[Hack]

Take a look at the database tutorial in the database section, and the database portion of our FAQ section.

[dark_shadow]

lol wow today i have been so out of it thanks hack

[RhinoBull]

hey guys
i'm gonna be starting on making a planner program using the MonthView Control. ...

Just using that control might be difficult to accomplish what you're after.
You may want to look at the sample I posted in this thread - it demonstrates how to layout your own calendar. You may utilise MonthView for dates selection if you wish.

[dark_shadow]

so according to your other post you cant write "external data" to the control?

[RhinoBull]

Of course not - it's good only for selecting dates. Just like DateTime Picker control.

[dark_shadow]

ok i see

[RhinoBull]

Your guidance to perfect GUI could be MS Outlook 2000. 2003 version was overkilled with some unnecessary features and I also found GUI to be very cumbersome.

[dark_shadow]

ok for adding the database i've got msAccess 2003 what reference would i use it ? according to the example i downloaded it says to reference the "Microsoft Active Data Objects 2.5 Library" but i didnt see that as one of my options when i was looking through the refernces

[RhinoBull]

You may need to download MDAC directly from Microsoft and install it first.

[dark_shadow]

ok i did as RhinoBull said and it still does not show up for some reason

[RhinoBull]

That's not possible... Did you properly install it?

[dark_shadow]

yes i did but i'll try again

[dark_shadow]

RhinoBull in your example of a calander you cant resize any controls why is that ?

[dark_shadow]

alright i've been doing some reading on using ADODB control first and for most would this help my situation? second when i use it i get an "error with FROM clause" error why does this mean?

[RhinoBull]

RhinoBull in your example of a calander you cant resize any controls why is that ?

Because it's only a sample - it wasn't designed to do that.

[dark_shadow]

should of figured that lol

[RhinoBull]

alright i've been doing some reading on using ADODB control first and for most would this help my situation?

It may but using bound controls isn't something that you would want to do on a regular basis - using ADODB library is much more flaxible way but much coding involved as well.

...second when i use it i get an "error with FROM clause" error why does this mean?

You'll need to post your code.

[dark_shadow]

the code is just establishing the connection

set Adodc = new Adodc.Connection

[RhinoBull]

I don't follow you dark: what about that "error with FROM clause" question ?

[dark_shadow]

ok i'm trying to get the basics of using the Adodc and just to understand the connection i've made a small program if it connects to the then it gives me a msgbox but when i put the code

set Adodc = new Adodc.Connection

i get a "syntax error with FROM clause"

[RhinoBull]

Take a look at this thread - we have few tutorials and samples there.

[dark_shadow]

ok thanks i appoligize for the very basic questions that are probally wasting your time

[dark_shadow]

that tutorial worked great... but now i've got another problem when i try to add a record i get a "current recordset does not support updating" at this line (higlighted in red)

rs.Open "SELECT * FROM table1", cn, adOpenDynamic, , adCmdText
  [COLOR=Red]rs.AddNew[/COLOR]     
  rs.Fields(0).Value = txttitle
  rs.Update