Q regarding FAQ -- Date pop-up 1

[simon551]

Hi,
I'm trying to implement this FAQ (faq702-4601) but know very little about modules. Basically the faq gives you a pop-up dynamic date form built in a module. This might sound stupid but I can't figure out how to use this in a form. Can anyone give me a hint?

Thanks,
s

 

[Zion7]

whithout really inspecting the code itself (i'm sure it's fine, though),
You said in a form? No, this should be in a standard module,
NOT A FORM(class) module.

Once you paste it into a new STaNDARD module,
open the immediate window and type ?GetDate
then press enter.
Your form, and module should be created.

 

[CompuSolve]

I suggest skipping that FAQ and using Lebans calendar control - I think the FAQ is more of an example. Lebans calendar is a production ready classs you can drop into any application. The best calendar I have seen for MS access.

http://www.lebans.com/monthcalendar.htm

 

[simon551]

zion,
maybe you underestimated my unfamiliarity w/ modules. It is a standard module that I pasted it in, but I'd like to *use it* in a form. I don't even know if that's possible. It works fine in the module, (?GetDate) I just want to get the output (date selected) onto a different form.

Thanks for the suggestion, compusolve. I'll be trying that.

-s

 

[Zion7]

Sorry Simon, if I took anything for granted but,
If your familiar with Standard & class modules,
and know how to reference an object/control in either one,
what part are you unsure of, how to initiate the
sub?

you mean like with a conmmand button?

Private Sub cmdCreateForm_Click()
Call GetDate
End Sub