Results 1 to 11 of 11

Thread: Plz, Look into this access file for me

  1. #1
    Join Date
    Aug 2008
    Posts
    52

    Plz, Look into this access file for me

    kindly look into this file for me as it complains of a dll instructions on some system or error 48 or error 258 on some system and in some system, it runs smoothly. I don't know what to do any more to correct this error.
    Kindly help.
    Thank U.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    kindly look into this file for me as it complains of a dll instructions on some system or error 48 or error 258 on some system and in some system, it runs smoothly. I don't know what to do any more to correct this error.
    Kindly help.
    Thank U.
    On mach9nes that are having an issue, I would recommend looking in the VBA Editor (Tools > references) to see if you have any missing references.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  3. #3
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    I have downloaded your database. I am not sure what to do to test it.

    Please provide instructions on how to duplicate the issue.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  4. #4
    Join Date
    Aug 2008
    Posts
    52
    Thanks for ur reply.
    Plz, look into it and u will see three forms.
    1. frmstartup: try to run it on two or three different system and u will see that for it to run it will generate some error language.
    I want help on how to remove the error language. Plz, carefully go through the codes and u might see the error in it as I cant understand why the error comes up in some systems and it does not in some system.
    I hope.
    Thank U.

  5. #5
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    Thanks for ur reply.
    Plz, look into it and u will see three forms.
    1. frmstartup: try to run it on two or three different system and u will see that for it to run it will generate some error language.
    I want help on how to remove the error language. Plz, carefully go through the codes and u might see the error in it as I cant understand why the error comes up in some systems and it does not in some system.
    I hope.
    Thank U.
    does the code use any third-party control/custom DLL that is not part of Access?
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  6. #6
    Join Date
    Aug 2008
    Posts
    52
    It does not. I designed every thing in access. Do look into it. Don't enable security features as I suspect u may be afraid it has some damaging effect against ur system. Just look into the code and professionally analyse it. I am sure u might see where I went wrong. Thank U

  7. #7
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    It does not. I designed every thing in access. Do look into it. Don't enable security features as I suspect u may be afraid it has some damaging effect against ur system. Just look into the code and professionally analyse it. I am sure u might see where I went wrong. Thank U
    I think the problem is that you code does really use a DLL that you have not installed on all the target machines.

    Your code uses a non Access control with this:

    CreateObject("CAPICOM.HashedData")

    CAPICOM is a discontinue ActiveX control that is not distributed with of Access.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  8. #8
    Join Date
    Aug 2008
    Posts
    52
    For this my instruction to run successfully, what do u suggest I.
    Thanks

  9. #9
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    For this my instruction to run successfully, what do u suggest I.
    Thanks
    Where did the code come from?

    Since you said in your last post it should not use any extra DLL's, I am not sure what to tell you.

    Option 1: Do not use ActiiveX control

    You could try making a copy of the example and commenting out the lines that are causing the errors. You will need to test your database to be sure it still functions correctly.

    Option 2: use ActiiveX control

    If you need the code and it does use an extra ActiceX control, then you will need to check to see how you deploy the file with your database. You might need an installer?
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  10. #10
    Join Date
    Aug 2008
    Posts
    52
    Thanks very much. I spent my time carefully and solved the problem. It runs now.

  11. #11
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by Engr. Clement View Post
    Thanks very much. I spent my time carefully and solved the problem. It runs now.
    You're welcome!

    Glad you found a solution.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •