October 6, 2008 11:52pm pdt

1. capricorn1 2,633,092
2. DatabaseMX 1,887,345
3. LSMCons... 938,328
4. boag2000 752,892
5. peter57r 621,035
6. GRayL 512,903
7. harfang 473,728
8. jimhorn 362,653
9. cactus_d... 348,340
10. matthews... 308,122
11. hnasr 255,914
12. TextReport 237,557
13. puppydog... 190,867
14. angelIII 189,754
15. mbizup 184,636
16. ee_rlee 173,155
17. jimpen 168,301
18. LPurvis 158,775
19. tbsgadi 154,712
20. Natchiket 146,263
21. jefftwilley 145,135
22. omgang 142,115
23. JezWalters 138,435
24. Rick_Ric... 133,852
25. irudyk 133,601

1. capricorn1 10,290,130
2. nico5038 5,704,781
3. rockiroads 5,411,935
4. peter57r 4,065,530
5. DatabaseMX 3,770,806
6. LSMCons... 3,674,918
7. LPurvis 3,417,742
8. shanesue... 3,288,317
9. harfang 3,090,561
10. stevbe 2,857,611
11. jimhorn 2,782,245
12. GRayL 2,672,747
13. flavo 2,112,583
14. mbizup 2,071,226
15. jadedata 1,964,977
16. jefftwilley 1,804,575
17. thenelson 1,700,369
18. matthews... 1,645,335
19. eghtebas 1,488,929
20. boag2000 1,435,636
21. puppydog... 1,370,330
22. cactus_d... 1,321,129
23. Arthur_... 1,298,362
24. jjafferr 1,267,357
25. dannywar... 1,264,796

05.29.2008 at 11:33AM PDT, ID: 23442455

	[x] Attachment Details

SQL query in vba in access 2007 doesn't work

Asked by RunToTheHills in Microsoft Access Database, Visual Basic Programming, SQL Query Syntax

Tags: Microsoft, Access 2007, 2007

the following code does not work
i have a table named ProjectTable with a field named Project Name and at least 1 record in that field that stats with the letter T

any reason why this code doesn't work?

it is run from a command button on a form

Dim x As String
x = "SELECT * FROM [ProjectTable] WHERE [Project Name]='T%';"
DoCmd.RunSQL x

i have also tried

Dim x As String
x = "SELECT * FROM [ProjectTable] WHERE [ProjectTable].[Project Name]='T%';"
DoCmd.RunSQL x

i attached the error i get
clicking the help button on that error box provides no clues either

i guess it is a syntax error but i don't know what i wrote wrong

thanks for any help
Start Free Trial

Attachments:

error.bmp (301 KB) (File Type Details)

error message

Keywords: SQL query in vba in access 2007 d…

	Title
1	Put data from a form into the FROM Sta…
2	DoCmd.runSQL and run-time error …
3	DoCmd.RunSQL
4	DoCmd.RunSQL
5	SQL VBA
6	doCmd.runSQL for Select Statements

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL query in vba in access 2007 doesn't work

Asked by RunToTheHills in Microsoft Access Database, Visual Basic Programming, SQL Query Syntax

Tags: Microsoft, Access 2007, 2007

About this solution