Hi ,
I'm wondering it there is a way to notify users of the need to use a
different version of Access (2003). I have an Access 2003 mde file that
can't be opened by Access 2000-2002 users. I would like to pop up a message
(instead of the Access error message that it does not recognize the format),
telling the user that they need to be running Access 2003.
A background note - I am developing in 2002/2003 format on a machine running
2003, so I produce the mde in 2003. As I recall, there was a need to move to
the 2002-2003 environment from 2000 because of the need to use OpenArgs when
using DoCmd.OpenRepor t (as 2000 did not have an OpenArgs parameter option).
Any help is appreciated,
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200702/1 5 1565
jamcompany via AccessMonster.c om wrote:
Hi ,
I'm wondering it there is a way to notify users of the need to use a
different version of Access (2003). I have an Access 2003 mde file
that can't be opened by Access 2000-2002 users. I would like to pop
up a message (instead of the Access error message that it does not
recognize the format), telling the user that they need to be running
Access 2003.
A background note - I am developing in 2002/2003 format on a machine
running 2003, so I produce the mde in 2003. As I recall, there was a
need to move to the 2002-2003 environment from 2000 because of the
need to use OpenArgs when using DoCmd.OpenRepor t (as 2000 did not
have an OpenArgs parameter option).
Any help is appreciated,
In order to run your code that displays your message the file would need to be
successfully opened which is impossible when they have the wrong version.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Ugh - that's what I suspected. Did I just paint myself into a corner by
implementing a new OpenReport method (one with the OpenArgs parameter)? I
really didn't see another choice in order to get the functionality I needed
on the report side of the application.
Any suggestions?
Rick Brandt wrote:
>Hi ,
[quoted text clipped - 12 lines]
>> Any help is appreciated,
In order to run your code that displays your message the file would need to be successfully opened which is impossible when they have the wrong version.
--
Phil
Message posted via http://www.accessmonster.com
jamcompany via AccessMonster.c om wrote:
Ugh - that's what I suspected. Did I just paint myself into a corner
by implementing a new OpenReport method (one with the OpenArgs
parameter)? I really didn't see another choice in order to get the
functionality I needed on the report side of the application.
Any suggestions?
I have no idea what you are talking about with your report. A user with the
wrong version will get an error. When they ask about it tell them they have the
wrong version. Happens all the time with software.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
"jamcompany via AccessMonster.c om" <u19089@uweschr eef in bericht news:6d9278c47e aa0@uwe...
Ugh - that's what I suspected. Did I just paint myself into a corner by
implementing a new OpenReport method (one with the OpenArgs parameter)? I
really didn't see another choice in order to get the functionality I needed
on the report side of the application.
Any suggestions?
Use Access2000 to develop, and you can deploy your mdb/mde to anyone who has A2000, A2002 or A2003.
Tell us what you are trying to achieve with the openargs
I guess you must be able to find a workaround for the openargs param of your report.
Arno R
jamcompany via AccessMonster.c om wrote:
Ugh - that's what I suspected. Did I just paint myself into a corner by
implementing a new OpenReport method (one with the OpenArgs parameter)? I
really didn't see another choice in order to get the functionality I needed
on the report side of the application.
Any suggestions?
If the openargs value is coming from a calling form, then you could just
refer back to that form to get the value.
eg.
Where Me!MyOption is a control on the form that holds the value the
OpenArg (it can be a hidden control that is used just to hold this value).
If the code in the calling form is something like:
DoCmd.OpenRepor t "MyReport",,,,M e!MyOption
Then instead do something like this in the On_Open event code:
Select Case Forms!MyForm!My Option
Case 1
'Do some stuff
Case 2
'Do other stuff
Case 3
'And so on
End Select
Hopefully that will give some ideas on how to get around the OpenArgs.
I've done this sort of thing myself as I primarily code in AC97 and then
convert as needed.
--
Bri This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Wayne Aprato |
last post by:
I have several Access 97 databases which are split into front end and
back end running off a server. The front end mde is shared by 2 or 3
- absolute maximum of 6 concurrent users. This scenario has been
working flawlessly for about 2 years. I am now at a point where these
databases need to be converted to Access 2003.
I think I read somewhere on this forum that the newer versions of
Access are not as tolerant to multiple users...
|
by: Serious_Practitioner |
last post by:
Hello, all -
A few days ago, I posted the following message -
Hello all, and thank you for your help in the recent past.
Got a new error message in the last few days.
While working with different sized tables, in datasheet view, I've
gotten this message -
|
by: Serious_Practitioner |
last post by:
Good day -
As you suggested, I got and used the right version of Jetcomp, and I also
tried to run compact and repair a couple of times. I think that the compact
and repair process doesn't fully complete - there's a little progress bar in
the lower left area of the status bar that gets about halfway done, and then
stalls. It doesn't keep me from closing the database, it just stops. So that
seems to be out. Similarly Jetcomp, which seemed...
|
by: John |
last post by:
Hi
How can I;
1. Check the existence of an exe app in a particular path such as
c:\myfolder\myapp.exe, and
2. Execute the app?
Thanks
|
by: Robert W. |
last post by:
I'm trying to add simple database functionality with a Windows Forms app I'm
building. FYI my development machine is running Windows XP Pro, with all the
service packs installed.
First I tried using the standard OLEDB connection string (ie.
"Provider=Microsoft.Jet.OLEDB.4.0...") but got this message when it tried to
open the connection:
"The .Net Data OLE DB Provider(System.DAta.OleDb) requires Microsft Data
Access Component(MDAC)...
| |
by: dwa |
last post by:
We're trying to use the CDO Message object to send an SMTP message with
..NET. Testing the code on a machine with FAT32 file system, everything
works fine. Running under XP or Win2K with NTFS, we receive a message to
the effect: "Unable to access CDO.Message object".
This would seem to be some kind of permissions problem - the same code works
just fine if dropped into a console app. Has anyone solved this problem
before?
...
|
by: Ramanfromoz |
last post by:
Hi,
Developing a new we application. Everything okay on my local WIN XP
PROFESSIONAL, IIS 5.0 running locally. The website is running smoothly.
Now, the same code I am copying over to a WINDOWS 2003 SERVER, I
created a new website, allocated port number 6000. Created a release
version on my local machine and copied the WEB project from my local to
http://ACTYD003:6000
|
by: Rider |
last post by:
Hi, simple(?) question about asp.net configuration..
I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm
first start application the follow message shown.
=========
Server Error in '/QuickStartv20' Application.
--------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file
|
by: (PeteCresswell) |
last post by:
Does his sound legal?
Somebody brought it up as an alternative to creating my temp DB under Documents
and Settings\User Name.
Sure seems simpler - conceptually identical to using C:\Temp in that no special
coding is required to tailor the location to each user.
But somehow it sounds like an end run - flaunting the spirit of the standard.
Also, on my PC, I notice that there is no ...\All Users\Local Settings
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |