By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,636 Members | 1,941 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,636 IT Pros & Developers. It's quick & easy.

Runtime error 3075

P: 22
I recently created a database in Access 2000 that has been distributed to multiple people using various versions of Access. Each person is using it as a standalone database.

The database has multiple forms that collect information on individual people. In fact there are 5 forms per person. The first and second form write data to the same table. The VBA code below is what happens when the user continues to the second form to enter more data. A user who has Access 2003 receives a Runtime error 3075 - Syntax error (missing operator) in query expression 'Participant_Info.'. at this point. The last line of code is what is indicated to be the problem. However, I do not get that error when testing the database in Access 2000.

Can anyone provide a hint as to the possible problem?


Expand|Select|Wrap|Line Numbers
  1. Private Sub GoToEmpForm_Label_Click()
  2.     If IsNull(Me![SSN]) Or (Me![SSN]) = "" Then
  3.         MsgBox "Please select a SSN before proceeding!", vbOKOnly, "Invalid Search Criterion!"
  4.          Me!SSN.SetFocus
  5.     Exit Sub
  6.     ElseIf IsNull(Me!LWIA_Combo) Or Me!LWIA_Combo = "" Then
  7.         MsgBox "Please select a LWIA before proceeding!", vbOKOnly, "Missing Entry"
  8.     Exit Sub
  9.     ElseIf Nz(Me.WSOther, "") = "" And Me.WIA_Stat_Opt = 4 Then
  10.         Cancel = True
  11.         MsgBox "Please enter 'Other Adult' WIA Status", , "Missing Entry"
  12.         Me.WSOther.SetFocus
  13.     Exit Sub
  15.     End If
  16. DoCmd.GoToRecord , , acNext
  17. DoCmd.GoToRecord , , acPrevious
  18. DoCmd.OpenForm "Emp_Info_frm", acNormal
  20. End Sub
Apr 25 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
Since there's no reference to Participant_Info in the code here, and Access is erroring out on the line opening the form Emp_Info_frm, I'm going to guess that the problem is in the query that's the Record Source for this form. We need to see the SQL code for this query. The problem could be in a missing library on the v2003 machine that 's being referenced in the SQL.

Linq ;0)>
Apr 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.