Using Access 2003.  My IS department completed Office updates with sp3.  In
my database, I have a combo box with 4 columns to look up names.  When the
user clicks on the name when found it will go to that record.  The first 3
fields show when this is used.  The 4th column is the ...

Hiya folks!
I was what the best way would be to do the following - I would
appreciate your input:
Imagine you have a restaurant, and you only sell the following two

I'm very new to Access and am having difficulty getting a calculation to
work.  I have code in the AdultFare(After_Update) field as follows:
Private Sub AdultFare_AfterUpdate()
If [Period] < 5 Then [AdContractPrice] = [AdultFare] * 31.5

I have a form that is used to search members belonging to the same household
and then display their details on a sub form instead of searching directly
from the table. I am using a text box to input the household ID and a Search
commandbox. Can someone please help me write code ...

I have a yes/no field in my database. I am trying to merge this field
into a word document. The results are coming up TRUE and FALSE. How
can I change the value to say YES or NO in my mailmerge word document?
In the database the data type is yes/no.

Imagine this:
You have one table that shows the cost of each ingredient in a
restaurant:
Example:

Hi... I am trying to create a form to calculate the price of our product
based on two different criteria...
The prices are fixed I just need the price control to return the value from
the prices table based upon two criteria...

Using wizard to add Command button to open another form , selecting "Open the
form and find specific data to display".  I'm adding button to frmClients and
want to open frmContracts but wizard is only showing frmContracts. ie unable
to link like fields.

Българският език да не е задължителен, предлага закон,подписвайте иначе ще
говорим след някоя година на турски !!!
http://www.bgpetition.com/knijoven-balgarski/index.html
stenograma ot parlamenta 4e sa go prieli

test from sohail

I have a table for salary of employees and it has 4 fields:
EmpID, Name, Salary and Major.
My question is how to show the 2nd max salary in this table by using query?

Is there an access viewer which I can use on our windows server to view data
in tables? I really don't want to access ms office on windows server if I
can avoid that.
Thanks

I apologise in advance if this is an aggravating question.
I want to have 2 tables. Both have exactly the same fields/column
definitions. One is a "master" table containing existing data. The "other"
table is empty except for a few cells of updated data and the Primary Key

I have a database that I've put together that consists of three letters that
need to be generated for the user.  Each letter has its own query that I have
already built which determines which records belong in which category.  Again
there are only 3 letters/categories in which ...

 I'm using my database normally on my comany computer,when i transferred it
to mine,I've noticed that some combo boxes don't show the content of their
list,however when i select any value,i can see what i selected....
I tried to change the font color,but no use...