Search results

allan, thanks for replying.... Function IsDupeslam(cs1 As String, cs2 As String, cs3 As String, cs4 As Date) Dim y As Integer y = Month(cs4) Debug.Print y End Function Call Isdupeslam("aa","bb","cc",1/1/2009) gives 12...??!!! Call Isdupeslam("aa","bb","cc",#1/1/2009#) gives 1....which is...

Sub testdate(t1 As Date) Dim s As Integer t1 = Format(t1, "mm/dd/yy") Debug.Print t s = DatePart("m", t1) Debug.Print s End Sub Call testdate(06/19/2009) is giving 12 Call testdate(#06/19/2009#) is giving 06....(correct value) In my code, I have to extract the month and year part from cs4...

wbPath = "C:\mdrr\rameez.xls" strSQL = "Insert into tablename SELECT * FROM [Sheet1$] IN '" & wbPath & "' 'Excel 8.0;'" I am even hardcoding the path....i want to remove this and let the user select the required file...

I am importing a table from excel to access. It works fine...but my code has certain limitations. I am a novice in Access and Please for God sake help me out...My queries are. 1. I am hardcoding the name of the mdb file in my vba code.so if someone changes its name, it won't work. can u plz...

I have 4 tables...T1,T2,T3 and T4. The data in T1 has to be populated to T2 based on condition that T1.A=T4.A...else it has to be populated into T3. Can u plz help me to do it using vba code... thanks in advance.

I have a form prepared using form wizard. The form refers to data from a table. It is actually sale data for each month. I have added filter functionality. Now I need to draw graphs for the filtered data. Or can you tell me how to pass a sql to a chart(MS graph object)!!??? Hope u...