Exporting Calendar into a different database

[lovelylauralin]

I am trying to export a calendar form from one database to another.. I click on export, choose the database I want it to be exported into, and it seems to work..the form shows up in my new database, but when I click on the form I get a page of code that pops up with an error message

compile error
sub or function not defined.

how do I fix this?

 

[Niniel]

I guess that depends on your calendar.

I found this lovely calendar to enter dates, and to move that from db to db, I don't export, but import the form itself, and the program module that is required, into my new database.

Maybe all you are missing is that module, if you need one, or maybe importing works better than exporting.

 

[lovelylauralin]

Hummm.. I tried opening the database that I want it imported into, I went to file, import, and then I clicked on the database that I am importing from, clicked on the form, imported it, again... it seemed to work..the form is now in the database that I want it in.... but when I click on the form to open it .. again, I get the same error message..

Am I doing something wrong, or am I missing a step?

 

[lovelylauralin]

Program module? I tried importing it also.. It did not work.. I got the same error message.. any other steps I can take?

 

[lovelylauralin]

?? What do you mean export like that?

LOL.. so any ideas?

I really like this calendar!

 

[lovelylauralin]

Ok.. this is the file I got the calendar from... I saved it to my computer.. now I want to use this calendar in my database.. how do I get it in my database? I tried just importing it.. and I tried exporting into my database.. neither one work.

I thank you in advance for all of your help with this.

 

[lovelylauralin]

I exported the module also.. I am confused!!

Is there something else I am supposed to be doing?

 

[gemma-the-husky]

you need everything from the sample to use it. Specifically

frmCalendar
frmInputBox (to store stuff IN the calendar)
frm Choose (to print from it)

and modules
modcalendar

and tables
tblinput to store the notes



HOWEVER

i am sure its supposed to store things in the dates, but it wasn't bringing then back correectly from the inputtable when I played with it. I've not looked, but maybe it only works with US format dates and not UK dates. When you click a calendar date the input form that opens is not dated correctly for UK.

Haven't got time to look in more detail now.

import is easier, as you can grab multiple objects

 

[gemma-the-husky]

I was interested so I had a look

I am sure it only works with US format dates. (ie when your windows system is set for US dates.)

 

[gemma-the-husky]

Right, its working for UK dates now, if anyone is interested

in the module function cal put

DayOne = DateValue("1/" & m & "/" & Y) 'for UK

instead of
'DayOne = DateValue(m & "/1/" & Y) 'US

then all the comments popup


and you need to clear out all the rubbish from tblinput!

 

[lovelylauralin]

I am confused.. I tried to export this calendar from one database to another and I it works until I click on the calendar form to open it and it takes me to Microsoft visual basic page and I get an error message that states

"compile error user-defined type not defined"

and PublicSubPutin data is highlighted in yellow
and db ASDAO.Database is highlighted in blue

I exported everything including the module for the calendar... any ideas as to what I have done wrong and why I can't open my calendar?

 

[gemma-the-husky]

did you export the table also?

there was 1 table, 3 forms, 1 module

 

[lovelylauralin]

Yep... exported everything!!!
It should work.. I am not sure what I have done wrong.

 

[gemma-the-husky]

it may be a reference problem now. open a module then check from the menu at the top tools, references. somewhere unticked will be a microsoft da0 3.6 (or maybe another number) object library. This needs to be ticked and then probably moved ABOVE a reference to an ADO library.

Try that next.

 

[lovelylauralin]

OMG!!! Thank you! You wonderful person you! LOL..
It worked!
Sooooo happy!

 

[aceking]

Statistical error

I tested this database, but when there is an entry in the current month it quits with an error : runtime error '3077' Statistical error in the date expresson.

The following line is highlighted yellow : rs.FindFirst "inputdate=#" & f("date" & i) & "#"

Can anyone help ?

Thanks, Leslie