I created a simple report.  However, the users now want to be able to
control in which way the data gets sorted which project get included....  I
originally was trying to create several report one for each requirement and
control which one is visible depending on the selections made ...

I am trying to get the Like operator to work in a situation where a
street address is entered.  I would like someone who enters 44th to be able
to pull up all records with 44th in the string such as 44th Street, 44th ST
SW, West 44th Avenue, ect.  The code I have now is designed ...

How do you determine the Windows user name from within Access?  Please note,
not the secure workgroup name used to login to Access.
Thank you for your help.
Mark

I have some reports damaged in Ms Access2002, So I open a blank database and
imported all objects from the old one, except the reports damaged.
What’s happened? The references doesn’t update automatically, I update
manually DAO 3.6; Excel 10.0 Graph 10.0.

I can't get this syntax right.  I've tried both the Select and the Value
parameter, but to no avail.  Error message indicates too few parameters.  
Expected 2.
Can anyone help, please?   Thanks for the help!

I have created a database in order to track 10 weeks of information.  I have
created forms to input information into current weekly tables.  However, I
have been unsuccessful at transferring the information from the current week
table to the 10 week table in the appropriate week. ...

Can anyone tell me the Objects/methods I would need to access data through
linked tables that are in turn pulled from ODBC datasources?
MODEL
   national database  <-- ODBC <-- access Linked table <-- local access copy

StrSql = "Insert into........"
From a Command Button I am using the "DB.Execute strSql, dbFailOnError"
method to insert records into a table (The block of code works in all other
aspects).  I want to eliminate the Access default MsgBox and replace it with

I copied a module that somebody had earlier written for me
from one database to another; while I was trying to use a
macro refering to a function in the module, a window pops
up to warm me that

I've done very little with forms, so please forgive my ignorance here.
I have a form (columnar) I created with the wizard.  It lists multiple records
in one table.  I need to filter what it displays, so all the displayed records
are related to each other.  I was thinking of two ...

I have tried several attempts to use a DATE variable in my WHERE clause and
continue to get data type mismatch.  This is the last attempt...
dtDate1 = Forms!frminclusivedates!date1
dtDate2 = Forms!frminclusivedates!date2

I have a form in MS Access -2000 which retrieves data from a table and based
on the values in two columns a lable on that form has to be made visible /
invisible. The form has a combo box which helps in refreshing the data in
that form. So in the datachange property of that combo ...

I have a need to update access version, like this:
1. User in Db1 which is saved in user's hard drive, clicking "update"
2. Db1 opens Db2, which is saved in server.
3. Close Db1

This errors on the varTemp = Eval(Mid(ctl.OnClick, 2))
line.  And while the OnClick property shows in the Object Browser, it does
not appear in the property/method list when you type "ctl.".
Public Function DoIt()

Dim Thisdate, ThisMonth as date
ThisDate = #11/15/2004#
MsgBox ThisDate
ThisMonth = Month(ThisDate)