Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel and access update each other like a two way connection CmK Excel Discussion (Misc queries) 0 February 23rd 07 01:01 PM
Excel update from Access Sharon A Excel Discussion (Misc queries) 0 June 14th 06 04:35 PM
Automatic Update from Access to EXcel Jay Excel Discussion (Misc queries) 0 February 11th 06 07:01 PM
export access to excel. change access & update excel at same time fastcar Excel Discussion (Misc queries) 0 June 24th 05 09:27 PM
update access from excel sal21[_37_] Excel Programming 0 October 29th 04 08:46 PM


All times are GMT +1. The time now is 11:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"