VBA help file faulty?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My help file, latest downloaded from here, is VBAAC10.CHM dated 13 aug 2004
13:06 has no contents for StartupMenuBar and similar properties.

I notice there are no entries for it here in MSDN either under Access 2003

How do I notify the powers that be so that it can be corrected.

And in the meanwhile where can I find the information I need on setting
Access startup properties via VB?
 
Thanks BUT - as I understand it the startup options control how this instance
of Access, i.e. the thing running the code that sets the options, behaves
whereas I wish to set the attributes of a particular database, through its
properties.

Also - I am still none the wiser as to the state of my help file - is it
corrupt or is it just that MS have compiled it badly?

Thanks agina

William Hite

Allen Browne said:
Try this article for setting the startup options:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acglobaloptions.asp
Click to expand...
 
William said:
Thanks BUT - as I understand it the startup options control how this
instance of Access, i.e. the thing running the code that sets the
options, behaves whereas I wish to set the attributes of a particular
database, through its properties.
Click to expand...

Incorrect. Startup options relate to "This file". They are not even available
on the menu until you open a file.
 
As far as I can tell, there is no built-in property called 'StartupMenuBar'.
Perhaps you were looking for Application.MenuBar?

--
Brendan Reynolds (MVP)


William Hite said:
Thanks BUT - as I understand it the startup options control how this
instance
of Access, i.e. the thing running the code that sets the options, behaves
whereas I wish to set the attributes of a particular database, through its
properties.

Also - I am still none the wiser as to the state of my help file - is it
corrupt or is it just that MS have compiled it badly?

Thanks agina

William Hite
Click to expand...
 
From Access 2003 VBA I searched for help "Set Startup Properties from Visual
Basic"

I get three results.

For the entry "Set Startup Properties from Visual Basic" I get:
The names of the startup properties differ from the text that appears in the
Startup dialog box, available by clicking Startup on the Tools menu. The following
table provides the name of each startup property as it's used in Visual Basic code.

Text in Startup dialog box Property name
Application Title AppTitle
Application Icon AppIcon
Display Form/Page StartupForm
Display Database Window StartupShowDBWindow
Display Status Bar StartupShowStatusBar
Menu Bar StartupMenuBar
Click to expand...

If I look at the properties of the StartupMenuBar item I see

mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\vbaac10.chm::/html/acproStartupMenuBar.htm

When I click on it I get the message "The page cannot be displayed" i.e. not
found in the help file.

do you get similar?
 
Thanks for input but it doesn't seem to relate to what my help tells me:
Set Startup Properties and Options in Code
Startup properties affect how your database application appears when it's
opened. For example, startup properties enable you to customize the
application's title bar, menus, toolbars, and startup form. To view the
properties in the Startup dialog box, click Startup on the Tools menu.

You can set options in the Options dialog box to change various aspects of the
application's environment while you're working in it. For example, you can set
form, report, table, and query default options. To view the Options dialog box,
click Options on the Tools menu.

The following topics provide specific information about setting startup properties
and options in code.

Set Startup Properties from Visual Basic
Set Options from Visual Basic
Click to expand...

So clearly there is a substantial difference between setting options (the
thing I don't want to do) and setting the database properties (the thing I do
want to do).

As I understand it the properties live inside the MDB as static attributes
that govern how the enclosing application (MSACCESS.EXE) displays itself and
runs when it is loaded - regardless of what options are set for that instance
of MSACCESS.

I fully accept that my interpretation may be wrong so would welcome
clarification.

thanks
 
To clarify further - AIUI the key difference between setting the startup
properties for an MDB and that MDB running some code that changes the options
is exactly that - the option changing relies on code running whereas the
properties are enforced even if the client PC stops code from executing.

Is that right?

William hite.
 
Ah, here we are, it's one of those extended properties that don't exist
until you either create them programmatically or assign a value to them via
the UI ...

<quote>
To set the StartupMenuBar property by using a macro or Visual Basic, you
must first either set the property in the Startup dialog box once or or
create the property in the following ways:

In a Microsoft Access database (.mdb), you can add it by using the
CreateProperty method and append it to the Properties collection of the
Database object.

In a Microsoft Access project (.adp), you can add it to the
AccessObjectProperties collection of the CurrentProject object by using the
Add method.
</quote>
 
Exactly - and that is what I am doing. The mystery is that for my particular
database it is not working properly and to fix it I would like to read the
help for the property - and the other ones. That help is definitely missing
here - does your version have it?
 
Fixed at last - my createproperty statement was failing and I couldn't figure
out why and wanted to see that I had the correct property type - hence the
need for a help file that works.

Failing code was this
dim lProp as Property

Working code is this
dim lProp as DAO.property

So it was just the variable typing...
 
I got to the 'Set startup properties from Visual Basic' topic as you
described, and followed a link from there to the 'StartupMenuBar Property'
topic. Here's the URL for the topic in the MSDN library. This is in the
Access 2002 documentation, I couldn't find an on-line Access 2003 version,
but as far as I can see, the on-line Access 2002 article appears to be
word-for-word identical to my local Access 2003 version

http://msdn.microsoft.com/library/d...ry/en-us/vbaac10/html/acprostartupmenubar.asp
 
Thanks - I have that

You say it is word for word as per your local help file. My local help file
has an index entry for the property but cannot display it. the name of the
help file is vbaac10.chm i.ee the same as the one you have quoted from msdn
online.

Does this mean you have a local version that differs from mine? If so I
shall have to see if I can get a new version.
 
My help file differs in that it displays the topic correctly, yes. You
mentioned that you had downloaded your help file 'from here'. I wonder what
you meant by 'here'? Where exactly did your help file come from?

The date on my help file is 3 July 2003. I can't remember now exactly when
Office 2003 was released, but I think this *probably* indicates that this is
the version released along with Office 2003. It certainly is too early to
have been updated by SP1.
 
Yes, the topic seems to have been mislaid in that copy of the help file.
There doesn't seem to be any feedback link on the download page. I'll try
and get someone to pass this information on to those responsible.
 
Back
Top