Results 1 to 4 of 4
  1. #1
    Lesg is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    101

    Remove Module to allow bit version change

    Hi Guys,

    I have recently been tasked my a client to make changes to their DB system that I development for them a long time ago, around 2006. We are moving them to windows 10 and the new PC's are all 64bit, but the original DB is 32bit.



    Most of the database forms and functions work ok, as I have applied the ptrSafe to the modules, however, I the modCalendar module, and cannot compile the project, as the module throws a type mismatch error:

    Code:
        ' Determine Access Version
        ' **************************
        ' For A97 MUST USE AddrOf
        ' **************************
        'If Val(SysCmd(acSysCmdAccessVer)) < 8 Then
        'wc.lpfnWndProc = AddrOf("WindowProc")
        'Else
        wc.lpfnWndProc = GetFuncPtr(AddressOf WindowProc)
        'End If
    it errors on: GetFuncPtr(AddressOf WindowProc)

    So my questions are:

    1. how can I safely remove this module, as I can use the date picker on the forms now?
    2. How can I find forms or modules that rely on this, and vice versa, to safely remove?
    3. Once I can compile this version, I should then be able to save in 64bit using save as option?

    Sorry if this seems like a basic question, it is so long since I did any of this work I am trying to get up to speed again now.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    It only matters if ACCESS is 64bit?
    I'd leave well alone, if that is not the case. 64bit Windows is NOT a problem.?
    I can run 32bit Access on a 64 bit Win10 computer, the same as I can on my 32 bit computer.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    Code:
    as I have applied the ptrSafe to the modules
    and longlong where there are pointers?

  4. #4
    Lesg is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    101
    I have now been able to compile the database by removing the modCalendar module, then compiling and finding all the modules where this is called and deleted from code and any other related or none required modules.

    I have a different issue now, which I will open a new thread as its not related to this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Upon Successful Login Change AFRs Form Version
    By billgyrotech1 in forum Access
    Replies: 26
    Last Post: 06-21-2019, 01:55 PM
  2. Replies: 7
    Last Post: 02-05-2018, 08:14 PM
  3. Can't Remove MsgBox without module not working
    By cm-net in forum Programming
    Replies: 1
    Last Post: 01-20-2018, 07:49 AM
  4. Execution Shuts on version change
    By drunkenneo in forum Access
    Replies: 2
    Last Post: 07-13-2015, 04:46 PM
  5. Converting Module To Newer Version
    By JeffGeorge in forum Modules
    Replies: 6
    Last Post: 01-29-2015, 12:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums