I am making my first database ever.
It is simply to keep track of keys - who has what keys checked out.
You type in their Name and Room #, select their Department (further
questions about that one), then check which keys they've been given.  There

Hi, got a strange problem.
I've got a form 'EditPartNumbers' where a user can filter the records by
selecting a value in a combo box, which in turn populates a value in a hidden
text box, 'txtFindHidden'. The form is then supposed to change it's

I've got a problem on one of my forms. I want to work out what the current
month is so I'm doing this:
Dim currentmonth as Integer
currentmonth = Month(Date)

I am still fairly new to Access and VBA so there might not even be a way to
do this, but what I have is a subroutine that writes to a word document.
Since this word document is fairly large it takes a couple of seconds to
write to the document. If the user accidentally selects ...

i have a main form which has the ID and Type of the Product. i have a service
report form that is linked through the ID. is it more effcient to do a
dlookup for the type of product on the service report, or is it better to
pass it through an open args.

I am working with a database that uses a form to allow the user to select
three criteria for a query which is used in a report.  One of the criteria is
a field containing either a Y or N.  The user has been able to select either
Y or N to generate the report with the selected ...

I am looking to avoid having to use a bunch of nested IIf statements in the
query I am trying to design.  Is there a way to somehow create a table to
which a query will use as the basis of an IIf statement?  For example:
"Result: IIf (Condition1 = [Table1].[Factors], x, y)"

I have a button that prints a report with a filter, but when it prints the
report, it ignores the filter.  I had messier code worked (it changed the
record source before printing, but that meant it had to open the form in
design, change the record source, go back to print preview ...

I'm trying to create a form with a combo box that from the item chosen in the
combo box it will display only that information for that name.
So if the item chosen is server1
the information will be only about that server.

I am trying to create a form that creates a filter. On this form I have a
listbox that holds all the fields in the table. when a user clicks the field
in the listbox, I can get the Data Type of the selected field, but I'd like
to know if that field in the table has a RowSource ...

A form in datasheet view has a column for manufacturer and a column for
product. Each is a combo box.
RowSource for the product combo box is dictated by the contents of the
manufacturer combo box:

I currently have a form with several date fields. When these fields are
double-clicked, a calendar pops up! This works fine, however, I would prefer
to have the calendar pop-up on the click of the drop-down arrow of the combo
box. If there where an Event called "OnDropDownClick", ...

I'm trying to add basic code to and OnChange event for a text box on a form
but I keep getting error messages.  This code worked in Access 2003. For
example:
"Dim varEndDate as Date"  This code produces error message: "Object or class

I saw some introduction of the Access 2007; it said that the new Access 2007
can add pictures on multiple forms without coding. Does the Access 2007 allow
the user to browse the image from a folder and display them in the
corresponding record or user has to put the path of the ...

I love Access, its rapid development, easy to gets your hand on the
data, easy to make quick updates.
The problem I have however is that access seems to have a reputation
of not being heavyweight enough to support critical systems.  I'm