Ask Experts Questions for FREE Help !
Ask
    vasu_43's Avatar
    vasu_43 Posts: 0, Reputation: 1
    New Member
    		  
    #1

    May 11, 2007, 11:20 PM
    invalid oudside procedure
    I want to creat data report in run time give specific date criteria while run code below gives arror message "invalid oudside procedure and highlighting on the ""Provider=Microsoft.Jet.OLEDB.4.0;"

    Private Sub DTPicker1_Change()
    Dim Mycon As New ADODB.Connection
    Dim M2 As New ADODB.Recordset
    Dim S1 As String

    S1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & _
    App.Path & "MainDB.mdb"
    'M2.Open "select * from MainDB where booking_from>=#" & DTPicker1.Value & "# and InvDate <=# " & DTPicker2.Value & "# order by InvDate", Mycon, adOpenDynamic, adLockOptimistic
    M2.Open "select * from MainDB where booking_from>=#" & DTPicker1.Value & "#, Mycon, adOpenDynamic, adLockOptimistic"
    'Here I have used two dtpicker controls which consists of any two dates

    Set DataReport2.DataSource = M2
    DataReport2.WindowState = vbMaximized
    DataReport2.Show vbModal
    M2.Close
    Mycon.Close
    End Sub

Check out some similar questions!

Invalid e:drive [ 4 Answers ]

I have been trying to download Windows Defender but I can't because I get invalid Drive e:\ message. I am not very computer literate so am not really sure about what to do. I thought I could Map Network Drive but I don't know which Folder to select. Also a colleague tried to install software for a...

VDD in registry is invalid [ 1 Answers ]

I cannot open certain older programs and I get this message. Running Windows XP. How do I repair this?

Invalid drive [ 1 Answers ]

I have compaq p1,booable from FDD.I formatted it dos mood by command format c:/s.Now it boots,but when I insert win98 cd it does not know cd and sys invalid drive. I tried all drive letter.

Invalid backweb id [ 2 Answers ]

Upon start up in windows xp, I get this little message box saying "invalid backweb id 1940576". Ever since this guy showed up, my computer has slowed considerably, probably to about 20% speed. Where can I go and what can I do to correct or delete this devil? Norton Utilities finds nothing...

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.