How to write script using Database

Hello,

I have imported log file into MS access with columns server,date,time,url.I need to write VB script in VB editor for accessing rows in between given date and time.

It's urgent.please can any body help with this.

Thanks

sappi_01
Profile Answers by sappi_01 Questions by sappi_01
Dec 12th, 2007
1
4988

Questions by sappi_01

Microsoft Access

Answer

Showing Answers 1 - 1 of 1 Answers

Lokesh M
Profile Answers by Lokesh M Questions by Lokesh M

Nov 29th, 2011
MS Access has built-in Visual Basic Module Editor,
Click on Modules Tab
Click New
Create Public Function
Put in your code
Save, Close, Re-Open,
Now you can use your VB Script anywhere in MS Access by calling the function name.
Code
span style="color: #ff0000;">"SELECT * FROM [Log_Table] Where Date = #"" and Time = #""#"'Do Whatever you want here