Monas: You need to create a link as I originally outlined. Not an import, a link. Then you can use the data in a form.
Richard Richard "Manxman" Killey Developer of MS Access Databases mailto:[email protected] for more MS Access tips, visit http://www.databaselessons.com -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of monas monas Sent: March 8, 2009 9:05 AM To: [email protected] Subject: Bls: [Access VBA Central] please allow me to know... thank you Mr. Richard You've help me much so far.... I have tried "the trick" but, here is my real problem... i have a lot of data , the machine's data in my office, and it have been written in XLS format since 2004 all the data !! that mean that is not effective to change all of the data to access ( access tabel ) so that i can call the data from its own tables i wonder if i can make an access form that can call the data direct from the xls file no need to change to mdb.... yesterday i tried to make a form, an access form, and tried to call the data from the table ( access table ) i made it ( happy me )... but when i am faced to the xls table ..... i got confused... how??? i can not find the answer please help me to solve it..... here is the simplest data i have a table ( xls table )with two coloumn 1 coloumn called as Height the the other called Volume all i want is when i write the height value ( primary key ) in my access form, automatically in Volume text box show the value .... is it possible to do ?? Please help me Thanks before best regard ________________________________ Dari: Richard Killey <[email protected]> Kepada: [email protected] Terkirim: Minggu, 8 Maret, 2009 11:12:59 Topik: RE: [Access VBA Central] please allow me to know... Heru XLS is easy to do. Just use a Link or an Import. In Access 2000 and 2003 Link is under Tools menu, Database Utilities sub menu Richard "Manxman" Killey Developer of MS Access Databases mailto:rich...@databaseles sons.com for more MS Access tips, visit http://www.database lessons.com -----Original Message----- From: AccessVBACentral@ yahoogroups. com [mailto:AccessVBACentral@ yahoogroups. com]On Behalf Of monas monas Sent: March 7, 2009 5:17 PM To: AccessVBACentral@ yahoogroups. com Subject: [Access VBA Central] please allow me to know... i am heru I just a beginer in ms access. and i want to know... is it possible in access to use data source from the other file format ??... Mmmmm....example : the xls or doc file if it yes, please show me how Becausa i found that acces is always use its own tabel as a data source and i think it make me feel unfree to do things... thank before best regard Lebih bergaul dan terhubung dengan lebih baik. Tambah lebih banyak teman ke Yahoo! Messenger sekarang! http://id.messenger .yahoo.com/ invite/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] __.._,_.___ Messages in this topic (2) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Recent Activity * 26 New MembersVisit Your Group Give Back Yahoo! for Good Get inspired by a good cause. Y! Toolbar Get it Free! easy 1-click access to your groups. Yahoo! Groups Start a group in 3 easy steps. Connect with others. . __________________________________________________________ Coba emoticon dan skin keren baru, dan area teman yang luas. Coba Y! Messenger 9 Indonesia sekarang. http://id.messenger.yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
