Results 1 to 2 of 2
  1. #1
    blueman is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    26

    Only Certain Procedures not working on one of the computers with Access Backend

    Has anyone run into a situation where only certain processes are not behaving correctly on all versions of the front end?



    I have an access DB Backend on Sharepoint. For the most part it works fine, but on one of the laptops containing a copy of the backend, some of the search modules aren't working that are attached to a combo box drop down to select a record.
    Here's that code for one of the search combo boxes however, the same problem occurs on others on that form.
    Code:
    Private Sub Combo33_AfterUpdate()
    Dim RS As Object
    Set RS = Me.Recordset.Clone
    RS.FindFirst "[CustomerID] = " & Me![Combo33]
    If Not RS.EOF Then Me.Bookmark = RS.Bookmark
    Me.Combo33.Requery
    End Sub
    In addition, code that minimizes a switchboard does not seem to be working on any forms (on this laptop but works fine elsewhere.

    Here's that code:
    Code:
    Private Sub Form_Open(Cancel As Integer)
    Forms![frmMainSwitchboard].Visible = False
    End Sub
    I doubt if the code has anything to do with it as the the database functions properly on other computers. I even took a copy of the backend from one of the other computers and put it on the laptop just to see if anything had inadvertently been changed and still, it did not function properly.

    Has anyone seen any behavior like this or does someone have an idea as to where to go to fix it?

    Thanks in advance

    We are running access 2013 and I believe it's sharepoint 2013 version

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Are we talking 32 versus 64 bit versions of Office by any chance?
    https://msdn.microsoft.com/en-us/lib.../gg278832.aspx
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 5
    Last Post: 11-17-2014, 06:18 PM
  2. Replies: 2
    Last Post: 08-26-2013, 11:29 AM
  3. Replies: 6
    Last Post: 07-19-2013, 01:50 PM
  4. Replies: 2
    Last Post: 08-31-2012, 10:40 AM
  5. Replies: 1
    Last Post: 08-15-2012, 03:03 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