Im using Visual Studio 2005 VB in language.. i have a "application project " and compiled to produce EXE application installer.. the title is "EMPLOYEE DATABASE MANAGEMENT SYSTEM" This application is a customized user interface that manage all the employee data from an access database... it gets the data and display and you can edit, delete, update the employee information using that custom system software "EMPLOYEE DATABASE MANAGEMENT SYSTEM" >>My OS is windows vista ultimate. >>My Developing Tool is VS Studio 2005 Pro VB >>my application package library or Installer Dependencies or i mean all component library or "dll" which are necessary are: -stdole.dll -adodb.dll -msdatasrc.dll -Microsoft.stdformat.dll -Microsoft.Buil.Conversion.dll -Microsoft.VisualBasic.dll -Microsoft.VisualBasic.Compatibilty.dll >>the database i use to access with my application is ACCESS 2000 version >>and my "software" application, database connection is using OleDbConnection and ADODB Connection so? stdole.dll is for OleDbConnection.. im i right? and adodb.dll is for ADODB Connection/Manipulation.. im i right? when i run this installer to my "PC" Win.VistaUltimate and other computer Win2000Pro english version "WITH" or "WITHOUT" MS OFFICE 2003 english version or i mean no MS Office at all.. and after that i run the installed "EMPLOYEE DATABASE MANAGEMENT SYSTEM" application? it pops up and prompt my application "LOGIN Form" before entering the entire application... and after you fill-up, my LOGIN Form will connect to the access database 2000 and try to search valid user login then after confirm? my LOGIN Form will open the table "USER_LOG_TIMEIN" for example.. and insert the user time of login... i just justified that there is reading and updating transaction between my application from the start you open my application and start to login... and im using OleDbConnection... and finally?? my application run smoothly!!! but there is a problem i can't figure it out myself and very confusing part.. that when i try to install my application to laptop with OS of Windows 2000 Prof. Japenese version with an MS Office 2003 English en Japanese version... the application installed properly and when i try to run the my application??? it pops-up or prompt the LOGIN form... and when i try to fill-up my user account and password... then hit the enter or login??? then the error message pops-up "System.Data.OleDb.OleDbException" "System.Data.OleDb.OleDbCommand.ExecuteCommandTe

Please help... anybody got any good idea to fix my windows vista error... this does not prompt any error message.. but the problem is? when my windows vista OS starts? after i log into my user account... it does not load the desktop environment and it only load a single explorer with no desktop environment at all??? you can't see anything but explorer or folder explorer... no desktop icons, no start menu, no taskbar... and in order to load the desktop environment? is to manually load another windows explorer using?? CTRL+ALT+DEL then TaskManager then ALT+FILE then "NEW TASK(RUN...)" then type "Explorer"... then when the new windows explorer pops up?? then the desktop environment also starts to be loaded or visible... I think there's a registry key is missing or erase or wrong in my vista registry... Anybody there have any idea to fix this??? please help... a lot of appreciation please...

TreeView Win.Form Control Help!!! Search a matching string value all over Treeview nodes and sub nodes then open the node and highlight it? Is that possible and how? Just like searching a string value in a datagridview cell then point the focus on that cell? is there a logic then same in datagridview or listview into Treeview??? 'For example: lets say all nodes in a treeview is full collapse.. only the parent node is shown.. and Node1 is one of the nodes with a name = Node1 and a equivalent string value = "Node1" '**************figure1 +Level-0 Node1 +Level-0 Node2 Level-0 Node3 '*********************** 'and then when i attempt to search in all nodes of the treeview whether it is full collapse or out of the display area like "Node5" in figure2 then all nodes corresponding on the "Node5" parents node will open and select or highlited the "Node5" just like in figure2??? '*****************figure2 +Level-0 Node1 +Level-1 Node4 Level-2 Node5 +Level-0 Node2 +Level-1 Node6 Level-0 Node3 '**************************** is that possible in treeview?? how?? 'cause im having difficulty to figure it out myself.. Please anybody have a good idea?? please?? :confused:

Yup!! that's also what im thinking before.. create a temp. file if it returns permission/write protected error means false and if transaction success means true... i just got an error handling before but i've figure it out... hehe HERE'S my sample function: '***********start fucntion**** Private Function IsDriveWriteProtected(Byval DriveName as String) as boolean try 'System.io.File.Create() statement goes here.. return false catch ex as exception 'if error arise? means write protected or permission to write access denied return true end try End Function '************end fucntion******* ***********Thanks to "THE JZ" ******** youre a quite good help.. and i'll mark this thread as answered in your name.. thanks again... :)

is there any function in vb where you can retrieve if a specific removable drive or disk is write protected = true or false?? or any other way custom function you can retrieve its write protection state??? please...

modified on Thursday, July 24, 2008 4:30 AM

Please anybody there...know how to detect if a removable storage device is write protected?? i having difficulty to figure this out.. Please help?... i do really appreciate to anybody share their idea... please.. thanks in advance...

hello there... how can i detect or catch the event when mouse click/open any folder in windows explorer?? and how can i get that open folder path?? or even just collects all folder path in all open folder in any windows explorer that is open?? please help anybody there, who have a good idea about this?... please... thanks in advance... :)

Oppzzzz!!! Sorry to bother... im confuse... my user account is one of administrators account type and has no restriction.... i wonder why my application code does'nt work well until??? until i use the computer fixed/real administrator account when the OS first installed... which means??? all other administrators acount type.. dosn't really a fully administrator account??? Hey... "The JZ" thanks for the great help!!! youre a lot of help.. thanks again... :)

Yes! my user account is an administrators account... that's why im pretty confuse... why this can't work well.. and there's another... i forgot to say that my code, work well in Windows 2000!! but does not work on "XP Pro SP3" or higher like "Vista".. and i want it to work with this OS platform... you can try my code and let me know if it will work on XP Pro SP2 because i dont have XP Pro SP2 anymore... anybody there got a good possible solution make this work on the other OS platform?? i've already expected that my code will not work on Vista cause of its very high security features... but i wonder how to make it work in XP SP2 or neither XP SP3 which is my point of platform to run my application.. and also... Thanks to "The JZ" for giving attention in this thread.. i really appreciate a lot.. :) and im really glad if any body there will share their good idea... please???

Excuse me "The JZ" thanks for the reply.. i really appreciate your effort.. :) but i've try it before, before i've post this thread.. NOTE!!!!!!!! i forgot to say that this code work good in Windows 2000!! but does not work on "XP Pro SP3" or higher like "Vista".. and i want it to work with this OS platform... you can try my code and let me know if it will work on XP Pro SP2 anybody there got a good possible solution?? regKey = Registry.LocalMachine.OpenSubKey("Software\Microsoft\Windows\CurrentVersion\Run", True) but this still gives me a security exception error like this... X| System.UnauthorizedAccessExeption: Attempted to perform an unauthorized operation. at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str) at Microsoft.Win32.RegistryKey.SetValue(String name, Object value, RegistryValueKind value kind) but just like i've said before from the very first of my thread? my code can only read but can't write on the registry... how am i suppose to write in the registry using Microsoft.Win32??? without having security exception error... my user account is already an administrator and i already set my application as a full trust application in PROJECT PROPERTIES/SECURITY/ENABLE CLICKONCE SECURITY SETTINGS as FULL TRUST APPLICATION of my WINDOW PROJECT IDE VS2005.... '*********** please review my code******** '***********this is my real actual code a little differ in my fisrt code which i just simplified before**** Imports System.IO Imports Microsoft.Win32 Public Class myApplicationName Private Sub CreateAutoRegistryKey() Try Dim regKey As RegistryKey 'NOte: appKeyName will be look like this "myApplicationName.exe" Dim appKeyName As String = FileIO.FileSystem.GetName(Application.ExecutablePath) 'Note: then appKeyName will now look like this "myApplicationName" appKeyName = appKeyName.Remove(appKeyName.IndexOf("."), 4) regKey = Registry.LocalMachine.OpenSubKey("Software\Microsoft\Windows\CurrentVersion\Run", True) If regKey.GetValue(appKeyName) = Nothing Then MsgBox("No value found") regKey.SetValue(appKeyName, Application.ExecutablePath, RegistryValueKind.String) MsgBox("key " & appKeyName & " has been created") Else MsgBox("Value Found") If regKey.GetValue(appKeyName) = Application.ExecutablePath Then

'****i used to be put it like this example...*** '*************** Private Sub mySubFunctionName() try '****youre code statement goes here***** Catch ex As Exception MsgBox(ex.ToString) End Try End Sub

How to autostart up my vb application inside the system registry without "The specified RegistryKeyPermissionCheck value is invalid" i have created and experimenting a vb2005 win application which i need to auto start up when windows run.. so programmatically i have a code communicating in the system registry?? i can read from HK_LocalMachine SubKey's and KeyName and KeyValue's but then when my application attempt to create/write a KeyName with it's corresponding KeyValue?? this give an error like this: The specified RegistryKeyPermissionCheck value is invalid Parameter name: mode microsoft.win32.registrykey.validatekeymode(registrykeypermissioncheckmode) '********** here's my experiment vb code reading and creating KeyName/KeyValue in the windows start up... i've just learned this from other post... '****************** Imports System.IO Imports Microsoft.Win32 Imports System.Security.Permissions Public Class MySampleApplication Private Sub CreateKey() Dim regKey As RegistryKey Dim KeyName As String = "MySampleApplication" Dim KeyValue As String = "C:\MySampleApplicationFolder" regKey = Registry.LocalMachine.OpenSubKey("Software\Microsoft\Windows\CurrentVersion\Run", True, Security.AccessControl.RegistryRights.SetValue) If regKey.GetValue(KeyName) = Nothing Then 'if there's no KeyName yet? then create and set it's value MsgBox("No value found") regKey.SetValue(KeyName, KeyValue, RegistryValueKind.String) MsgBox("key " & KeyName & " has been created") Else 'if KeyName is already existing? then verified it KeyValue MsgBox("Value Found") If regKey.GetValue(KeyName) = KeyValue Then 'if KeyName is already existing and KeyValue is the same? DO NOTHING MsgBox("value equal") Else 'if KeyName is already existing but the KeyValue is diff from the original? then remodified to it's original path.. MsgBox("value not equal") regKey.SetValue(KeyName, KeyValue, RegistryValueKind.String) MsgBox("key " & KeyName & " value has been remodified and back to its original application path") End If End If Catch ex As Exception MsgBox(ex.ToString) End Try End Sub End Class

what an ashame... I think, i know whats wrong with my vb project... its not on the code but the versioning of active x component CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" i've found out that my crystal report viewer in my printing form is version 11.5.0.0 (AxInterop.CrystalActiveXReportViewerLib11_5.dll) and i've import or add it from the project components from a specific folder of my project which i downloaded from the intenet before.. which has the functionalities of CRAXDRT.REPORT.SQLQUERYSTRING and CRAXDRT.REPORT.RECORDSELECTIONFORMULA and my installed crystal report developer XI R2 is using crystal report viewer 11.5.3700.0 which has only the functionality of CRAXDRT.REPORT.SELECTIONFORMULA so it means my project will use or refer to crystal report library of version 11.5.3700.0, because that is the only crystal report installed in my pc... that's why whenever i've sqlquerystring it gives the error CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" because this can not find the functionality of SQLQueryString from CRAXDRT.Report v11.5.3700.0 but the there's something makes me puzzle? why does SQLQueryString from crystalreportviewer v11.5.3700.0 is missing? it is much higher version and must supposed to be stay there? this is crystalreportviewer11.5.3700.0 and it works using CRViewer11_5_37.selectionformula but when i type CRViewer11_5_37.SQLQueryString? there is no such .SQLQueryString and i can only find it at xraxdrt.report.SQLQueryString? ****************** Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class frmCrystalReport Public strSelectionfrm As String Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo) Try Dim myTableLogOnInfos As TableLogOnInfos = Me.AxCRViewer1.LogOnInfo For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos myTableLogOnInfo.ConnectionInfo = myConnectionInfo Next Catch ex As Exception MsgBox(ex.ToString()) End Try End Sub Private Sub ConfigureCrystalReports() Try Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo() myConnectionInfo.DatabaseName = DataSource myConnectionInfo.UserID = "admin" myConnectionInfo.Password = "xxxxx" myConnectionInfo.ServerName = "xxx.mdb" 'Your filter formula co

Are you sure the "Data Source" property isn't expecting the full path AND filename of your database? eg: crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = "c:\databasepath\filename.mdb" ********************* actually, not really... i just made so many experimentation also base on other post from the internet.. i've also try this code ************************** Public crxApp As CRAXDRT.Application Public crxReport As CRAXDRT.Report Public crxDataBase As CRAXDRT.Database Public crxTable As CRAXDRT.DatabaseTable Public crxTables As CRAXDRT.DatabaseTables Public crxConnectionProperty As CRAXDRT.ConnectionProperty Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) For Each crxTable In crxReport.Database.Tables 'STILL ERROR OCCURED HERE "Invalid Index" also to following crxTable.ConnectionProperties.Item crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source") crxConnectionProperty.Value = "D:\Folder1\Folder2\DatabseFolder" crxConnectionProperty = crxTable.ConnectionProperties.Item("Initial Catalog") crxConnectionProperty.Value = "myDataBase.mdb" crxConnectionProperty = crxTable.ConnectionProperties.Item("User ID") crxConnectionProperty.Value = "xxxxxxxxx" crxConnectionProperty = crxTable.ConnectionProperties.Item("Password") crxConnectionProperty.Value = "xxxxxxxxx" Next crxTable crxReport.Database.Verify() crxReport.SQLQueryString = strSelectionfrm AxCRViewer1.ReportSource = crxReport AxCRViewer1.ViewReport() crxDataBase = Nothing crxTable = Nothing crxTables = Nothing crxReport = Nothing crxApp = Nothing Catch ex As Exception MsgBox(ex.ToString()) Finally Me.Cursor = Cursors.Default End Try End Sub ******************************* and still??? the same error... and i've also try this code and still the same error.. :( :(( ******************************* crxConnectionProperty = crxTabl

Your are still using assignments like crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath This is similar to saying: x = y = 5 The result stored in x will be either true or false, depending upon whether value of y is 5. ********************* actually, not really... i just made so many experimentation and also base on other post from the internet.. i've also try this code ************************** Public crxApp As CRAXDRT.Application Public crxReport As CRAXDRT.Report Public crxDataBase As CRAXDRT.Database Public crxTable As CRAXDRT.DatabaseTable Public crxTables As CRAXDRT.DatabaseTables Public crxConnectionProperty As CRAXDRT.ConnectionProperty Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) For Each crxTable In crxReport.Database.Tables crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source") crxConnectionProperty.Value = "D:\Folder1\Folder2\DatabseFolder" crxConnectionProperty = crxTable.ConnectionProperties.Item("Initial Catalog") crxConnectionProperty.Value = "myDataBase.mdb" crxConnectionProperty = crxTable.ConnectionProperties.Item("User ID") crxConnectionProperty.Value = "xxxxxxxxx" crxConnectionProperty = crxTable.ConnectionProperties.Item("Password") crxConnectionProperty.Value = "xxxxxxxxx" Next crxTable crxReport.Database.Verify() crxReport.SQLQueryString = strSelectionfrm AxCRViewer1.ReportSource = crxReport AxCRViewer1.ViewReport() crxDataBase = Nothing crxTable = Nothing crxTables = Nothing crxReport = Nothing crxApp = Nothing Catch ex As Exception MsgBox(ex.ToString()) Finally Me.Cursor = Cursors.Default End Try End Sub ******************************* and still??? the same error... and i've also try this code and still the same error.. :( :(( ******************************* crxConnectionProperty = crxTable.ConnectionProperties.Item("Data Source") crxConnection

crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath Where is crxDataBasePath defined? Moreover, I think that the right hand side of the assignment will be evaluated to a boolean (crxTable.ConnectionProperties("Data Source") = crxDataBasePath) and this boolean will be assigned to crxConnectionProperty. ************ crxDataBasePath is defined from a vb module from the same vbproject and it is declare to be "public" so my other vbfiles or vbform can access it readily inside the project.. public crxDataBasePath as string = "D:\folder1\folder2\Database" i've also try to used this direct code: crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = "D:\folder1\folder2\Database" for me to test it... but still the same error... CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" ************************ For Each crxTable In crxReport.Database.Tables crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath crxConnectionProperty = crxTable.ConnectionProperties("Initial Catalog") = "dbEmployee.mdb" crxConnectionProperty = crxTable.ConnectionProperties("User ID") = "myUserID" crxConnectionProperty = crxTable.ConnectionProperties("Password") = "myPassword" Next crxTable ************** May be i try also "ChandraRam" suggestion.. thanks for everyone's participation and help..i really appreciation your help.. and please if anybody who can share their good idea there... please help... cause this CR reporting is not that so easy to figure it out specially to a bigenner like me.. thanks again in advance... God speed.. :)

Yah.. i've also try that myself in any way i can come up to solve that frustating code.. :( and experiment in many ways and also i tried to search other codes related to this and i find out they used the same crxTable.ConnectionProperties("Data Source") but then in vb6 code.. i think the code is something closely right but ther something missing or lacking in my code in that part.. i dont know what it is... :doh: im referring also to other forums but this site is the only one replying on my post... so hard... :(

Note: The error occurs here crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath Should this say crxDataBase, not crxDataBasePath? ******* Yup!! actually i try it both... public crxDataBasePath as string = "D:\folder1\folder2\Database" For Each crxTable In crxReport.Database.Tables crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath crxConnectionProperty = crxTable.ConnectionProperties("Initial Catalog") = "dbEmployee.mdb" crxConnectionProperty = crxTable.ConnectionProperties("User ID") = "myUserID" crxConnectionProperty = crxTable.ConnectionProperties("Password") = "myPassword" Next crxTable ******** still the same error in that first line of, crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath .. CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" ********* and also please you may double check my code.. here it is.. *************************** Public crxApp As CRAXDRT.Application Public crxReport As CRAXDRT.Report Public crxDataBase As CRAXDRT.Database Public crxTable As CRAXDRT.DatabaseTable Public crxTables As CRAXDRT.DatabaseTables Public crxConnectionProperty As CRAXDRT.ConnectionProperty Public strSelectionfrm As String Public strCRSourcePath As String Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try ChildFormAutoSizeFit(Me) Me.Cursor = Cursors.WaitCursor Me.MdiParent = frmMain crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) crxTables = crxReport.Database.Tables For Each crxTable In crxReport.Database.Tables crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath crxConnectionProperty = crxTable.ConnectionProperties("Initial Catalog") = "dbEmployee.mdb" crxConnectionProperty = crxTable.ConnectionProperties("User ID") = "myUserIDxxxxxx" crxConnectionProperty = crxTable.ConnectionProperties("Password") = "myPasswordxxxxx" Next crxTable crxReport.Database.Verify() crxReport.RecordSelectionF

anybody who knows or have an idea about this error in VB2005 and CrystalRport XI R2 and MS ACCESS? CRAXDRT.ConnectionPropertiesClass.getItem(String Name) "Error: Invalid Index" Here's my code: ************************ Public crxApp As CRAXDRT.Application Public crxReport As CRAXDRT.Report Public crxDataBase As CRAXDRT.Database Public crxTable As CRAXDRT.DatabaseTable Public crxTables As CRAXDRT.DatabaseTables Public crxConnectionProperty As CRAXDRT.ConnectionProperty Public strSelectionfrm As String Public strCRSourcePath As String Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try ChildFormAutoSizeFit(Me) Me.Cursor = Cursors.WaitCursor Me.MdiParent = frmMain Dim i As Integer = 0 crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) crxTables = crxReport.Database.Tables For Each crxTable In crxReport.Database.Tables 'Note: The error occurs here crxConnectionProperty = crxTable.ConnectionProperties("Data Source") = crxDataBasePath crxConnectionProperty = crxTable.ConnectionProperties("Database Name") = myDataBasePath & "\dbEmployee.mdb" crxConnectionProperty = crxTable.ConnectionProperties("User ID") = "myUserID" crxConnectionProperty = crxTable.ConnectionProperties("Password") = "myPassword" Next crxTable crxReport.Database.Verify() crxReport.SQLQueryString = strSelectionfrm AxCRViewer1.ReportSource = crxReport AxCRViewer1.ViewReport() crxDataBase = Nothing crxTable = Nothing crxTables = Nothing crxReport = Nothing crxApp = Nothing Catch ex As Exception MsgBox(ex.ToString()) Finally Me.Cursor = Cursors.Default End Try End Sub ******************* actually i know that the error's occurs on the part where.. crxConnectionProperty = crxTable.ConnectionProperties() -->indexing or string name.. but i have just follow it from other forums that works for them.. anybody who have a good solutions about this error?? Please help... Im so frustated to figure it out myself... :(

Is there anybody there have an idea to resolve this vb to crystalreport XI connection problem... Im using VS2005 VB and MS ACCESS '07 and Crystal Report XI R2 Here's my code ****************** Private Sub myReportForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try ChildFormAutoSizeFit(Me) Me.Cursor = Cursors.WaitCursor Me.MdiParent = frmMain crxApp = New CRAXDRT.Application crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) crxDataBase = crxReport.Database crxTables = crxDataBase.Tables For Each crxTable In crxTables crxTable.Location = DataSource 'My .mdb source path crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & crxDataBasePath, "myDatabase.mdb", "", "myPassword") Next crxTable '**** Note: 'When ever i used this recordSelectionFormula? it works properly 'and it get connected and show the report but then this 'recordSelectionFormula is something limited for filtering data thats 'why i need to use more flexible filter like CRXDRT.Report.SqlQueryString 'but then my problem is the login connection from the database is somewhat failed... '**** 'this RecordSelectionFormula works 'crxReport.RecordSelectionFormula = strSelectionfrm 'this SQLQueryString failed.. why?? what's the different? crxReport.SQLQueryString = strSqlQuery AxCRViewer1.ReportSource = crxReport AxCRViewer1.ViewReport() Catch ex As Exception MsgBox(ex.ToString()) Finally Me.Cursor = Cursors.Default End Try End Sub ************ here's my "strSelectionfrm" *************** strSelectionfrm = "{CmpnyDetails.IDNo} like '*' and {tblCompanyDetails.Status} = 'REGULAR' and {Attendance.AFrom} in #" & Format(DatePickerFrom.Value, "MM/dd/yyyy") & "# to #" & Format(DatePickerTo.Value, "MM/dd/yyyy") & "#" ***************** and here's my "strSqlQuery" ************* strfilter = "Select * from CmpnyDetails as cd left outer join Attendance as att on att.IDNo = cd.IDNo where (att.AFrom Between #" & Format(DatePickerFrom.Value, "MM/dd/yyyy") & "# and #" & Format(DatePickerTo.Value, "MM/dd/yyyy") & "#) and cd.[Status] = 'REGU