I'm making a simple DB to track books that are checked out. I build my
tables in the following order:
CREATE TABLE Publisher(
PublisherID AUTOINCREMENT,

I need to create a query whereby when I run it I get a prompt to input
anything I want, in this case a date.  The field doesn't refer to any field
in the tables I'm using, it's just sort of a "wild card".  I know in the
criteria area I can put in [date] and i'll be prompted for ...

I've have just about finished my little project and had a strange problem
arise today that hasn't happened before. Since the beginning of this I've
been writing the app on one machine, I'll call that build machine and then
coping them to the another (work) machine. Today I ...

I'm helping a friend upgrade his office computers. He has an Access
d/b application on one of his computers. It's running Win95, and
Acess97. The developer changed the app into an MDE file which includes
the data and application code both. I would like to allow the

I am trying to find a template that can help manage my wife's purse
manufacturing business. Each purse has about 10 components to choose from,
with a variety of versions for each component. For example, the exterior
fabric is one component, and there and many styles of exterior ...

I have created a bunch of employee records in my data base.  I would like to
have a Drop-down menu that has all of the last names of the employees and a
button that would open the <Employee Data> FORM with the record that
corresponds with the last name of the employee when the ...

I am creating a database for the 1st time and I have come a long ways!  Now I
have encountered a glitch where the field in the subform which calculates a
value there correctly doesn't copy that value to the corresponding field in
the table.  I have another field that also does a ...

Anyone know where I can get a trial version of the Access 2002

I have created a few drop down lists on a form using a wizard.  I have
entered the values on individual tables for the drop down lists and the
values are displayed correctly in form view.
My problem is that if I enter values using the drop down arrows, the inputs

I would like to put a command button on a form that would clear all the
data for the record shown.
What is the best way to proceed please?

I have 2 reports, proposal and project
both of them came from 2 different queries
everytime I click in proposal report it will ask me which month I would like
to report the proposal, same thing as the project report.

I have my DB split now but have some questions.  Can you link to more than
one backend DB in different locations?

I added a Note in my form, and I have the space huge like a memo for the
purpose of adding additional description of a project or proposal.
However whenever I'm putting some information and I press enter (i'm meaning
to go to the next line) it goes to the next field it assumes im ...

I've created the following expression in the design view of a query.
Expr: [Option1]*1+[Option2]*2+[Option3]*3+[Option4]*4+[Option5]*5+[Option6]*6
I get a message that "Option 1" etc can refer to multiple sources; e.g. the
Questions table and the Responses table.  When I then ...

I m working on a form at work in MSAccess . I m trying to find how i
can have a pop in one of my queries to ask for the some of the
information i want to sort and rrun the querie.
thanks