I am using windows xp pro and office xp pro
I have a table called hiring in my database that consists
of the following fields: Name ( a text field), Hire Date (
a date time field), Union ( a text field indicating

I have two tables.
One is a list of doctors:
Table 1:  Dr name | Town | Speciality
The other one is zip codes that each doctor covers.

  I'm really having problems installing Access 97 on a new XP Pro system
with 1GB of memory.
  A97 would fail to open with "Out of Memory" message.  MS says "Out of
Memory" due to an A97 bug when system has 1GB of memory.

On an input form the user can query an item between 2 dates that they infill
in two unbound text boxes.
At the moment in the date field of the query criteria field I use
Between [forms].[main menu].[text18] And [forms].[main menu].[text20]

I have a main form with 2 subforms.  When the main form
is first entered I have AllowEdits as False and this is
placed in On Current and AfterUpdate.  I have an Edit
Command Button to switch AllowEdits to True when the user

I have a form that asks for user input.  Is there any way that the user can fill out the form with, say, a number (studentID number?) and the name associated with that number becomes visible?  
Thanks,
el.

  Running Access97 and Access2K on an new XP Pro machine.
  I downloaded and ran Jet35sp3.exe so that A97 would run properly on XP
with 1G of memory.
  It appeared as though my large A97 application ran OK, but today I ran

I'm using Access 2002 and I have a small problem.  I can't assign a
Primary Key with an index of YES (Duplicates allowed)  I even tried the
Nortwinds database,  If I dont touch it, it works fine but if I try to
change the settings I can't go back to having A Primary Key with Yes

I'd appreciate any help/hint on hot wo put my pictures to Access? Can a cell take it?

Help! My brain has died and I'm sure I've just stared at
this too long.  I have three fields (Date on Hold),
(Release Date), and (Days in Hold).  I'm trying to
calculate the days in hold field.

I tried this and it didn't work.  It showed a dialog box
asking for a date.
I've tried writing this in vba..can someone debug it for
me please.

Couple questions:
How many users can simultaneously utilize Access 2003?
Where can I find more specific information on Access other
than the Microsoft site?

I have noticed that when I set the data type to Number,
the data is automatically rounding to the nearest whole
number. My data consists of numbers like  1.2, 1.5, 1.8,
2.2.... etc... This is rounding to just show 1,1,2,2....

I have a table with 3 columns - a1, a2, a3 and and a3 is
blank and there are 10,000 records in the table. I want
to use IF-THEN -ELSE in Criteria to update 3 records(only
update 3 records)in column a3 and rest a3 keep blank. I

i have a form with a combo box the control subfrom, i
would like to add in the some form a subfrom an withe a
swich i can deside wich subfrom i would like to
control