Build SQL statement

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I tried to build SQL stament at run time using VBA.

It seems that MS Access break my SQL statement in 2 parts.
Immediate Windows shows my SQL reach the end of the length and break
my table name like the following:

tbl
MyTable

tbl is on the end of first line and MyTable on the second line.

I copy the SQL in to query and press del key on the keyboard to make
sure tblMyTable together then the SQL works.

I had longer SQL statement before and never had any issues.

It is normal to build a long SQL statement like this?
If not, are there any place that I can check?

Your help is great appreciated,
 
:
I tried to build SQL stament at run time using VBA.

It seems that MS Access break my SQL statement in 2 parts.
Immediate Windows shows my SQL reach the end of the length and
break my table name like the following:

tbl
MyTable

tbl is on the end of first line and MyTable on the second line.

I copy the SQL in to query and press del key on the keyboard to
make sure tblMyTable together then the SQL works.

I had longer SQL statement before and never had any issues.

It is normal to build a long SQL statement like this?
If not, are there any place that I can check?

Your help is great appreciated,
Click to expand...
Please post the VBA that creates the SQL statement.
 
:











Please post the VBA that creates the SQL statement.

--
Bob Quintal

PA is y I've altered my email address.- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks for the message,
It is working now for some unknown reason.
 
Back
Top