Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does this work?

Status
Not open for further replies.
Raptor136

Raptor136

Technical User
Aug 26, 2002
39
US
Hi, I am getting a VBA syntax error on this line. Any ideas why. Please be nice I am a learn as I go kind of guy. :) TIA -- Rap

DoCmd.RunSQL CREATE INDEX PrimaryKey ON ROOTCOPY (ero) WITH PRIMARY UPDATE DISTINCTROW root000 LEFT JOIN rootcopy ON root000.ero = rootcopy.ero SET root000.remarks = [rootcopy].[remarks]
raptor136@adelphia.net
 
Sort by date Sort by votes
DoCmd.RunSQL "CREATE INDEX PrimaryKey ON ROOTCOPY (ero) WITH PRIMARY UPDATE DISTINCTROW root000 LEFT JOIN rootcopy ON root000.ero = rootcopy.ero SET root000.remarks =" & [rootcopy].[remarks]
Herman
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Create query that will divide work among employees 1
Replies
7
Views
497
Andrzejek
Andrzejek
Julio Herrera
  • Locked
  • Question
Query with recursive subquery does not work
Replies
6
Views
372
SkipVought
S
leifoet
  • Locked
  • Question
SQL query with UNION ALL of 2 tables does not work
Replies
7
Views
470
Andrzejek
Andrzejek
BTilson
  • Locked
  • Question
Virtually Identical Select Queries - One Works, Other Doesn't?
Replies
2
Views
397
combo
combo
Moss100
  • Locked
  • Question
The following is not working - can
Replies
2
Views
401
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top