Build SQL statement

[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,

 

[Bob Quintal]

:

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,

Please post the VBA that creates the SQL statement.

 

[inungh]

:











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 -

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