Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update access from excel
My actually prob is:
is possible to update automaticlly the cells of the sheet L0785_TOTALE and the table TOTALE of MDB after i have insert a value in the txtbox marked (see the image). the unique value for every sheet is in the column S acctually is hide. the unique value for table TOTALE is in the column SERVIZIO. Tks for all. Note:_ the module DB_ACCESS is only a test not consider it. http://www.gssitaly.com/l0785_def.zip http://www.gssitaly.com/prova.zip htTP://www.gssitaly.com/txtbox.gif tks from Italy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
update access from excel
just on the theory...
haven't downloaded your files... TOTALE.. sounds like totals to me.. totals should be computed not stored. Create a linked table in Access and link to the excel sheets. create a query to generate your totals.. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "?B?c2FsMjE=?=" wrote : My actually prob is: is possible to update automaticlly the cells of the sheet L0785_TOTALE and the table TOTALE of MDB after i have insert a value in the txtbox marked (see the image). the unique value for every sheet is in the column S acctually is hide. the unique value for table TOTALE is in the column SERVIZIO. Tks for all. Note:_ the module DB_ACCESS is only a test not consider it. http://www.gssitaly.com/l0785_def.zip http://www.gssitaly.com/prova.zip htTP://www.gssitaly.com/txtbox.gif tks from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel and access update each other like a two way connection | Excel Discussion (Misc queries) | |||
Excel update from Access | Excel Discussion (Misc queries) | |||
Automatic Update from Access to EXcel | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
update access from excel | Excel Programming |