Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / June 2007

Tip: Looking for answers? Try searching our database.

Error 13 Type Mismatch again...HELP PLEASE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shmoussa - 20 Jun 2007 15:36 GMT
Hi. I've had this error before, and have had no luck fixing it this
time....although I've narrowed it down. The problem lies here
somewhere:

strSQL = "SELECT [Disk Information].[File Name], [Disk Information].
[Volume Name], [Disk Information].[Volume Size], [Disk Information].
[Space In Use] " & _
"FROM [Disk Information] " & _
"GROUP BY [Disk Information].[File Name], [Disk Information].[Volume
Name], [Disk Information].[Volume Size], [Disk Information ].[Space In
Use] " & _
"HAVING ((([Disk Information].[File Name]) Not Like " * SHAREDNCS *
")) " & _
"ORDER BY [Disk Information].[Volume Name]; "

I also have this on top:   Dim strSQL As String

What I am trying to do is filter my table to anything with a file name
that does not contain the word SHAREDNCS.

Any idead? Thanks.
Stefan Hoffmann - 20 Jun 2007 15:45 GMT
hi,

> Hi. I've had this error before, and have had no luck fixing it this
> time....although I've narrowed it down. The problem lies here
> somewhere:
> "HAVING ((([Disk Information].[File Name]) Not Like " * SHAREDNCS *
> ")) " & _
As the double quotes are string limiters in VBA you need to either
escape them for your SQL or use the single quotes, e.g.

"HAVING [Disk Information].[File Name] Not Like ' * SHAREDNCS * ' " & ..

mfG
--> stefan <--
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.