Search results

HI I have MS access 2000 database which is password protected. I have scheduled a VB script to run the macro evry 5 hr in a day, Since it is password protected, every time when i run the script it is asking me the password to enter, how can i mange them in VB script itself. Here is my code...

Hi Brian, I was really confused myself for the last two days on this issue, and i truly respect your options were not properly gone through . I have found the solution for retriving specific time value. find my code below, hope this will end all my queries now. SELECT IOData.CardNo...

Brian, Thanks again, now i tried the following code with your inputs SELECT IOData.CardNo, IOData.IODate, IOData.IOTime , IOData.IOStatus FROM IOData WHERE IODate=date() and IOTime Between Dateadd("h",0,Now()) and now() I have a record for current date and IOtime has 11:22:00 . now when i...

Hi I am trying to export the table for records for specific date and specific time using macro, now that i am able to get the record for current date code for getting record for current date: SELECT IOData.CardNo, IOData.IODate, IOData.IOTime, IOData.IOStatus FROM IOData WHERE...

Thx all for your replies, I think you guys did not get my questions right. the IOTime field carries only the time(09:02:27) and i need to fetch the records for the condition IODate --> current date and IOTime either the current time Thx once again for your replies.

Hi I have created a MS access table which captures the attendance for the employee. In the table , the field IOTime carries the time of the associate entry. I have written an SQL query to fetch the data for the current date . but i am unable to get the records for specific time. Can...