Insert date and time into excel sheet.

[alphaol]

Have got an access database that is link to excel spreadsheet. Have got a form that I want when the user click NEXT button, it will save the time & date onto the excel spreadsheet.

thanks

[June7]

From my experience, the link to Excel is read only.

[alphaol]

From my experience, the link to Excel is read only.

Have been able to write to it from the same form. As I have a comment box on the form and it does save to the spreadsheet when I click next but the date doesnt.

[June7]

I would be interested in knowing how you make the linked spreadsheet editable from Access. Every link I have tested does not allow edits. If I could do this then I could explore your issue.

[alphaol]

I would be interested in knowing how you make the linked spreadsheet editable from Access. Every link I have tested does not allow edits. If I could do this then I could explore your issue.

I used a subform and a mainform which has one of my field to search by typing the username in, then the subform display the information such as address,then i added comment field, which the user type in. and a next button on the subform to go through all the accounts under that username.

On another note, I have an exit button on the form, is there a way I could get it to save a default value in the user name,it seems to save the last name that was use in the search username button.

[June7]

Search control should be unbound. If it is bound you will change value in the table. This will really mess up your data.

I still don't have an editable linked spreadsheet.