Search results

Here's a problem...i hope you can solve it...I don't understand where I am going wrong. Function test1234(....) On Error GoTo errorcode ... ... docmd.runsql "........" docmd.runsql "........" Msgbox "executed successfully" Exit Function errorcode: Msgbox "not executed" End Function The problem...

currently name of my database is tool.mdb...if i change it to some thing else...it won't work...how to remove this dependency... the error is in this part of the code strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & CurrentProject.Path & "\tool.mdb;"...

I have been trying this for many days...but i have not got any result. I have even googled extensively. Please help me out in this. This is my last stop. I have to plot graphs based on data in a access table. the data is some thing like this Area Commodity Month Target...

Hi, I split my database to backend and front end. my tutor wants it to be set up on "LAN" and she should be able to use the front end... The prob is it is working only if BE and FE are in the same folder... now how should i proceed... Please help me out.

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...

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...