This on has me stumped. Using Access 2007, windows xp, shared rived, linked tables and .accde.
I have several forms which display in datsheet view, they are used by medical reaserch staff. We have lots of people using these forms, and they could change the column widths, and move columns around. THAT WAS A BAD THING. I tried to find a way to prevent these column changes from being saved. I want the datasheet to revert to it's original layout when the form is opened.
I looked for a ssolution online from MS. Found a solution at http://support.microsoft.com/kb/173517
I used the solution and it worked. Solution was to place the datasheet as a Sub Form on another form which was SINGLE FORM View. Resized the sub form so it was not apparent the datasheet was a sub form of Single Form.
IT DID correct the problem. BUUT ! The customers can no longer EXPORT the datasheet to excel.
I presume the Export function realizes this is NOT a datasheet, becasue it's actually a Single Form with a subForm as a datasheet, hence, will not export.
1. Is my assumption correct ?
and is there a solution to the excel Export problem ?
OR
Is there a better way to PREVENT coulumn changes from being saved thent he solution provided in the MS article ?
P.S.
Sorry I have been away so long, Work Calls :)
Terence
Hello to John V, Bill M, A.D., Crystal & and the "gang" !
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar