How would I construct a Dlookup statement to locate a specific date in a
table based on a date on a form?

I need help.  I want to create a database for the company that I work for.  
My boss has forked over some major cash into a database program that will not
work with the company's business model.
Basically I want to create a web page where employees can enter in data and

I'd like to learn more about programming for my access databases.  I've
bought some books, but they are difficult to get through.  Does anyone know
of other resources, good tutorials, or easier reads?
Thanks!

I'm using ASP to connect to an Access 2003 database on a Microsoft
2003 server running IIS.  To access the data, I open up a DNS-less
connection and use SQL queries to get the records.  Many of the sites
have several queries and I'd like to know whether or not I should open

Adding a file to a 2nd PC. Works on my PC (development) and on the live PC.
An SQL statement within VB module, SELECT ..., has the error. Removed and
re-installed MS Office 2000 (same on all PCs). Re-installed MDAC 2.81.
Checked ADO/DAO Library checkboxes in Tools (same ...

Could someone please explain when you would use a macro and when you would
use VBA? So far, I've accomplished everything I need to using VBA and can't
see why you would use macro's at all.
Thanks,

Hey there,
I have a form with a button with the following code attached to it. I want to
insert the values from the controls on that form to a separate table. (Form
is bound to another table).

MS Access Packaging Wizard ..  Set-up install error
After creating set-up and runtime CD.  Trying to run the Set-up CD on a
target pc.  Error:  "Office Service Pack cannot be installed on this system
because it requires NT 4.0 Service Pack 6.0 or later. "

I am trying to learn the basics of Access for VBA but so far it is kicking my
butt.
I am trying to export a table to specific ranges in the excel spreadsheet.
Every time I try and run the code I get an error at "myrecordset.Open mysql"

I read that it is not good to overwrite built-in function names in
Access. But as our project used to run with Access97 for a long, long
time, we user defined some util functions and named them as they are
built-in in newer Access versions.

greetings to all
I need help with code for a function.  I'm getting close but keep messing
up.  My sports league determines the 'competing age' of its athletes, given
their DOB, as follows:

I am currently using Access 2002 to control the availability of stock
at any given point in time in the future. (stock is used for a job,
then returned, so that it can be used again.)
I run a Macro that looks at the value of a specific field

I need to parse(or is it contencate) 2 fields together from different tables
to make a Primary key on each record in my main table [Training Course], the
Primary Key is called [Course ID] and i need help to write the code to parse
the data from the fields "Date" in [Training ...

I have a DBS that has records in it that employees call.    I have created a
form in which they input the data from the call.  Some records have multiple
telephone numbers.  What I would like to do is on the form have a list box to
show all of the telephone #s.  To the side I ...

I have a class module as follows:
Private frm As Access.Form
-------------------------------
Public Property Get aForm() As Access.Form