I have a Date/Time type field, which is called "Date", in a table called
"tblHomePrac"
Then, in a form, I enter a date (it looks like "12/1/2006" because I had
the format of the textbox to be "shortdate"), and look up the table to

I have a Date/Time type field, which is called "Date", in a table called
"tblHomePrac"
Then, in a form, I enter a date (it looks like "12/1/2006" because I had
the format of the textbox to be "shortdate"), and look up the table to

Is there a procedure or utility to load a windows explorer browse window on
a form - to select a path and file name?

When attempting to export a module "manually" to another mdb, the module
does not export and there is no error message. Exporting the module through
a macro or code produces a Run-time error 3011.

For short time ago someone install some dll ON my vb6. and since then the
mouse wheel has started affacting on my work.
Does someone knows what is this dll? and will it effect the same thing on
access VBA?

I am new to VBA DAO and I am having a problem populating a form with records
using DAO. I have the following code in the Forms OnLoad event:
   Dim dbs As Database
   Dim rsFCE As Recordset

I am looking to develop a bit of code/algorhithim which can
compare/match two tables of data- essentially a tool to spot cross
matches between two different lists.  Both tables contain the following
fields

I have been trying this for an hour now but have not been able to make
this work!
So, I have an Access report (actually all it has is a header so far).
What I want to do is modify the header based on the selection the user

I have a lot of similar code which I use in other Access applications.
So I exported the general modules to a separate database (mdb-file).
Next Iput a reference to this database in the Reference option in the VBA
editor.

I have been using the following in my databases to determine if a form was
open or not
Function fIsLoaded(ByVal strFormName As String) As Integer
'Source: http://www.mvps.org/access/forms/frm0002.htm

Hello Group,
I did start Excel programming few days ago and have created an Add-In
module. Currenlty I run it in VB Editor which is embedded into Excel.
It shows a modeless dialog of userform and has one button when user

I am trying to add the below SQL Query into VB. It seems to fall down on the
"Where" definition.
Can anyone see where I've gone wrong?
Function AppendCpartyYesterday()

Suppose we have 12 months a year and each year has only 30 days.
For example a worker until month 8 has worked for 170 days and I'd like to
fill in 5 months(150=5*30 days) and 20 days salary for him.(170=5*30+20)
Month 8    30 day

I'm trying to find out from VB which page is currently selected on a Tab
Control. I need to requery lists, etc. on each tab control page when a
different item is selected on the main form that contains the tab control. I
want to therefore detect which page on the tab control is ...

I have a question about forms and reports in Access and whether they
could be made to share the same window.
So what I am trying to do is the following:
I have a report that is fed by a query and the user can set the filters