Syntax error

H

Hydra

Set tdfResources = dbs.CreateTableDef("Resources")
With tdfResources
.Fields.Append .CreateField(RangeName, dbText)


I have this code in two different macros. In one macro it works, inthe
other, the .fields.Append statement throws a systax error.

One macro runs against an Excel table, the other runs agains an MS project
file.
Both use the same reference libraries.



With tdfResources
.Fields.Append .CreateField(Rangename, dbText)

(This is the code from the Excel file)

Rangename is a variable containg text, and it is not undefined.


?????????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Table statement for fields with validation 3
Query Online Database 11
Nulls and Strings comming from SQL 2
Help with Access VBA to create a new file and import textfile data 6
VBA help From db1.dbf have module to create then import Text 0
Over flow error when runing a loop 2
Having trouble with temp table 1
temporary BackEnd database for large resultset 5

Top