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!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: CrAzIcRaCkEr
- Order by date
-
Run-time Error 3075
Yes, I did need to add the FROM clause. I was thinking that it would default to current table as selection. Thanks! Cc- CrAzIcRaCkEr
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Run-time Error 3075
Anybody see anything wrong with this SQL? (Both dummyBLID and Me.BLID.Value variables are integers.) DoCmd.RunSQL ("INSERT INTO tblApplications (BLID, appName, VRM, CISOcomments, SOX, lastRiskAssess, busImpact, GLBAHigh, catID, ISOquarterly, authorizer, administrator) SELECT " & dummyBLID &...- CrAzIcRaCkEr
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Record Key Violation
I have been battling this problem all day today. I am running Access 2002 w/SP3. I have a SQL statement in the VBA code. The statement reads: DoCmd.RunSQL ("UPDATE VMVendors SET COMPANY = '" & vdrName & "' WHERE [VENDNO] = '" & VENDORID & "'") When this command is executed I get the...- CrAzIcRaCkEr
- Thread
- Replies: 0
- Forum: Microsoft: Office
