Search results for query: *

it sets the calendar to today's date when the form first loads... I had date() but it took away the brackets. It still worked though.

I've been watching it the whole time :) (although I like your break on change idea.) Getdate just empties when the calendar form closes...

In a new module with nothing else in it

It seems to be filling the variable okay while the calendar form is open but not passing it to the other code... I'm thinking maybe my global variables are still wrong although I did what you said... BTW It's a calendar control 10.0 I think I might just go back to the dodgy version that I had...

Hi guys, thanks for your help...the whole global variable thing seems to be going okay but my date is just coming up as 12:00:00am... For my calendar form I have this code: Public Sub CMDContinueTemp_Click() GETDATE = MSGCalendar.Value DoCmd.Close End Sub Private Sub Form_Load()...

Nevermind.... I got around it with an invisible text box on my initial form.

Thanks Eupher, you hit the nail on the head. I'm now having trouble getting the date value to pass back to my code. I figure I need GetDate to be a global variable, and to fill it in the continue button code before the dialog box closes but am unsure of how to correctly declare global variables...

I have some code which opens a form with a calendar control and a continue button on it. I need the user to choose a date and click the continue button, passing the date to a variable (GetDate) in my code. I'm having trouble finding a way to get the original code to stop and wait until the...

Not sure if CyberLynx helped you or not, but I needed a similar thing on a database I created and I managaed it without using code... I have a combo box which a user can choose a personal trainer from. The surname and firstname were different fields, so I wanted to show them both, but only...