I want to get data between a certain range of date from VB6 to Ms Access. Here is my code:
sqlh = "SELECT * FROM CustomerOrders WHERE OrderDate BETWEEN #" &
CDate(dtpFrom.V alue) & "# AND #" & CDate(dtpTo.Val ue) & "# ORDER BY OrderDate"
It works so strange. When I tried:
- only September, e.g. between 4 Sept - 26 Sept, it works perfect;y
- between September...
egp
Last Activity: Oct 16 '06, 10:13 AM
Joined: Sep 27 '06
Location:
-
egp started a topic Display report, backup n restore tables Ms Access, and open HTML file using VB6 codein Visual BasicDisplay report, backup n restore tables Ms Access, and open HTML file using VB6 code
Hi guys,
I have a database using Ms Access 2003 connected to VB6 using ADODB Connection and I want to know how to:
- display Ms Access report in VB using VB code then print it out
- backup and restore Ms Access table using VB code
- open HTML file using VB code
Is there anyone can help me please? It's urgent.
Thanks before
No activity results to display