Re: Parenthasis issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Phil

If you aren't able to pull up a copy via the approaches Smartin offers, are
you willing to step away from it and just re-do the queries?

I suppose another possibility (though lower likelihood of success) would be
to open a new Access database and attempt to import the offending query.

Have you already saved a backup copy and run Compact & Repair.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9D5D86DB-2429-4DEA-8647-5F017ECBD392@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Using an unbound texbox to find a record in form
    ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Private Sub Command146_Click ... Dim rec As DAO.Recordset ...
    (microsoft.public.access.queries)
  • Re: Alpha key to surrogate key
    ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... if the customer master table is in the form. ... that a surrogate key would speed things up although, ...
    (microsoft.public.access.formscoding)
  • Re: Which the best option ?
    ... set up the tables so that there is something in common between the ... You have to tell the database ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Auto-fill dates
    ... In case it hasn't come up before, consider that you don't have to design ... your table structure in Access to match a spreadsheet. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ID mixing with all records
    ... it in design view and checking the properties of the form to see if a filter ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Private Sub Form_Current ...
    (microsoft.public.access.forms)