Compile errors in queries

[MarkyP]

All of a sudden none of my queries work properly- all the criteria and calcs i had in them have been deleted?!
Basic codes do not work any more e.g >now() ;between 1 and 30 etc
If i try and write a new query using the same expressions and code they just don't like it - YET they were working yesterday - very strange
Can anyone help??

 

[MStef]

Did you conver this MDB in a new version of Access, and
it happend after converting.

 

[MarkyP]

I did about an month ago to get an automatic e-mail function working in module.

I did some more quiries the other night and then pasted them in an application function in modules. I also copied the email code below the original e-mail code to run a differnt set of emails - (this might have done it) an i also renamed the e-mail code, but hten changed it back.

When i went back into access i had simple crireia expressions in all my queries - like
LeadName: [tblCustomers].[Title] & Space(1) & [FirstName] & Space(1) & [LastName]
This suddenly has a compile error?! Even though it has always worked
All my other codes such as >now() (breakstart]-now() etc all have compile errors yet they havealways worked before

 

[MStef]

I don't know exactly, but try this.
Open any VBA (form or module), click on "Tools", "References",
and look in "Available References". If you find any MISSING references,
deselect them ana try this MDB again.

 

[MarkyP]

Nope - nice try - everythings ok in that

I copied the ssql code from the query i wrote in to the module. The modlue still bears the right code but it has been stripped out of the actual query and i can no longer write it back in evenn if a start from a new design.

What do you reckon - cheers Mark

 

[MStef]

I have no idea, I'm sorry.