hi guys, How I can assign function keys .  Like I want F6 to give me the
today's date in a field.

been reading ms access 2003 inside out, and from it, i've learned how to use
a combo box to filter another combo box
my question is, what if i want to use this filtered combo box to filter a
list box? - and if that is impossible, is there another way to set this

I need to rejoin a split database. I've removed all the linked tables (4) and
I've imported 3 of the 4 tables from the back end database.  Unable to import
the 4th.  The message is "The Microsoft Jet dabase engine stopped the process
because you and another user are attempting to ...

How can I change the font color based on the value?
for example, say I have a field "age". Whenever the value is more than
50 I want that the data (age) will be in red fonts . Otherwise - black
fonts.

I have created a two table, one to many relationship, database. The main
table is the ssn and persons personal informaton, phone address, city etc. I
have created this db to copy information from a job application. The purpose
is to track the progress of the applicant through the ...

Tried this question first in the Query discussion group, didn't receive a
response, and since I'm a newby perhaps this is the more appropriate forum
for my problem.
I currently have two queries which both return the desired values; however,

I have put this question into the new users as it is probably a very simple
one for the experts out there and I am a new user :).
I am in the process of trying to create a suppliers/products database and to
create a purchase order from that.  I have checked out Northwind and the

I am trying to create tables and forms for my database and have set the input
mask format to short date.  Although I have clicked to save, when I open the
form the input mask does not appear.  Why is this not being saved?  Grateful
for any advice.

Gday All,
Not sure of the right way to go about this.  I have created two tables one
for customers that are companies and one that is for customers that are ppl.
Then I have joined both these tables to a table called tblcustomers.

Why I do for download all photos from Microsoft Gallery? It"s possible ?

Hi All. On the close event of many of my forms i have a case statement to
select which form to return to.
I will be using the same code   on several different forms and am sure that
this code can be stored in a module but I don't know how to save/call the

I would like to know if anyone can tell me how to generate subtotals in a
report and a final grand total.
I am trying to subtotal by year and at the end of the report have a grand
total for the year.

Originally, databases were sets of "flat files."  Like Excel Lists, they were
sets of records with common fields for each row in the dataset.  The
development of relational databases was a major breakthrough.  So what makes
relationships so important?  What are some of the values ...

I have another question.  
I have a report in which i calculate a running sum.  I want to be able to
copy that into a Table.  The Report will only result in one line always.  I
have a "Temp" Global Variable setup which saves it.

You can reduce number by by a thousand by using 0, in formatting a number in
excel. How can you do the same in access?