Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 20th, 2004, 05:25 AM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with string functions and Access 2000

I have written an access 2000 application.
In this application i ve used right() function.

On my pc all it' s ok. but when i use this application on another pc, i get an error.

The strange thing is that if i open a new appliation in the second pc with a right function in the VBA code it is recognised.

What is the problem?

I ve registered my veb6.dll n the target pc and nothing happened

Thank you all in advance.

PS: if i don t solve this problem my project will fail and with it my possibility af having a career.



Reply With Quote
  #2 (permalink)  
Old January 20th, 2004, 09:08 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Open any procedure. On the menu, click Tools > References. A dialog box will appear showing you available references. On the computer where the RIGHT() works, see which references are checked. On the computer where it doesn't work, make sure the same references are checked as in the other computer.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #3 (permalink)  
Old January 20th, 2004, 12:46 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just because an error SEEMS to be related to a particular reference (such as VBA 6) doesn't mean that the actual error is THAT REFERENCE. ALL references must be correct for any of them to work correctly. I've seen this problem many times before. Curiouser and curiouser.

Rand
Reply With Quote
  #4 (permalink)  
Old January 20th, 2004, 01:40 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If there are different versions of ms access installed, this will happen. Even just different service release levels. Serrano is on the right path, you are having problems with a bad reference to a dll, a bad dll being referenced or a corrupt database. Either way it is dll hell.
I have seen this happen with no reason or rime in the past.



Sal
Reply With Quote
  #5 (permalink)  
Old February 25th, 2004, 03:10 AM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you to all of you who answered.
References are the same.
So what can I do concretly for solving the problem?

Regards

Reply With Quote
  #6 (permalink)  
Old February 25th, 2004, 09:43 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Access should by default find the Utility.mda. As Sal said, sometimes when you have more than one version loaded on a pc, things get a little screwed up. On the pc where this doesn't work, open your references and browse out to create a new reference to the Utility.mda. Save changes and then run. See if this fixes the issue. (I am advising this only as a troubleshooting technique!)

Beth M
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT Problems in Access 2000 lizhaskin VB Databases Basics 1 February 10th, 2006 08:52 AM
functions in SQL SERVER 2000 vs STORED PROCEDUES p2ptolu SQL Server 2000 2 June 13th, 2005 09:32 AM
String functions..... BlueStag VB.NET 2002/2003 Basics 1 June 10th, 2005 05:58 AM
Heeeelppp !!! Problems Compacting Access 2000 timmaher Access 2 August 13th, 2004 05:32 AM
problems between sub and functions charlie Excel VBA 2 July 11th, 2003 01:21 PM



All times are GMT -4. The time now is 11:55 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.