Hi,
I'm currently having a problem with the calandar control in Access. I have it on the form, and wanted a text box (in the form and also in a tbl_date table) to lookup the value of the date selected in the calendar control, which should be defaulted to the current date. I know I have to write some VB which I did and end up appending the dates selected into new rows in the tbl_date instead of overwriting the only date in the table. I guess I must have done sthg wrong, can anyone please help me? To which event should I attach the VB to (there is no on click in the properties of the calender control, so I suppose on focus?)?
In addition, I am also trying to import a file into Access and wanted a position_date text box to reflect the date of the file imported (as in the modified date of the file in windows explorer). How can I do this?
Thanks so much for all the help I can get.
I'm currently having a problem with the calandar control in Access. I have it on the form, and wanted a text box (in the form and also in a tbl_date table) to lookup the value of the date selected in the calendar control, which should be defaulted to the current date. I know I have to write some VB which I did and end up appending the dates selected into new rows in the tbl_date instead of overwriting the only date in the table. I guess I must have done sthg wrong, can anyone please help me? To which event should I attach the VB to (there is no on click in the properties of the calender control, so I suppose on focus?)?
In addition, I am also trying to import a file into Access and wanted a position_date text box to reflect the date of the file imported (as in the modified date of the file in windows explorer). How can I do this?
Thanks so much for all the help I can get.