VB Forum / Database Access / August 2007

I've now completed the database for my son in Access 2000, and it works
splendidly!  (Thanks for your help two weeks ago)
My only problem is that in the VB6 overlay I can't seem to force the
recordset to limit calculated values in text boxes to 2 decimal places even

From a View in SQL Server Mgmnt Studio Express, can I get 'click'/'mousedown'
or
equivalent event information when the mouse is clicked on a row.  
I need to know the event occurred, and which row it occured on.  I need to

As the new guy on the team I've been assigned to migrate my team's VB6
support applications to Vista so that our tools will be ready when the
company moves to Vista. I haven't hit any walls until now.
We gather data from several sources to produce that database that our

I'm trying to copy records from the Event Logs to a databse. I can read the
database & the event logs but hit a problem when trying to create a NewRow.
Follows is the code - scroll down I've indicated the line in question.
Thanks in advance for assistance.

how do i get the DateTime value before 30 Minutes from Now in DateTime format
in VB?
I use following src code to get the now datetime format,
Format(Now, "dd/mm/yyyy h:mm:00 AM/PM")

I have two databases with identical schemas.
What I want to do is to select all the records each and put them into
one Dataset to display in a datagrid (preferably sorted.)
Is there one select statement that would take care of this?

I am opening two databases, iterating through a table in one of them and
making "INSERT INTO" queries to copy the data to a table in the second
(using the execute method).  The machines are both physically on the same
network segment.

Very strange.  I'm getting "No value given for required parameter" in
a no paramater query executed from the detaail section of a report.
Is there something specific to reports that I can't do this?
Function get_keys()

Dear All,
I have problem to read the Ms Excel File using VB source code.
Below source code i use.
Public Sub Write2Excel()

I had a requirement :
There are some column values in excel sheet containing some date columns and
other data running from around 6 months.But the requirement is to retrieve
the whole set of column values or data which lies within the present week,ie,