I would like to know when I open a record through my form if the record is
currently being edited by someone else in my workgroup.  I don't need to
really know who would have the record open, just if it is open for edit.  My
application settings are record locking.  Is there such ...

Following is the skeleton of a simple query I wrote,to find the sum of
values by grouping multiple columns ( from different tables
joins).Now,even if the SUM(C.column3) is NULL( verified this by
running a separate value specific query), it shows up with values from

I have a text field that I want to be hidden on my form until a
certain option is chosen on a drop down menu.
For example, if the drop down menu = Other I want the text field with
Other (Please State) to appear with it being invisible until then.

If I am adding a record to a table "Contacts" and a table "Addresses" from a
form where "[Contact To Address]" is the lookup form and after adding a
record to each of the two tables then adding a record with each of the ID's
to the [Contact To Address] table, is there any other ...

I am trying to create an order number using UserID + counter due to
the fact tha my database will be distributed to about 20 end user to
be used to place orders at the convention.  I so allot on the toping
and copied allot of code back an forth with no luck untill I stumbled

I am using a tab-control continuous subform to enter multiple part numbers
and quantity for a manufacturing process.
Each quantity entered must be increased per a "Add-On %" field, which is a
combo box in the subform listing multiple %'s.

I have already created a working search form using three text boxes.
i would like to add a combo box to the search form.
I currently have the code
Dim strWhere As String

I can not figure out what I am doing wrong here.
I have a query that my table Transplant is used. I have the filed " Week of"
in the second row of the QBE pane and in criteria I have
[Forms]![Trans2]![Combo11] and the show box is unchecked. Now when I open the

I am trying to make a DLookup look at two coulmns in a table, find the
matching entry for both columns and display the third coulmn in that row.
(Example: field 1 is car or truck field 2 is chevy or ford field three would
be corvette or taurus)

I have a custom entry form that keeps producing a error saying that the index
can not be null. The index is assigned to an autonumber field and during
processing of the form the autonumber field doesn't have a value until the
record gets saved. Is there a way to have the ...

I  would like to create an email message from Access based on a query. Query
provides the email address. I would like the email address to be added to the
'to' line in the Outlook email message. Any help is appreciated!

Can anybody help with this dire problem i have?
I have recently re-installed MS Access and now get the following errors when
I open my Main Form.
I haven’t changed any references to image paths or other associated files.

I'm trying to get the Min value of [SalRate] if the [Setting] = "VT" most of
the record gives the Min value except few. "SalRate" is defined as double and
I'm using Access 2003.  Below code is used in form text box, data control
source.  Thanks!

I have a form, a tab control, a sub form and a list box. I am trying to
requery the listbox by using the following:
Forms!frmCalendar.TabCtl0.Form!frmCalendarCreate.lsttmpCalendar.Requery
It keeps on coming up with an error that says it does not support this

I have form that allows users to select a date range and store number from
combo boxes.  After accepting this critera a subform displays the sales
grouped by salesperson.  I would like to have the capability to select a
record off the subform and pass values to my code to enable ...