Solved

Access 2K Runtime and Date() not working together?

Posted on 2001-09-04
15
237 Views
Last Modified: 2008-02-01
First I would like to start by saying thank you to all the help everyone has been giving me with this. I immensely appreciate it. This is a rather big project for me and this is the last thing I need to get fixed on the program.

I gave the Now() ideas a try and unfortunately it?s producing the same error. Thank you for suggesting it though as it was well worth the shot. - Thanks.

I am very interested in the notion that a bad reference could be causing the problem though. On a couple of the machines I got an error message Class not registered when the splash form opened. So I did some checking and sure enough there is a reference to Microsoft Forms 2.0 Object Library which is not getting shipped with the program. I tried removing it but got a message saying Can?t remove control or reference; in use. The thing is I went through all 75 forms and 43 reports and couldn?t find a single control that should be using this library.

Does anyone know what I can do to locate the culprit so that I can remove the reference? I have feeling it will fix the problem. Thank you in advance.

The Royal Falcon
0
Comment
Question by:TheRoyalFalcon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +5
15 Comments
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6454133
I have had problems with the Date function also.  Try using Now(), it usually works for me though Im not sure why!
0
 
LVL 2

Expert Comment

by:Gudare
ID: 6454260
Test to see if the text functions (IE: Right/Left/Mid) are behaving the same, I believe they're part of the same library.

I've seen this happen on multi-system distributions of standard db's, but never in a runtime, because it's supposed to distribute the libraries with it...

-Craig
0
 
LVL 4

Expert Comment

by:abaldwin
ID: 6454268
Try running any service packs for Office 2k that are available from the MS site.

I believe this will update the mscomm32.ocx which I think is your problem.

If you take  mscomm32.ocx and mscomm32.oca and place them on the boxes that fail this will let you know that they are the problem.

Of course back theirs up before doing so.

Andy
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 58
ID: 6454503
"I would like to correct the problem but I dont know why the function isnt working. Does anyone know
what I can do to correct the problem? Or why it is even happening?"

 It's a broken reference.  One of the libs your using has a different version number then the one one the user PC, but the one distrbuted is older then, so it was not overwritten.

 You need to include code in the app to check for broken references and recompile the app if need be.  You can only do this with a MDB format.  If it's MDE, then you need to distribute will all type libs, register them, and place them in the directory with the MDE.  THis needs to be done because a MDE cannot be compiled.

See the code in the following MSKB article:

http://support.microsoft.com/support/kb/articles/Q194/3/74.ASP

Jim.
0
 
LVL 4

Expert Comment

by:abaldwin
ID: 6454518
Have you tried replacing their mscomm32.oca and mscomm32.ocx with the files on your box????

If that fixes it then I do believe that they need office services pack on their box.

Andy
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6454799
I agree with Jim on the references.

Additional tip:
Remove all references that aren't necessary before moving your application to another PC.
Just uncheck and do a compile all modules to see or the code is still OK. If not, check the library.

Access has a habit of adding a library when placing e.g. an .ocx, but not removing it when you remove the object...

Nic;o)
0
 
LVL 1

Author Comment

by:TheRoyalFalcon
ID: 6458305
First I would like to start by saying thank you to all the help everyone has been giving me with this. I immensely appreciate it. This is a rather big project for me and this is the last thing I need to get fixed on the program.

I gave the Now() ideas a try and unfortunately it?s producing the same error. Thank you for suggesting it though as it was well worth the shot. - Thanks.

I am very interested in the notion that a bad reference could be causing the problem though. On a couple of the machines I got an error message ?Class not registered? when the splash form opened. So I did some checking and sure enough there is a reference to ?Microsoft Forms 2.0 Object Library? which is not getting shipped with the program. I tried removing it but got a message saying ?Can?t remove control or reference; in use?. The thing is I went through all 75 forms and 43 reports and couldn?t find a single control that should be using this library.

Does anyone know what I can do to locate the culprit so that I can remove the reference? I have a feeling it will fix the problem. Thank you in advance.

The Royal Falcon
0
 
LVL 58
ID: 6458446
Close Access.

Re-open, open the MDB without executing anything.  Open a module in design view and uncheck the reference.

If you can do that, then try compiling the app and see if any errors result.  If not, then you have a form or control that's built on that class lib.

Jim.
0
 
LVL 1

Author Comment

by:TheRoyalFalcon
ID: 6458575
Thanks Jim,

I gave it a try but I still can't uncheck it. Do you have any idea how I can list all the control using a class to the imediate window? Thanks.

Steve

0
 
LVL 1

Author Comment

by:TheRoyalFalcon
ID: 6458580
Thanks Jim,

I gave it a try but I still can't uncheck it. Do you have any idea how I can list all the control using a class to the imediate window? Thanks.

Steve

0
 
LVL 1

Author Comment

by:TheRoyalFalcon
ID: 6459651
I find myself still at a loss for the date problem on my reports. I was able to remove the reference to the mentioned library with a little work but even after all that I am still getting the same error on all the reports (although the splash screen error did go away).

The only thing I can think of doing is passing the value to a control using the on print event but that means touching more than 40 reports. If any of you have alternative ideas please let me know. (I still wish I could locate the cause of this.) Thank you.

0
 
LVL 58
ID: 6460426
OK. Do the following:

1. Backup
2. Start Access/MDB with /decompile:

  C:\..\MSACCESS.EXE /DECOMPILE C:\....\myMDB.MDB

3. Open a module in design mode
4. Click tools/ references
5. Uncheck one (note which)
6. Close the MDB and Access
7. Reopen and recheck the same reference.
8. Note if any are listed as "MISSING" or "BROKEN" (if so you need to figure out why).
9. Now compile.  You should not get any errors.

  Now do you still get the error running reports?

Let me know,
Jim.
0
 
LVL 1

Author Comment

by:TheRoyalFalcon
ID: 6602098
Hi Everyone,

I tried to delete this question a while back and I see now that it never showed up? Incase it didn't and no one saw my posting on this, I found out what was causing the problem. It had to do with MDAC versions. Here is a link to a document at my site explaining the solution. Have a nice day.


http://www.ironcube.com/downloads/developers/datefunctionfix.doc

0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7088543
Hi TheRoyalFalcon,
You've requested to delete this question, but its status has remained as 'Pending Delete' because one or more comments have been added.  Normally, the only way to fully delete such a Question is to post a message to Community Support and ask for assistance.

EE is making a one-time database sweep to purge the Pending Delete Questions automatically.  During this sweep:

    TheRoyalFalcon -- To allow the deletion to proceed:  Do nothing.
    EXPERTS -- Please DON'T POST a comment except to contest this deletion.

In the future, please refer to http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.

DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7114474
50 points refunded, item moved to our PAQ at zero points and closed rather than deleteing, since Asker posted solution a well.
Moondancer - EE Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question