 |
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
 Posted: Sat Jan 12, 2002 10:58 pm
zmud and microsoft access
|
is anyone familiar with COM stuff and such?
i am trying to tie zmud wiht microsoft access and such.. but i havent the faintest idea how to do such things...
my first question would be if the name i creat a link to.. is access.application..
then what are the layers of com objects? or.. is there a site that explains em...
also.. well.. you get my point...
thanks
karthic
karthic |
|
|
|
|
Kjata
GURU
Joined: 10 Oct 2000
Posts: 4379
Location: USA
|
Posted: Sun Jan 13, 2002 1:20 am
|
Like you said, you need to know the COM implementation of Access. You will most likely find this somewhere in microsoft.com (I know, that is easier said than done.) So try to find out a document that explains what the Access object is called (if it is access.application or some other thing) and what functions are available to you (just like the one Zugg wrote for zMUD.)
Kjata |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Sun Jan 13, 2002 1:28 am
|
ya.. i've been lookin.. just cant find the document...
shrug.. really lookin for someoen who has prior expirence with this..
well..if anyone knows what document on microsoft.com explains this...
great
karthic
karthic |
|
|
|
|
Tarn
GURU
Joined: 10 Oct 2000
Posts: 873
Location: USA
|
Posted: Sun Jan 13, 2002 1:34 am
|
To just see the tree of what's available in Access, you can use any common programming package, or something like Excel.
In Excel 2000 (location varies a little by version) you can, if you start up the macro environment ('mini-VB') you can add Access to the references (Tools|References in the VB editor in Excel).
Then, you can hit F2 (Object Browser from the menu) and switch to the Access stuff in the library combobox (upper left.)
This will show what each object defined in that library will do for you. From something like zMud, these would be named things like "Access.Application" as you assumed. Library name dot classname.
Unfortunately, I don't have Access so I can't give you a walkthrough on that, but I assume it's similar to Word, Excel, or Outlook, where you create an Application and work down from there. Generally one level down from there is something like Document that has a method that will open a file.
Note that, most commonly, you create the type of database you want in the Access environment and then add/look at data from it through other code.
-Tarn |
|
|
|
|
Tarn
GURU
Joined: 10 Oct 2000
Posts: 873
Location: USA
|
Posted: Sun Jan 13, 2002 1:42 am
|
http://office.microsoft.com/assistance/offhelp/off2000/access/
Is probably the most interesting resource. Under the Microsoft Access menu, there's a Programming Information section.
A quick look makes me think the DoCmd object might be the easiest way to get in, depending on what you want to do.
-Tarn |
|
|
|
|
Darker
GURU
Joined: 24 Sep 2000
Posts: 1237
Location: USA
|
Posted: Sun Jan 13, 2002 4:04 am
|
You could probably just use ADO and specify access as the datasource, y'know. 
zMUD 6 Online Help: All the power you'll ever need. |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Sun Jan 13, 2002 5:39 am
|
sorry darker,. ado? what?
please explain what ado is and workings
thanks
karthic
karthic |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Sun Jan 13, 2002 5:47 am
|
well.. i got the ado? data thingy to point to my access db.. but i dont know the meanin of all this...
explain please?
thanks
karthic
karthic |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Sun Jan 13, 2002 6:42 am
|
WELL. . IT looks like i post to quickly...
ok.. ado..
i know how to link "com" to "access.application"...
but .. how do i link it to ado?
ado.application doesnt work,,,
thanks
karthic
karthic |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Sun Jan 13, 2002 10:43 am
|
wait.. dern it.. gezz.. i post to so.. to learn new things so fast..
well.. figgurin it out..
its not all that hard.. just a dern pain
wave
i'll post again.. if i cant figgure something out... well.. i'll give it a day
karthic
karthic |
|
|
|
|
|
|
|
