PC Review

Thread Tools Rate Thread

Type mismatch error after access 2007 conversion in form call

Posts: n/a
      22nd Jul 2010
I recently converted an access 2003 database to Access 2007.
Everything has worked fine except for getting a Type Mismatch (Run
time error '13') on "Forms!frmQueryPaymentAA.BuildSQLExisting
'Transfers selected query name to the base form" line. I changed the
Sub from Private to Public after reading on some forums that Private
could cause a problem but that did not help. Is there a fix for this?
Here is the code:

Public Sub cmdPaymentReturn_Click()
If IsNull(Me.lstQuery) Then
MsgBox "You have not selected a query. Either select a query or close
the form to construct a new query" Exit Sub
End If

Forms!frmQueryPaymentAA.BuildSQLExisting 'Transfers selected query
name to the base form DoCmd.Close
End Sub

BTW, BuildSQLExisting is a Public sub procedure in the
frmQueryPaymentAA form. The offending line is calling the form and
procedure from existing form.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Getting 'Type mismatch' error after redesigning form Amy E. Baggott Microsoft Access Form Coding 0 23rd Apr 2010 05:25 PM
RecordSet Type mismatch using Access 2007 VB script in Access 2002 Marian M. Microsoft Access VBA Modules 2 27th Jan 2008 02:50 AM
Type mismatch error after converting to Access 2007 =?Utf-8?B?RGF2aWQgTWNLbmlnaHQ=?= Microsoft Access Form Coding 2 25th Feb 2007 02:33 PM
Type mismatch error (different than previous type mismatch?) Roberta Microsoft Access VBA Modules 3 9th Jan 2004 07:26 PM
Data Type Mismatch error during DAO to ADO Conversion Lucky Microsoft Access VBA Modules 0 15th Aug 2003 02:31 PM




All times are GMT +1. The time now is 07:34 AM.