me.listbox.value - where are the docs?

W

WebDude

Im six months into MS ACCESS 2000,
and as i search the newsgroups for answers
to my questions im also reading about usefull
commands that i have not found in the "online" help.

Take for instance me.listbox.VALUE which returns
data in the Bound Column of the row selected
by the user. Its not in the online help.

So i was doing this;
=Me.listbox.itemData(Me.ListBox.ListIndex)

:-|

I dont understand how they go to all the trouble of
creating commands when we cant use them if they
arent listed. There should be a PDF with ALL
ms access commands listed, simple.

I got ms access when i bought my computer
from DELL (they sent me ms office 2000 CD).
So, I guess, had i purchased just ms access,
say from a computer store, i would have got
a big manual tooo.. yes/no? And i know there
are tons of ms access books on amazon.

....I was just expecting
better online docs from the office cd.

Cheers,
Webdude
 
B

Brendan Reynolds

Open the VBA editor and from the Help menu choose the first item, Microsoft
Visual Basic Help. In the Table of Contents, expand the first topic,
Microsoft Access Visual Basic Reference.

Note, though, that the methods, properties and events in the Access object
model are just a small subset of the methods, properties and events
(collectively referred to as 'members') that may be available to you in an
Access application. In Access 2003, when you create a new, empty MDB, it
contains references to five different type libraries - VBA, Access, OLE
Automation, DAO, and ADO - making the members of all five libraries
available to you. (The exact references included by default in a new MDB
differ somewhat from version to version). You can use the members of many
other type libraries by adding references to them - in the VBA editor,
select References from the Tools menu to see a list of type libraries on
your system - and you can even create your own libraries. The answer to the
question of what commands are available to you is, therefore, not nearly as
straightforward as it may at first seem.
 
V

Van T. Dinh

If you check the (off-line) Access VB Help on Value Property, you would have
found it. This is what I got:

"ListBox Value: The value in the bound column for the item selected in the
list."

I prefer to use the "off-line" Help before I go to the "on-line" Help.
"Off-line" Help actually has a lot of precise / concise information if you
search / use it correctly.

Most software don't come with printed manuals nowadays... I think the last
Access version that has a printed manual is Access97.
 
W

WebDude

Sir Van,

OFF-line HELP? .......There is an off-line help?!...Where be it this
Off-line help you speak so fondly of ???? Sounds like what i need!

Sincerely,
WebDude XIV
 
W

WebDude

Hello :)

Iiiiii'm.... then i guess.. just looking for a complete list of all commands
in the core set of libraries - the libraries which come with every copy of
MsAccess2000. And I gather from your post that the five core libraries are;

VBA, Access, OLE Automation, DAO, and ADO


Does Oracle use VBA? cause i spent some time programming
Oracle and it seemed alot easier then Access.

WebDude out.
 
B

Brendan Reynolds

The VBA and Access references are always included and can not be removed. I
don't know what OLE Automation does. Access adds it by default to new MDBs,
but I always remove it from production apps and have never had anything stop
working as a result of removing it. ADO and DAO are alternative data access
technologies, you don't really need both. So while there are plenty of
exceptions that will need references to additional object libraries, most
Access apps will get by with references to three object libraries - VBA,
Access, and one or the other of either ADO or DAO.

I don't have access (no pun intended) to Access 2000 right now. In Access
2003, I can find help on all of these object libraries by choosing Microsoft
Visual Basic Help from the Help menu in the VBA editor (not the main Access
window). Unfortunately, you may not find them so easily in Access 2000 - the
help system was rather poor in that version. If you have difficulty finding
what you're looking for in the help system, try the MSDN library at
http://msdn.microsoft.com/library
 
V

Van T. Dinh

The Help that's available under the Menu Help in the MenuBar.

On-line Help or more specifically, "Search online content when connected"
has only been available in A2003. I turned this option off and use only the
Help that was installed with the software on the work-station. If I need
more help than the Access inbuilt / off-line Help, I search the Microsoft
Knowledge Base separately.
 
W

WebDude

That is the Help Menu i have been using infact.. i call it "online help"
cause i didnt realize everyone else was actually getting help online from a
microsoft website, i just thought they were referring to the help in the menu
bar.


Anyways, If a newbie wants to place a Listbox control on a form, and
subsequently wanted to know all the available arguments/commands he can use
for that list box... No search, in the help menu, using the keyword "LISTBOX"
will show you that "listbox.VALUE" is a viable command.

Incidentally, I only found out there was a listbox.value command by reading
thru the newsgroups. With out these newsgroups, i would have gone
completely
and
utterly
insane.


Regards,
Webdude



ps: As a newbie with out a list of syntax/commands i would have never known
to enter "Value Property" in the help menu, as you did.
 
V

Van T. Dinh

IMHO, the best way to find these is to use the Object Browser which lists
all Properties and Methods related to each object.

OTOH, reading an Access book / Access programming book thoroughly will show
you how to use these programming features as well as most common objects /
properties also ...

Have you read any Access book?
 
W

WebDude

Van T. Dinh said:
IMHO, the best way to find these is to use the Object Browser which lists
all Properties and Methods related to each object.
Click to expand...

Ah ha! I just took a look at the Object Browser in vba! that takes alot of
the guess work out of knowing which commands are available to make my program
with.
Thanks VAN Dinh! :)


OTOH, reading an Access book / Access programming book thoroughly will show
you how to use these programming features as well as most common objects /
properties also ...

Have you read any Access book?
Click to expand...


Not.. exactly.. i got the "Access Bible" in a 16 meg PDF but when i needed
help to do something it wasnt very helpful. Or maybe i was trying to do
something which access doesnt support, i forget, its been a while since i
had a look at that pdf.

But if my boss thinks my work is good and then msybe he will buy me a big
book on ms access.

Cheers,
WebDude out.

thanks again :)
 
Top