Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read and Write Access Database
I want to create a excel workbook for leave application.
When the applicant open the workbook. It will checks the number of annual leave from a access database and checks the name of department head. I am going to user Environ("USERNAME") to check the login in of applicant to map the data. after the applicant submit the from. an e-mail will be created and sent to the department head. (my idea is attached another excel file, the file has "Approve" and "Disapprove" button) once department head approve the application, data will be writen to database to reduce the number of annual leave. if applicant wants to cancel the application, same concept. i think marcos can read and write and data from access but i have no idea. where can i find the code or example? Any others idea or suggestion to me about the procedure? Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read and write access database | Excel Programming | |||
Read-only, write-on-demand access to an XLA? | Excel Programming | |||
how to get write access from read-onlly mode | Excel Discussion (Misc queries) | |||
Testing if Directory has read/write access | Excel Programming | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |