Hi,
We will be installing MS ACCESS 2007 in the near future. I have some MS
ACCESS 2000 MDBs.  Should I convert them to MS ACCESS 2003 first or I can
convert them to MS ACCESS 2007 directly?   Is there any known problem between

If someone could help I need to get the HorsesName from qryHorseList, Name
which has HorseID
and this code should only give the Base Result , latest Date
Thanks for any help......Bob

I am trying to represent Monthly and Overall Labor totals on a Chart.  My
query calculates the monthly totals just fine.  How do I calculate a running
total?  Ideally I would like to show a Bar and Line Chart.  The Bar
illustrates Monthly Totals, the Line illustrates Running ...

I have a field called [add1] and a field called [postcode].
sample of the data in [Add1]
Crown Cottage C***n St R*** GT9 4RG
17 Rd Col****rth G****** GT3 5EW

I'm a novice with Access, but am currently setting up a patient
database for an NGO in India that I'm volunteering with. The primary
reason for the database is to collect statistics quarterly. It is a
simple database with one table that collects patient data from simple

I have the following expression:
=DSum("Amount", "YourTable", "TransactionType = ""Credit""") -
DSum("Amount", "YourTable", "TransactionType = ""Debit""")
However if there is NO Debit transaction the expression does not work.

How do you change the FONT COLOR?

I read a warning that a Dim statement such as:
Dim mySQL, RecSource, fldNames As String
is incorrect and should instead be written:
Dim mySQL as String, RecSource as String, fldNames as String

I hope this is the correct Access group.
I have an Access 2003 database that I tried to convert to Access 2007
format.
I've already successfully converted a similar database, but with this

I have a DB for customers address, i like to create a yes/no field neme "out
of the state" ,  that will automaticly check "yes" when customer is from out
side of the Missouri state, if customer is from Missouri, it will uncheck,
could you please help me this...

does microsoft have a simple guide or white paper for using access 2007, like
where to find the commands
dennist

I have two fields: Category and NumberOfContracts. Category takes 3 values,
call them A, B, and C. For each record there are a number of Contracts
associated with the choice of Category. So my records look like:
Category    NumberOfContracts

I've got some simple code for a form...
Option Compare Database
Public Function TestCode()
MsgBox "Function Worked"

I have a databse that runs queries against an ODBC source throughout
the day and night.  I am having an issue where a query will run at
night and throw an error message about not being able to append due to
record lock.  What could be causing this?  Is there a way to ignore

Is it possible in acces to create an executable file (.exe) so I can run my
database program into a computer that does not have Acces???
Also, I'ld like to create a stock and billing account program for a small
enterprise, any recomendations or examples