Hello, I have 2 tables Organization & Quantity (Org & Qty):
Org
OrgId (PK)
Orgname

Hi. This is really frustrating. I'm using Access 2002 on XP.
I have a small subform, containing an Image control and a "Show Photo"
command button. This shows an Image that is linked to the main record being
viewed and works fine. As I dont want to have any fields showing in the

I have a main form with a subforms. The subform is in a datasheet view. I
need to find a way when I moving my cursors on the record in the subform the
mainform show the data of the subform for the particular record ( in the form
view) .

Hello,
I have a case statement which is bombing at runtime.  The statement is as
follows:
Case 2  'goto Routing details tab

If Have a text box with  names and addresses, I would like to remove the
Wifes surname where the Husbands Surname = Wifes Surname
[HusbandFirstName] &" and " & [WifeFirstName]
[HusbandsSurname] & Trim((" "+[WifesSurname]) IIF [HusbandsSurname]=

I have a check box field in my Main form called "PO_flag."  On my subform, I
have a field called "PO_no".  If the PO_flag field is "checked" (="Y"), the
PO_no field on the subform must be required (filled in).  If not, the message
will be MsgBox "You must enter a PO#."  I put the ...

I open a form by click on a button from the main form.  My probels are
1)  how do we makesure that the form is aways open in data sheet view.  I
have set the current default view to datasheet.  However everytime you open
the form in always open in the single form view.

I'm trying to select some data from a subform and display it in a text
box on my main form.
The fields in my subform are:
employee

I has a field that has been set by addition from a number of fields.  The
data has been set to general number with two decimals.  My problem is that
the number is shown with two decimals but the number has been round i.e.
24.35 became 24.00

Hi,
Any Help most Gratefully Appreciated.
I have looked up the forms but nothing seems to really answer my question
just right and its very simple.

I have a text box. When my form opens, in the Form_Activate I init all my
text boxes to blank, like this:
text1.text=""
But each time I do I get an error "Cannot access this property if control

How do I get a report label control to display an ampersand as part of its
Caption?
Thanks

I have 4/5 thousand adobe files in a directory, after selecting the one I
want from a combo box I want to click a command button that says "View
Document".  Each document has its own number, 0001, 0002, 3435...  What I
don't know how to do is write the code to open adobe and ...

I have this on the OnOpen Event of a form but it doesn't seem to be
working.  Any suggestions?
If Forms!Sales!Text140 = 1 Then
Me.Text87.Visible = True

 I have one user that keeps getting the error unexpected
error (40230) when they run reports, email or send
attachments. No one else gets it. I have recompiles, etc.
and they still get it. They have the latest Jet 4 sp