VbMsgBoxStyle

Geoff · Joined: 04 Oct 2007 Posts: 20

If this isn't the right newsgroup, please let me know which one is.

1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?

2. I think they did not exist in Office 97 but did in Office 2000. Is
that right?

(I've spent an hour trying to find this information on the Microsoft
website, with no success.)

3. Does anyone know if the Microsoft website contains:

(a) The object models for each version of VBA (or VB)?
(b) A language reference for each version of VBA (or VB)?
(c) Some clues about when the different versions were introduced?
(d) Can the OLB files be downloaded for different versions of VBA? (I'm
trying to set references using the Reference object in Access and I need to
know the GUID, major and minor numbers.)

The following sites didn't help:

MSDN: What's new in Visual Basic?
http://msdn.microsoft.com/office/previous/
http://msdn.microsoft.com/office/reference/vba/

Background:

The above questions stem from the fact that I'm enhancing an Access 2000
database. I'm using Access 2002 for the development work. One user uses
Access 2000 and another (I believe) uses Access 2003. I'm not sure yet if I
can write and run code on database startup that will determine which version
of Access, Word and Outlook they are using and fix the references
accordingly. There's a lot of code that uses early binding to these other
applications, which I wouldn't want to change. I'm hoping that if such
startup code is in its own module, Access will only need to compile that
module in order to run that code, which gives me the chance to quit Access
if not all required references can't be set. Any further pointers on this
subject are very welcome.

TIA.
Geoff

Archived from group: microsoft>public>vb>syntax

Dmitriy Antonov · Joined: 04 Oct 2007 Posts: 431

"Geoff" wrote in message @TK2MSFTNGP02.phx.gbl...
> If this isn't the right newsgroup, please let me know which one is.
>
> 1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?
>
> 2. I think they did not exist in Office 97 but did in Office 2000. Is
> that right?
>
> (I've spent an hour trying to find this information on the Microsoft
> website, with no success.)
>
> 3. Does anyone know if the Microsoft website contains:
>
> (a) The object models for each version of VBA (or VB)?
> (b) A language reference for each version of VBA (or VB)?
> (c) Some clues about when the different versions were introduced?
> (d) Can the OLB files be downloaded for different versions of VBA? (I'm
> trying to set references using the Reference object in Access and I need
> to know the GUID, major and minor numbers.)
>
> The following sites didn't help:
>
> MSDN: What's new in Visual Basic?
> http://msdn.microsoft.com/office/previous/
> http://msdn.microsoft.com/office/reference/vba/
>
> Background:
>
> The above questions stem from the fact that I'm enhancing an Access 2000
> database. I'm using Access 2002 for the development work. One user uses
> Access 2000 and another (I believe) uses Access 2003. I'm not sure yet if
> I can write and run code on database startup that will determine which
> version of Access, Word and Outlook they are using and fix the references
> accordingly. There's a lot of code that uses early binding to these other
> applications, which I wouldn't want to change. I'm hoping that if such
> startup code is in its own module, Access will only need to compile that
> module in order to run that code, which gives me the chance to quit Access
> if not all required references can't be set. Any further pointers on this
> subject are very welcome.
>
> TIA.
> Geoff
>

I don't know when those enum were introduced first, but they do exist in
Access97.

I don't think you need to make such extensive "historical" research for a
simple matter. General way of doing such things is to use lowest versions of
all components. If you use Access2002, you still can create a file in
Access2000 format (they are not really different in any noticeable way,
IMO). And it should work for both of your mentioned clients. And when I use
Word and Outlook libs I generally use the one, which exists on my PC and,
there are good chances, that it will work on other computers without
problems (including those with lower versions). Anyway, you should test it
and make adjustments if necessary.

Dmitriy.

Karl E. Peterson · Joined: 04 Oct 2007 Posts: 4836

You'll find a *lot* more in-depth VBA knowledge in a group that contains
"vba" in its name. This one is mainly populated by folks using ClassicVB
(VB6 and earlier), although some certainly use VBA as well on occassion.
--
Working without a .NET?
http://classicvb.org/

Geoff wrote:
> If this isn't the right newsgroup, please let me know which one is.
>
> 1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?
>
> 2. I think they did not exist in Office 97 but did in Office 2000.
> Is that right?
>
> (I've spent an hour trying to find this information on the Microsoft
> website, with no success.)
>
> 3. Does anyone know if the Microsoft website contains:
>
> (a) The object models for each version of VBA (or VB)?
> (b) A language reference for each version of VBA (or VB)?
> (c) Some clues about when the different versions were introduced?
> (d) Can the OLB files be downloaded for different versions of VBA?
> (I'm trying to set references using the Reference object in Access
> and I need to know the GUID, major and minor numbers.)
>
> The following sites didn't help:
>
> MSDN: What's new in Visual Basic?
> http://msdn.microsoft.com/office/previous/
> http://msdn.microsoft.com/office/reference/vba/
>
> Background:
>
> The above questions stem from the fact that I'm enhancing an Access
> 2000 database. I'm using Access 2002 for the development work. One
> user uses Access 2000 and another (I believe) uses Access 2003. I'm
> not sure yet if I can write and run code on database startup that
> will determine which version of Access, Word and Outlook they are
> using and fix the references accordingly. There's a lot of code that
> uses early binding to these other applications, which I wouldn't want
> to change. I'm hoping that if such startup code is in its own module,
> Access will only need to compile that module in order to run that
> code, which gives me the chance to quit Access if not all required
> references can't be set. Any further pointers on this subject are
> very welcome.
>
> TIA.
> Geoff

Geoff · Joined: 04 Oct 2007 Posts: 20

Karl,

Thanks for your reply and apologies for my absurdly late response.

Thanks for the pointer. I'm a VB6 and VBA user (as it manifests itself in
Office 2000/2002). I've not made the transition to VB.NET, so most of my
problems are with classic syntax.

I've been amused to read the hullabaloo over classic/net issues.

Thanks again.
Regards.
Geoff

"Karl E. Peterson" wrote in message @TK2MSFTNGP06.phx.gbl...
> You'll find a *lot* more in-depth VBA knowledge in a group that contains
> "vba" in its name. This one is mainly populated by folks using ClassicVB
> (VB6 and earlier), although some certainly use VBA as well on occassion.
> --
> Working without a .NET?
> http://classicvb.org/
>
>
> Geoff wrote:
>> If this isn't the right newsgroup, please let me know which one is.
>>
>> 1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?
>>
>> 2. I think they did not exist in Office 97 but did in Office 2000.
>> Is that right?
>>
>> (I've spent an hour trying to find this information on the Microsoft
>> website, with no success.)
>>
>> 3. Does anyone know if the Microsoft website contains:
>>
>> (a) The object models for each version of VBA (or VB)?
>> (b) A language reference for each version of VBA (or VB)?
>> (c) Some clues about when the different versions were introduced?
>> (d) Can the OLB files be downloaded for different versions of VBA?
>> (I'm trying to set references using the Reference object in Access
>> and I need to know the GUID, major and minor numbers.)
>>
>> The following sites didn't help:
>>
>> MSDN: What's new in Visual Basic?
>> http://msdn.microsoft.com/office/previous/
>> http://msdn.microsoft.com/office/reference/vba/
>>
>> Background:
>>
>> The above questions stem from the fact that I'm enhancing an Access
>> 2000 database. I'm using Access 2002 for the development work. One
>> user uses Access 2000 and another (I believe) uses Access 2003. I'm
>> not sure yet if I can write and run code on database startup that
>> will determine which version of Access, Word and Outlook they are
>> using and fix the references accordingly. There's a lot of code that
>> uses early binding to these other applications, which I wouldn't want
>> to change. I'm hoping that if such startup code is in its own module,
>> Access will only need to compile that module in order to run that
>> code, which gives me the chance to quit Access if not all required
>> references can't be set. Any further pointers on this subject are
>> very welcome.
>>
>> TIA.
>> Geoff
>
>
>

Geoff · Joined: 04 Oct 2007 Posts: 20

Dmitriy:

Many thanks for your reply and apologies for my pathetically late response.

As you no doubt realised, my questions about the MsgBox function were a
means to an end. My purpose was to ascertain if I could find out from the
Microsoft website when programming features were introduced since I don't
want to write VBA code in Access 2002 that won't run in Access 2000.

The following may not be a good example but just for illustration: I've
discovered that Access 2000 does not have an event for when a data-entry
form becomes clean, but Access 2002 does (the Form_Undo event). I started
writing code for the Form_Undo event and then realised that my Access 2000
user would run into trouble. So what I need for ongoing development is the
means to find out from the Microsoft website what the object models/features
are for the various versions of Access and VBA and other Microsoft Office
products.

As far as the reference to Word is concerned, this is what I've found:

As mentioned, I'm doing the development in Access/Office 2002. So on my
computer, the Access 2002 database has a reference to Word 2002. When the
Access 2000 user opens the database, the code won't compile. When the
compiler hits a code line that refers to the Word library, it stops, opens
the VBA editor and pauses on that code line. This happens because the link
to the Word 2002 library is broken and Access 2000 does not automatically
substitute a reference to the Word 2000 library. The user has to fix the
reference manually and then everything is OK. This is not great given the
level of competency of the user concerned.

As far as the user using Access 2003 is concerned, I'm not sure I have a
reliable report as to what's happening. He implies that Access 2003 fixes
the references automatically. But I've not seen this happen myself.

So, my aim is twofold:

1. To write code that is compatible with Access 2000. Sometimes I need
to check what is compatible.

2. To write startup code that will fix references. This is proving
tricky. It seems I need to get the latest major and minor version numbers
of Word from the registry using Word's GUID. (I say "latest" because more
than one version of Microsoft Office could be installed.)

It's all seemingly unnecessarily complicated, though I can understand why
the products work the way they do.

"Heigh-ho, the Wind and the Rain" as King Lear would say.

Thanks again for your reply.
Geoff

"Dmitriy Antonov" wrote in message%23L%23nN5GHA.3428@TK2MSFTNGP04.phx.gbl...
>
> "Geoff" wrote in message
> @TK2MSFTNGP02.phx.gbl...
>> If this isn't the right newsgroup, please let me know which one is.
>>
>> 1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?
>>
>> 2. I think they did not exist in Office 97 but did in Office 2000. Is
>> that right?
>>
>> (I've spent an hour trying to find this information on the Microsoft
>> website, with no success.)
>>
>> 3. Does anyone know if the Microsoft website contains:
>>
>> (a) The object models for each version of VBA (or VB)?
>> (b) A language reference for each version of VBA (or VB)?
>> (c) Some clues about when the different versions were introduced?
>> (d) Can the OLB files be downloaded for different versions of VBA?
>> (I'm trying to set references using the Reference object in Access and I
>> need to know the GUID, major and minor numbers.)
>>
>> The following sites didn't help:
>>
>> MSDN: What's new in Visual Basic?
>> http://msdn.microsoft.com/office/previous/
>> http://msdn.microsoft.com/office/reference/vba/
>>
>> Background:
>>
>> The above questions stem from the fact that I'm enhancing an Access 2000
>> database. I'm using Access 2002 for the development work. One user uses
>> Access 2000 and another (I believe) uses Access 2003. I'm not sure yet if
>> I can write and run code on database startup that will determine which
>> version of Access, Word and Outlook they are using and fix the references
>> accordingly. There's a lot of code that uses early binding to these other
>> applications, which I wouldn't want to change. I'm hoping that if such
>> startup code is in its own module, Access will only need to compile that
>> module in order to run that code, which gives me the chance to quit
>> Access if not all required references can't be set. Any further pointers
>> on this subject are very welcome.
>>
>> TIA.
>> Geoff
>>
>
> I don't know when those enum were introduced first, but they do exist in
> Access97.
>
> I don't think you need to make such extensive "historical" research for a
> simple matter. General way of doing such things is to use lowest versions
> of all components. If you use Access2002, you still can create a file in
> Access2000 format (they are not really different in any noticeable way,
> IMO). And it should work for both of your mentioned clients. And when I
> use Word and Outlook libs I generally use the one, which exists on my PC
> and, there are good chances, that it will work on other computers without
> problems (including those with lower versions). Anyway, you should test it
> and make adjustments if necessary.
>
> Dmitriy.
>
>
>

Jan Hyde · Joined: 04 Oct 2007 Posts: 1211

"Geoff" 's wild thoughts were released on
Tue, 7 Nov 2006 12:00:58 -0000 bearing the following fruit:

>So, my aim is twofold:
>
>1. To write code that is compatible with Access 2000. Sometimes I need
>to check what is compatible.
>
>2. To write startup code that will fix references. This is proving
>tricky. It seems I need to get the latest major and minor version numbers
>of Word from the registry using Word's GUID. (I say "latest" because more
>than one version of Microsoft Office could be installed.)

You should develop with the minimum version you expect to
support, then these issues no longer exist.

J

>
>
>"Dmitriy Antonov" wrote in message
>%23L%23nN5GHA.3428@TK2MSFTNGP04.phx.gbl...
>>
>> "Geoff" wrote in message
>> @TK2MSFTNGP02.phx.gbl...
>>> If this isn't the right newsgroup, please let me know which one is.
>>>
>>> 1. When were VbMsgBoxStyle and VbMsgBoxResult introduced?
>>>
>>> 2. I think they did not exist in Office 97 but did in Office 2000. Is
>>> that right?
>>>
>>> (I've spent an hour trying to find this information on the Microsoft
>>> website, with no success.)
>>>
>>> 3. Does anyone know if the Microsoft website contains:
>>>
>>> (a) The object models for each version of VBA (or VB)?
>>> (b) A language reference for each version of VBA (or VB)?
>>> (c) Some clues about when the different versions were introduced?
>>> (d) Can the OLB files be downloaded for different versions of VBA?
>>> (I'm trying to set references using the Reference object in Access and I
>>> need to know the GUID, major and minor numbers.)
>>>
>>> The following sites didn't help:
>>>
>>> MSDN: What's new in Visual Basic?
>>> http://msdn.microsoft.com/office/previous/
>>> http://msdn.microsoft.com/office/reference/vba/
>>>
>>> Background:
>>>
>>> The above questions stem from the fact that I'm enhancing an Access 2000
>>> database. I'm using Access 2002 for the development work. One user uses
>>> Access 2000 and another (I believe) uses Access 2003. I'm not sure yet if
>>> I can write and run code on database startup that will determine which
>>> version of Access, Word and Outlook they are using and fix the references
>>> accordingly. There's a lot of code that uses early binding to these other
>>> applications, which I wouldn't want to change. I'm hoping that if such
>>> startup code is in its own module, Access will only need to compile that
>>> module in order to run that code, which gives me the chance to quit
>>> Access if not all required references can't be set. Any further pointers
>>> on this subject are very welcome.
>>>
>>> TIA.
>>> Geoff
>>>
>>
>> I don't know when those enum were introduced first, but they do exist in
>> Access97.
>>
>> I don't think you need to make such extensive "historical" research for a
>> simple matter. General way of doing such things is to use lowest versions
>> of all components. If you use Access2002, you still can create a file in
>> Access2000 format (they are not really different in any noticeable way,
>> IMO). And it should work for both of your mentioned clients. And when I
>> use Word and Outlook libs I generally use the one, which exists on my PC
>> and, there are good chances, that it will work on other computers without
>> problems (including those with lower versions). Anyway, you should test it
>> and make adjustments if necessary.
>>
>> Dmitriy.
>>
>>
>>
>
>
>
>
>
>
>

Jan Hyde (VB MVP)

--
So I went to the Chinese restaurant and this duck came up to me with a red rose and says "Your eyes sparkle like diamonds". I said "Waiter I asked for a-ROMATIC duck".

Bob O`Bob · Joined: 04 Oct 2007 Posts: 1456

Jan Hyde wrote:
> "Geoff" 's wild thoughts were released on
> Tue, 7 Nov 2006 12:00:58 -0000 bearing the following fruit:
>
>
>> So, my aim is twofold:
>>
>> 1. To write code that is compatible with Access 2000. Sometimes I need
>> to check what is compatible.
>>
>> 2. To write startup code that will fix references. This is proving
>> tricky. It seems I need to get the latest major and minor version numbers
>> of Word from the registry using Word's GUID. (I say "latest" because more
>> than one version of Microsoft Office could be installed.)
>
>
> You should develop with the minimum version you expect to
> support, then these issues no longer exist.

HEAR! HEAR!

Bob
(still using vb6sp3 on Win95b for almost *every* compile)

Geoff · Joined: 04 Oct 2007 Posts: 20

Jan/Bob,

>> You should develop with the minimum version you expect to
>> support, then these issues no longer exist.
> HEAR! HEAR!

Many thanks for you replies. I understand and take your point. But I'm not
sure that developing with the minimum version would make the issues
disappear. As far as syntax is concerned, Access 2003 complains like mad
when an earlier-version Access database is loaded - saying that possible
dangerous expressions need to be blocked and that a service pack needs to be
downloaded for this to happen automatically. (The earlier-version database
simply contains code that ran perfectly under the earlier version of Access
and the database does not contain a virus.) Also, it seems (but as I said
before, I'm not sure) that later versions may not automatically fix broken
references - meaning that they've either got to be fixed manually or
programmatically.

Naturally, I take the general point you make - that later versions would be,
for the most part, backwardly compatible. But it's not cost-efficient for
me to maintain earlier versions of Office products just because some
customers won't upgrade. It's a problem I guess many developers face.....

Best regards
Geoff

How to install my sofwtare on win xp with windows file prote Hi My application uses JET 4.0 dll's and some OLE libraries. Should i distribute them for XP machines? I get some problems because of windows file protection I am using wise installer thanks in advance.

InterProcess Communications Hi, I have an app that creates several subprocesses and I need to have them communicated all the time, but I can not figure out how to have subprocesses communicated with their parent. The communication has to be in two ways so the childs can report their

Need VB Type Def for HENHMETAFILE Hi, From API Text Viewer, I couldn't get the typedef for HENHMETAFILE. How to type def it in VB6? Is there some other equivalent? ThanQ...

ExtractIcon help The ExtractIcon function will get an icon from a dll, ico, or exe file. I'm trying to find a way to extract an icon from a running application, given the application's handle. And as long as I'm asking.... Once I get the handle to the application's icon,

Get Hwnd Hi, Im making a control program for another program and im using sendmessage api to set text to text boxes and sendmessage api to push buttons.. My problem is i need the indevidual hwnd's of two textboxes that have the same class, same parrent, and i can