Date issue...

Grafixx01 · April 23rd, 2007, 09:02 AM

dartcoach,

The 'frmCalendar' is an actual form which contains an "Active X calendar 11.0" control on it.

Rob,

I'll try that too.

robzyc · April 23rd, 2007, 09:09 AM

Grafixx,

Give it a whirl and please ask if you get stuck. It can be strange working with form instances in VBA for the first few times, but once you get your head round it, you can save yourself a lot of time!

HTH.

Regards,
Rob

Grafixx01 · April 23rd, 2007, 09:26 AM

rob,

I cut and pasted your code into the 'Insert Date' command button on the 'frmTask' (Main Form). Then I cut and pasted the code in the 'on click' of the 'frmCalendar'-'Insert Date' command button.

The code on the 'Insert Date' of the 'frmCalendar' returned this error:

'Compile Error: Invalid Attribute in Sub or Function' (Highlighted is the 'Private Sub cmdInsertDate_Click()'

I don't know if I have to change this to specify the which 'date' control on the 'frmTask' I want it to populate?

dartcoach · April 23rd, 2007, 09:33 AM

Bryan,
Rob is correct. Utilizing Global Variales can cause problems if you don't pay attention to what you're doing. If you can get his code to work, I highly recommend it.

Kevin

dartcoach

robzyc · April 23rd, 2007, 09:35 AM

Grafixx,

The cmdInserDate_Click() sub should look like this:

Code:

Private Sub cmdInsertDate_Click()
    PopulateWithDate TextBoxName
End Sub

Make sure the PopulateWithDate Sub is pasted into a Global Module.

Did that help?

Rob

robzyc · April 23rd, 2007, 09:37 AM

Quote:

quote:Originally posted by dartcoach
Bryan,
Rob is correct. Utilizing Global Variales can cause problems if you don't pay attention to what you're doing. If you can get his code to work, I highly recommend it.

Kevin

dartcoach

Thanks dartcoach for the recommendation!

Kind Regards,
Rob

Grafixx01 · April 24th, 2007, 11:28 AM

Thanks dartcoach for the help with the db isssue. Much much much appreciated.!