In my database I have two tables: Jobs and Invoices.
In Jobs, I have the fields: Job No (Key), Invoice No and etc
In Invoices, I also have the fields: Job No, Invoice No (Key), and etc
Let me make it simple to assume that a 1 to 1 relationship between jobs and

I have noticed that you can instance forms and I was wondering if you could
do this with a series of text boxes on a form, i ask this as I currently have
a form which updates (currently 6) unbound textboxes from a date range query
and often I have found that all the records are ...

I have a form and I want my users to be able to open a certain spreadsheet I
Excel if they press a button on mty form. How is this done?

I've looked at the various treeview examples (Alex Dybenko's etc) and
modified them to suit my needs. Everything works as expected until I try to
add images to the tree.
As far as I'm aware, you create an imagelist control, insert the images and

Form has a before update routine that cancels the update if required fields
are null.  There is a close button and the form's close X is hidden. I wish
to continue allowing users to use the main app X at top RHS to close the app.
The problem is this:

Hi! Ihave a form called "VendorSearch" that has comboboxes called
"vendorCounty", (which is linked to a zipcode table and displays county and
state) "vendorSpecialty", (which is linked to a table that has Vendor
Specialty names displayed Like "adjuster".) and a command button ...

Hi all.  I am working in A2k and having trouble with hourglass.
I have a form which takes several seconds to load, so I want the mouse
pointer to turn to an hourlgass when the menu item is clicked to open the
form, and then back to regular pointer when the form activates.

on my unbound mainform i would like to have a box that controls the query
that the subform is based on. is there a way through code to tell fields in
the subform to be filtered on what is typed in text boxes on the mainform?
do i need to place any special stuff in the query? i ...

I have a database which up to now hasn’t had a save button on the various
forms. I’m thinking I may need to add one so I handle various errors that are
happening.
First of all, what are people’s thoughts…..why have a save button? I’ve

After opening and clicking on the popup calendar command control
button, "fdlgCal"; I click on a given date.  The date is suppose to
then appear in a date field next to the control.  Instead, I get the
following error:

I have this two part statement that gets the highest record then adds to
it.  The problem is if a number is just a number and no letter exsists
it doesn't add a letter...such as 2 ends up as 2, not 2A....
but it does work if I have 2A, it does make it 2B.  Also do these have

I have a table containing insurance types and the rate for each type.
On a form I have a combo to select one of the insurance types, then the next
field is for the relevant rate.
I would like the rate field to be populated automatically once the type has

I need to apply 2 filters (or have 1 filter with 2 criterea).  I tried:
DoCmd.ApplyFilter "", "[TagToDo]![GenerOpen]=True And
[TagToDo]![GenerClosed]=False"
and several variations but no joy.

I'm using sql 2000 and Access 2003. I have a form that's record source is a
query. I have a drop down field AssignedTo. After you select a name I use a
Select Case Yes/No that asks if you want to assign another record. Selecting
No closes the form.

I have a text box that contains a report. Data is then entered from
this report to other parts of the form by the user. However, when the
user clicks to enter the data in other parts of the form the text box
resets back to the top of the report. I was wondering if anyone had