Re: Parenthasis issue

Eek!

Try this, then post your findings

Press Alt+F11 to open the VBA editor
Press Ctrl+G to navigate to the Immediate window
Type the following:
? currentdb.QueryDefs("<the name of your query>").SQL
Include quotes in the above.

Another possibility:

Navigate to the Documenter (might be Tools | Analyze | Documenter)
Click the Queries tab and select the problematic query
Click OK
The document report should reveal the SQL of the query

HTH!

Phil wrote:
I'm in Design View. When I try to go to SQL View it won't let me because of the error. Can I get around this? Sorry, I'm a newbie.

Phil

"Jeff Boyce" wrote:

Phil

If you don't post a copy of the SQL, we can only guess...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:710EED7C-959B-4102-BA4D-64FE380135D7@xxxxxxxxxxxxxxxx
I have a standalone query that works. When I cut and paste it into an
existing query that works I start getting a parenthasis error. It says I have
an extra closing parenthasis ")". I have two pairs of them. Just to test I
took each one out individually and each time it tells me I'm missing a
closing parenthasis. I'm guessing its a badly worded IBM error message. Any
idea what is wrong?

Thanks.

Phil





--
Smartin
.

Relevant Pages

  • Re: combo boxes
    ... If you used a query it is possible to have designed the query to not allow ... Does your subform display data from the same table as you main form? ... Subforms are usually used to display data in a separate table ... >> navigate to the last record and then once more to go to a new record. ...
    (microsoft.public.access.forms)
  • Re: Record navigation with Paging
    ... should be able to navigate with single record, ... So i would like to build the custom ... DataView to accomodate these requirement. ... >> I was looking the msdn sample:(Paging through a query ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Query gets first record value only
    ... > The purpose of this query is to limit the records in the combo box to ... > also display the combo-box value for the current record (the first ... > only executing for the first record that displays. ... > Is there a way to make this query re-execute each time I navigate to ...
    (microsoft.public.access.forms)
  • Re: Export like a Save As
    ... > acExport" for exporting a Query but emulating a Save As. ... > the PopUp form allows the user to navigate into his or her ...
    (microsoft.public.access.formscoding)