I am struggling with a general lookup function.  I want the user to be able
to look up a vendor id or name from field with in a form and have the form
populate with the correct vendor information.  The fields (ex. Vendor ID,
Owning LOB, Risk Rating, Service Category, etc.) in ...

Some of my combo box requerys work and some don't.  I have a form
"PeopleDetails" that contains all the people.  In this form there are check
boxes that link with queries that include these people in differant lists.  
For instance, if you check the box that they are a singer than ...

In Access 2003, is there a way to completely clear previous "filter by form"
selections? In particular, I filtered by a checkbox, and now anytime I wish
to filter by form the checkbox trips me up. I think the checkbox is clear,
but it's really filtering by the value being false. ...

I have a button on form that exports out a select query to an Excel
spreadsheet using the OutputTo function.  The button works great.  It
does everything I want it to (thanks to the this group).  However,
there is one thing that I cannot get it to do, and that is get the

I have a query - There everything is ok
The data can be changed
But when I create a form base on the query (Using Wizard - just select
the table) the data caould not be changed via the form,

I suppose like most here, when I close a particular form, it then
loads the previous form from which the particular form was called.
What I am trying to do is halt the previous form re-loading if I
decide to go straight to design mode.

I have tblApplication Table. I have a tblContract Table.  I have a continuous
form that uses these 2 tables to allow the user to create a quick contract
for everyone who has submitted an application.  In most cases the "start"
(date) field will always be the same date.  So I ...

I have a form, I would like the user to be able to open a record and press a button on the form which would then "put" a predefined string into the "comments" field of that record, which is displayed as a text box.
I tried using comments.text = "This is my comment" in the ...

Many years ago I downloaded a sample database written by Arvin Meyer that
was a Document Manager.  I modified it quite a bit, adding keywords so
people could narrow their searches for files, but left the original code
where it searches for all files in a selected folder and ...

I am using Access 2007 and I have a Split Form that is on tabbed form; but
whenever I try to view the form it doens't show the datasheet form element.
But if I open the form on its own, it will show the corresponding datasheet
form element. Does anyone know if it is ok to place a ...

Hello Gang,
I was wondering if someone would be able to help me out.
In the main form I have an option group of toggle buttons that make the case
criteria for a report, the criteria is loaded to the report through the

I'm trying to create a form for data entry, the form will be used for
entering data into 4 unrelated tables.  I have bound the form to one of the
tables (text entry only), the rest of the data to be entered is check box.  I
can't seem to get the check box entry to work.  I insert ...

I have a subform where a user is required to roughly estimate cost
allocations between several possible work categories. eg if there are 3
applicable work categories they might allocate a percentage split of
10%:70%:20%. I have an unbound field that sums the percentage to assist ...

In Access 2003, I have a form with no control source; only a listbox
populated from a query. I also have a subform that I want populated from a
value in the listbox. Since there is no control source for the form, the
wizard that establishes the relationship between the two forms ...

Most likely I am making this harder than it should be!!!!  You Guru's may
laugh at this one, but I just can't get it.
The problem - The combo boxes only work where there is a unique
FRDF_CATEGORY.CHILD_REF=FRDF_CATEGORY.CATEGORY in the FRDF_CATEGORY table!