Changing a Undateable Record - Custom Date Picker in Microsoft Access, Part 2


	Back to Custom Date Picker 2 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Changing a Undateable Record

James Hopkins

2 years ago

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 Hopkins OP @Reply 2 years ago
Oh okay, Adam... I was thinking Recordsets, but I will use that... Thank you, Adam... Ur the Best...

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Custom Date Picker 2.

Next Unseen

New Feature: Comment Live View