Exporting Calendar into a different database (1 Viewer)

lovelylauralin · Oct 12, 2006

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?

Uncle Gizmo · Oct 12, 2006

You can't export, you must import.

You Can't export like that! What you do is you open the new database and import the objects you want. You can import forms, queries, tables, modules and I suppose macros! I missed anything?

Niniel · Oct 12, 2006

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 · Oct 12, 2006

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 · Oct 12, 2006

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

Uncle Gizmo · Oct 12, 2006

When I am blowed! I didn't realize you could export forms like that! I am sure you couldn't do it with earlier versions of access anyway. so I owe you an apology. And you have taught me something.

lovelylauralin · Oct 12, 2006

?? What do you mean export like that?

LOL.. so any ideas?

I really like this calendar!

Uncle Gizmo · Oct 12, 2006

I think the easiest way would be for you to attach a zipped database with just the Calendar form in. and I will have a look at it, it does sound like the module is missing though as suggested by Niniel.

Uncle Gizmo · Oct 12, 2006

the original database where you first found the calendar form, was there a module called basCalendar or something similar. If there was you may need that, you will need that!

lovelylauralin · Oct 20, 2006

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 · Oct 26, 2006

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

Is there something else I am supposed to be doing?

gemma-the-husky · Oct 26, 2006

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 · Oct 26, 2006

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 · Oct 26, 2006

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 · Oct 26, 2006

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 · Oct 26, 2006

did you export the table also?

there was 1 table, 3 forms, 1 module

lovelylauralin · Oct 26, 2006

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

gemma-the-husky · Oct 26, 2006

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 · Oct 31, 2006

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

Sooooo happy!

aceking · Oct 31, 2006

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

Exporting Calendar into a different database (1 Viewer)

Registered User.

Nifty Access Guy

Registered User.

Registered User.

Registered User.

Nifty Access Guy

Registered User.

Nifty Access Guy

Nifty Access Guy

Registered User.

Attachments

Registered User.

Super Moderator

Super Moderator

Super Moderator

Registered User.

Super Moderator

Registered User.

Super Moderator

Registered User.

Registered User.

Similar threads

Users who are viewing this thread