I have a yes/no field that if marked Yes will mean that the company is still
acitve. How do create an expression to show that if it is Yes then the
"company field" background will change to a color let's say yellow. When a
report is ran then those companies that are active will ...

Hi, my code to execute the query is:
Private Sub cmdMerge_Click()
Dim db As DAO.Database
Set db = CurrentDb

I have a Projects Database with several tables. The main table, TblProjects,
contains all the main details about a project, including the status (open,
on-hold, completed, cancelled, etc).
I have a form that pages through each record where the users can

I have a combo box on my form where the user can lookup new requests from a
table that is linked to another database. Once the request is worked it is
saved into a table within this database; therefore, I don't want
worked/completed requests to show up in the "new request" lookup ...

I have set up a Statement in Access, and i would like to set it to print the
terms on my the back of each statement with my HP Duplex printer.  I have
tried everything i can think of, can anyone help me out with this.
Thanks

I've got a database that pulls the daily bank and store register amounts.  I
query the bank activity without matching register amounts, then have a field
where I revise the amount in the register due to a deposit corretiion notice.
My question is, when i run my matching query - ...

hello i have a query (qryemail) with the fields email and appID
which get everyones email form a tbl i want to send this list to my outlook
and email them
how can i do this i take it it would require a loop statement but would i do

I need to extract data from the left side of a string where the seperator is
a carat ^ . I have looked into the help for the Mid function, but can't seem
to get it work properly. Suggestions please...

I have about 9 networked databases both 1997 and 2003 MS Access databases.  
All of sudden two databases (one is 1997 and the other 2003) could not even
open (it would just freeze up).  The only thing different about these
databases from rest and what they have in common I use an ...

Please I need recommendation as to how to go about getting a certificatioon
for SQL?   I have been working for Access for a while now but in order to
move up I need to be proficient in sql.  Can someone please give me some
advice as to what kind of SQL to learn? Mysql, SQL Server ...

Does anyone have any comments on Peter's Software - Microsoft Access Tools
for Developers
KeyedAccess
http://www.peterssoftware.com

hello, i have combobox in form , the date is from a query . the data form the
combobox go to field in a table .the data display is number instead of text
("id number" instead of the "name")
golani

All -
I've played around a little with the Attachment data type in '07, and my
question is this...Is there a way to take the look and feel of the
Attachments dialog box and incorporate that into a form?  It is actually a

Kindly help....
I have got a table with following fields
Date received = Type (date)
Item-A = Type (type number)

Any one can help me please....
I have got a table with following fields
Date received = Type (date)
Item-A = Type (type number)