Hey Richard and the Guys, if I use the 'DatePickerF' that Richard created in the 'Custom Date Picker Series' Tech Help to Reschedule Events. But the 'Schedule Information Form' that I am using to View the Scheduled Event Data has an Datasource of an Query that is Not Updateable. So, If I sent "SomeDateField = GetDatePicker(SomeDateField)" to open the 'DatePickerF' to set the Default date in the 'MyDate' field.
Adam Schwanz
@Reply 2 years ago
You'll have to change it into like a SQL statement to update the record then requery your form afterwards, something like this but it may require more changes depending on your setup.
Dim MyDate
MyDate=GetDatePicker(SomeDateField)
UPDATE Table Set SomeDateField=#" & MyDate & "#" Probably need some where criteria here too but I don't know what you have going on.
James HopkinsOP
@Reply 2 years ago
Oh okay, Adam... I was thinking Recordsets, but I will use that... Thank you, Adam... Ur the Best...
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Custom Date Picker 2.
