Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Has anyone ever seen this error !! (A2k SR1)

    I've not seen this before

    Any Idea's ??
    Attached Images Attached Images

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

    Re: Has anyone ever seen this error !! (A2k SR1)

    I have had this thrown at me when I tried to paste rows from an Excel spreadsheet into an Access table with almost but not quite the same field names. Can't remember having seen it in a form, but that might be due to a memory failure. What was it you asked? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    You might try opening the Clipboard Viewer (Start Menu/Programs/Accessories) when you get this error and examine the column headers.

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Has anyone ever seen this error !! (A2k SR1)

    Well it seemed to be this code in the after update of a combo.I moved it to on change and seems to have fixed the problem.
    Thanks for the concern
    Dave


    Private Sub CmbRegistration_Change()
    Forms!FrmDetails.Refresh
    Dim intButSelected As Integer, intButType As Integer
    Dim strMsgPrompt As String, strMsgTitle As String
    strMsgPrompt = "Is Vehicle In Now ?"
    strMsgTitle = "!!"
    intButType = vbYesNo + vbDefaultButton1
    intButSelected = MsgBox(strMsgPrompt, intButType, strMsgTitle)
    If intButSelected = vbYes Then
    Forms!FrmDetails!InNow.Visible = True
    Forms!FrmDetails!InNow = True
    Me.cmbInsurerCode.SetFocus
    Else
    Forms!FrmDetails!InNow.Visible = False
    Forms!FrmDetails!InNow = False
    Me.cmbInsurerCode.SetFocus
    End If
    End Sub

Posting Permissions

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