 |
| Access VBA Discuss using VBA for Access programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|

September 5th, 2003, 08:30 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Access and windows 98 versus XP
I've wrote an application which runs successfully under Windows 98 and i got a lot of troubles under XP, such as the instruction at this adress can is trying to write something at an adress where the memory could not be "written". This causes the application to stop.
Sorry, it seems to be a protection exception, but why it runs under 98. Can some one help me with this problem ?
Bassam Sater
__________________
Bassam
|
|

September 7th, 2003, 03:12 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Got an example of where the code fails?
I am a loud man with a very large hat. This means I am in charge
|
|

September 7th, 2003, 06:07 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello Steven,
Yes of course, it goes over a form with a subform and some code behind them. How can i send it ?
The whole zipped application is about 430KB.
Thanks a lot,
Bassam
Bassam Sater
|
|

September 8th, 2003, 10:44 PM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Bassam:
One of the main issues, when targeting different OS, is to handle this kind of problems. First of all all references that you to ADO, DAO, MDAC's calls etc. that works in Win 98 will not work in other OS. if You want to overcome this kind of situations you may do several things:
1. Install your app. with the runtime of access
2. Develop the application in the latest Access verssion and convert it to the different verssions of your targets. Note that this can be a painfull procedure.
3. Install your application in the target and make the modifactions.
Good Luck
Estuardo
|
|

September 8th, 2003, 11:43 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
|
quote:works in Win 98 will not work in other OS
|
Hogwash! It has more to do with the version of Office/Access that is installed rather than the OS, particularly if its an M$ OS.
Bassam - you said you used to run it under 98 but can't with XP. What version of Access was it before? Did you convert to a newer version? If so, which one? Are you running multiple versions of Access on your workstation?
Regards,
Beth M
|
|

September 9th, 2003, 01:47 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello,
Sorry, I forgot to give this detail.
The application was made under Access 2000 and I try to use it under
Access 2000 with Windows XP.
AT home, it works under ACCESS 2002, but it still the 2000 Format.
Thanks,
Basssm
Bassam Sater
|
|

September 9th, 2003, 08:21 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Check the references by opening the VB Editor and going to Tools > References. See if there are any listed as Missing: If so, this is probably your culprit. After highlighting the 'missing' reference, browse out to find the correct file associated with the reference. Click OK and save changes.
Regards,
Beth M
|
|

September 9th, 2003, 10:05 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello Beth,
This was already done, it doesn't help.
I can send you the piece of code or the zipped application if you have time .
Thanks,
Bassam
Bassam Sater
|
|

September 9th, 2003, 10:20 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
|
quote:I can send you the piece of code or the zipped application if you have time.
|
Can you copy & paste the function where you are running into the issues, and note where your code quits to the forum?
It is better to post to the forum as many people will be looking at it versus only 1 other. :)
Regards,
Beth M
|
|

September 9th, 2003, 10:34 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello Estuardo,
This is the way that i did, the strange thing about it that not only
the whole application is slower than before, but that some buttons
don't react any more on click for example.
Still seraching,
Bassam
Bassam Sater
|
|
 |