Access 2000 help can't find what I know exists...

[Guest]

I posted here several months ago with this problem, and have since taken it
up with internal support at my company which have recently given up.

Do this...

On the Index tab in help, type cint (for the convert to integer function).
My version can't find it, and brings up Circle, which is as close as it gets.

Interal support says they have installed all the help and don't know what
else to do.

Thanks for any help you can provide.

 

[Brian Bastl]

Not available in Access Help. You'll need to open the VBA Help file.

CInt Function Example
This example uses the CInt function to convert a value to an Integer.

Dim MyDouble, MyInt
MyDouble = 2345.5678 ' MyDouble is a Double.
MyInt = CInt(MyDouble) ' MyInt contains 2346.
Brian

 

[Guest]

Brian, (and Adrian)

Thanks for the response...same exact problem, just with

Microsoft Visual Basic - General - ...

At the top of the screen.

What next?

 

[Brian Bastl]

Don't know since it works for me, although my caption reads:
'Microsoft Visual Basic Help'. Did you open the VBA editor, and then hit F1?

Brian

 

[Brian Bastl]

try typing 'conversion' in the text box, and select 'conversion functions'
from the bottom list.

Brian

 

[Guest]

If it helps, if I try Count (the aggregate function in SQL), it won't find
help either. It will show the Count property used for a recordset or form,
but not the count function for SQL.

If I try AVG for the average function, it DOES show up in the list box
(Microsoft JET SQL), but clicking on it doesn't do anything...there is
obviously no help for it.

 

[Guest]

Yep.

Don't know since it works for me, although my caption reads:
'Microsoft Visual Basic Help'. Did you open the VBA editor, and then hit F1?

Brian

 

[Guest]

Try finding it using the Contents tab. For Access 2002, the following should
work. Other versions may be slightly different...

1.) Expand "Visual Basic Language Reference"
2.) Expand "Functions", then expand "A-C".

You should see CInt in the list at this point. Another method that works is
to use the Object Browser. From the VBA editor, click on View > Object
Browser (or use F2). Enter CInt as the search term with All Libraries
selected. (This will be all libraries that you currently have a reference set
to). You should see CInt in the list. Select it and then click on the yellow
question mark button.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

typing conversion, doesn't bring up 'conversion functions'...it brings up a
slew of things but not that. Top of the list is CONVERT worksheet function.
(Excel I guess)

 

[Guest]

OK Tom, that found it, now I know I'm going to hate the answer to the
following up question...

I use VBA functions in SQL ALL the time, and WAS used to be able to hit help
to remind me of syntax, or follow the 'see also' list to learn even better
ones...is that ability gone?

 

[Brian Bastl]

I had a similar issue when I uninstalled my german version of access, and
replaced it with the english version. My help files lost their association.
I'd suspect that someone qualified will have to play with your registry
settings.

Brian

 

[Guest]

In query design view, using Access 2002, I can click on Help > Microsoft
Access Help. Then I select the Contents tab again. Find "Programming in
Visual Basic" in the list and expand this. Then drill down to "Visual Basic
Language Reference". Then "Functions" and finally "A-C".


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

OK Tom, that found it, now I know I'm going to hate the answer to the
following up question...

I use VBA functions in SQL ALL the time, and WAS used to be able to hit help
to remind me of syntax, or follow the 'see also' list to learn even better
ones...is that ability gone?

 

[Guest]

I used to rely heavily on Access Help's ability to lead one through related
functions and services just by typing general search criteria like 'integer'
or 'conversion', but that is apparently gone. Why MS would remove that
feature is stunning.

thanks for the help.