script error

goju

Registered User.
Local time
Today, 23:26
Joined
Apr 7, 2005
Messages
77
trying to archive some data,

see below script it returns an error message cant find expression "|"


Private Sub Command227_Click()
Me.[Archive] = True
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Me.[List220].Requery
Me.[ArchiveDate] = Now()
End Sub

any ideas
 
goju said:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

What is that supposed to do? Since that code has been out of date since Access 95.
 
the button is supposed to archive certain data,

but just returns that error message
 
That's not what I asked. You've used a wizard to generate that line of code, it's out of date, what were you using the wizard to make the button do? Save, delete, edit, etc?
 

Users who are viewing this thread

Back
Top Bottom