Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    free memory error message (Access 2000)

    I use the code below on the before update event of a pop-up form. I use an ID field to link this data (in the pop-up's underlying table) to my main data table. The problem is when the users says No and closes the pop-up form to return to the still open main form they receive an error message saying: "There isn't enough free memory to update the display. Close uneeded programs and try again." Now all of my users on different PC's receive this error. They have no other programs open. I checked the memory meter and there is no change in the available memory. Any thoughts? Really stumped here. Thanks..


    Dim strMsg As String
    strMsg = "Data has Changed."
    strMsg = strMsg & " Do you wish to save the changes or create new record?"
    strMsg = strMsg & " Click Yes to Save Record or No to Discard changes."
    If MsgBox(strMsg, vbQuestion + vbYesNo, " Save/Create Record?") = vbYes Then
    Me.ModifiedBy = CurrentUser()
    Me.ModifiedDate = Date
    Else
    DoCmd.RunCommand acCmdUndo


    'DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
    End If

    If Me.NewRecord Then
    For Each ctl In Me.Controls
    If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then 'Others include acLabel, acListBox, acComboBox, acCheckBox etc
    ctl.BackColor = 16777215
    Forms![frm_Center].AllowEdits = True

    End If
    Next

    Else

    For Each ctl In Me.Controls
    If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then
    ctl.BackColor = 12632256
    Forms![frm_Center].AllowEdits = False

    End If
    Next

    End If

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: free memory error message (Access 2000)

    Do you have a background graphic for your forms? According to MSKB article ACC2000: "There Isn't Enough Free Memory" Error When Working with a Form this may cause the error you report.

Posting Permissions

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