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
3
4904

Questions by sappi_01

Microsoft Access

Answer

Showing Answers 1 - 3 of 3 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
Public Function Fetch_Log_Rows(xDate as Date, xTime as Date)


 


Dim xRec as DAO.Recordset


 


Set xRec = CurrentDb.OpenRecordset ("SELECT * FROM [Log_Table] Where Date = #"+xDate+" and Time = #" + xTime + "#")


 


xRec.MoveFirst


While xRec.EOF = False


   'Do Whatever you want here


   xRec.MoveNext


Wend


 


End Function