Extracting Data

[Fie]

Hi,

I am trying to extract data from Access 97 to Excel 97. I have set up
a button on my form that allows the user to extract date, but when it
runs it to extract an error message comes up.


There is an invalid use of the . (dot) or ! operator or invalid
parentheses.
You may have entered an invalid indentifier or typed parentheses
folling the Null constant.


Does anyone know what this means? or how I can over come it.


Fiona

 

[fredg]

Hi,

I am trying to extract data from Access 97 to Excel 97. I have set up
a button on my form that allows the user to extract date, but when it
runs it to extract an error message comes up.

There is an invalid use of the . (dot) or ! operator or invalid
parentheses.
You may have entered an invalid indentifier or typed parentheses
folling the Null constant.

Does anyone know what this means? or how I can over come it.

Fiona

Crystal ball out for regular servicing on Monday's, Fiona.
Not able to help without seeing the code.
Post it.

 

[John W. Vinson]

Hi,

I am trying to extract data from Access 97 to Excel 97. I have set up
a button on my form that allows the user to extract date, but when it
runs it to extract an error message comes up.


There is an invalid use of the . (dot) or ! operator or invalid
parentheses.
You may have entered an invalid indentifier or typed parentheses
folling the Null constant.


Does anyone know what this means? or how I can over come it.


Fiona

It means that you have an invalid . or ! in your Query or in your
Code.

To overcome it correct the error in your query or your code.

If you would like help doing so, remember that we cannot see your
computer screen; please copy and paste the VBA code in your command
button's Click event, and (if that code references a Query) also copy
and paste the SQL view of the query.

John W. Vinson [MVP]