Using A2003.  I have a one-to-many relationship between a doctor table
and a table of their specialties.  A doctor can have many specialties.
How do I pull doctors whose one and only specialty is "Internal
Medicine"?  

After a recent edit, one of my forms that has been in use for years, has
suddenly started to be shifted to the left, so that it is no longer
in full view in the window. It's moved by about 10mm or so. If I go into
design view, then back into form view it appears correctly.

As a Newbie I've picked up a heap of tips and tricks from this NG but I
have been battling to get the current user's Netwok Login ID recorded
on a form  at the time a new record is created or modified. I haven't
implemented Access security, and want their Network Login ID. The

HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do

I have an MS Access Database with multiple forms that all update fields
in a single table because I can't fit all the required fields onto a
single screen. I have looked into converting these multiple forms into
a single form with subforms as tabs  but to date my attempts to do this

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??
e.g.

wie kann ich die Anzahl angezeigter Sätze in einem Endlosformular
beeinflussen?
Ich rufe das Formular als POPUP auf und es werden mir immer genau 3
Sätze angezeigt.

i've looked in a lot of places but can't seem to find the answer, so I
hope you can help me.
I've made programmatically a table in an access database with keys.
The foreign keys I can find (in the MSysObjects) but where can I find

Gang,
I have a 3 numeric fields holding values for month, day, and year.  Is
there a way to create a new variable called NEWDATE that is a true date
value - in other words one that would be recognized by other software

I'm attempting to append multiple values into a new record, using
multiple criteria from a listbox.  I've got the basics for the code
below but I get an "Error 3085 Undefined Function" for the Dlookup part
of it.

I've posted this problem some weeks ago, but noone had a solution.
Perhaps now someone could help me.
I have the following tables:
Create Table T1

kann man links neben den Daten einen freien Textoder Grafik platzieren?
Unser Briefpapier hat am linken Rand Text.
Ich finde keine Möglichkeit, den Text unabhängig von den Daten zu
platzieren.

How would one create a button that on click advances the form to the
next "non recurring record" as opposed to the next record.
The field the button needs to que from has groups of duplicate values.
I need it to advance the form to the next group of duplicate values not

Coming from a vb6 background I am accustomed to prefixing variable names to
indicate their usage.
Now just beginning to try to learn database stuff I've been lurking here and
working on my first database design.

I'm having a problem using a TextSteam object to write to file:
The following produces an error when the Access field I am writing from
contains a return character:
a.Write strText