in this morass of code below, the Case 2 scenario fails to find a test
record in the underlying table where the values of "Patient Number" is
1097977 and (importantly) the value of "SelectCycle" is 999??!!
i don't get that. anyone have a clue?

I'm using FollowHyperlink to open another MDE from my application. When the
second MDE opens, its startup form is not centered -- it is positioned in
the upper left area of the Access window. All subsequent forms position
correctly. If I run the MDE directly, the startup form is ...

I have a query, Invoices.  I created a form and a report off of it.
It's only giving me the first invoice, not all of them, and I don't
understand why.  I used the Nwind db as a guide so I don't see the
problem.  Please help me find the problem!!  There's one one-to-many

Using Access 2003
I have a user manual which is saved in pdf format.
I want the user to be able to click on a customised menu item to open up the
.pdf from within the program.

I was wondering if anyone could tell me or point me to a website where I
could find out how to get the printer settings for an access form.  What
I want to do is select a print report button which would then bring up a
print dialog for changing which printers to print to and ...

How do I hide a subform based on a value on the main form (or other subform
on the same form)?  Thanks.

We're getting a 5852 error mailmerging into a Word 2003
document. The merge is created in Access 2003 using this
code:
Dim appWord as Word.Application

I need to update a record from two different forms.  One is a bound form
which calls an unbound form which can change other fields in the same record
of the calling bound form.  My original solution was to write all the fields
from the unbound form to hidden fields on the bound form ...

What code do I need to use so that when a command button it is clicked, the
contents of a text box are cleared (not deleted completely from the
corresponding table, simply cleared on the form).
Thank you for any assistance.

If the user finds that the data required is not in the combo box, how can I
make a button to open a form, related to the appropriate table, which they
may use to add the new data.or how can I make them able to add new data to
the list of combo box?

Hope someone can assist. I am trying to export a file, have all the code ok
up to a point but am a bit stuck on one point. I want to name the exported
file depending on the value of two text boxes on the form. The first is a
text box and works ok but the second is a date. the ...

I need to trim two text fields, concatenate them with a slace ("/") in the
middle and then update it back to the table. But I'm getting a Run-time error
'13': Type mismatch,
on the third SQL1 assignment.

I have a users table wich stores user information,
username, pass, privelages etc....
I use this security for all the databases i develop.
This allows for authenticating the user of course.

I have this bit of code to check for empty fields in a record before closing
the form, and prompts users to complete the record to avoid it being
deleted.
It should (during testing) check the [focusobjective] field, and kick in

I found that after porting my app from Acc2000 to Acc2003 format with no
changes (just conversion), the
reports that have unbound expressions like "=[month_value] & " " &
[year_value]" give an error :  #Name, although they work perfect in Acc2000.