Hey all,
I created a Query which asks the user for an "As Of Date" which would
then display relevant data. Is there anyway to put in a default of
today's date in the input box and allow the user to change it to

I still have plenty of databases written in Access 2000 although I
would like to write future databases in Access 2003.
Assuming I have both versions on the same machine, is it possible to
have the correct version of Access start according to whether the .mdb

I have a table the contains field called PersonID.  Each record in the
personID field begins with the letter "p" in uppercase or lowercase.  I
want to run a query that finds all of the lowercase "p"s and converts
them to uppercase.  I cannot figure out how to do this easily as there

Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I

I have a filed name called OwnerName where I typed in the persons first
name then surname. I now have a need to display the surmane first then
surname. Is there a way of reversing the order that the OwnerName is
displayed.

I have an Access 2000 database that links several tables from Oracle 9.
For some reason or another, one of our user repeatedly gets the
following error when accessing queries within this database:
************************************************************************************

I have a table of UK companies whose records I want to filter using a
map of postcode regions.
For the benfit of people outside the UK, our postcodes are a pain to
work with because they are not a standard length, and the part which

In AccessXP I create an Access table then create an update query which
updates a field in that table with data from an SQLServer table and
when I run it I get the message
'operation must use an updateable query'

I have converted an Access 97 database to Access 2003
The following code now fails and returns Run-time error '3420'
Dim rst as DAO.recordset
Set rst = Forms!frm1!frm2.Form.RecordsetClone

Table  Structure.
tblData
----------
fldID (AutoNumber) (PK)

I'm putting together a PC Workstation Assessment application, the idea being
dead simple - there are a number of predetermined questions for the user to
answer either "yes" or "no" to.  My first stab, also dead simple, is just a
flat table with the user's details and a Y/N field ...

Just died a little db of our time sheets and think that I might have a
problem.
I just put a pulldown of the employees and a week that they are
entering time. Then in a continuous list in a sub form they have

I have some data that I export from Access to a pipe-delimited text
file.  Unfortunately, the text file always has a carriage return symbol
at the end.  I need to export this file frequently and send to a system
that cannot accept this character at the end of the file.  I am looking

Is it possible to change the linespacing of a text box using vba? If so how
do I do this, which event do I use.
I have tried
me!mytext.linespacing = cLineSpacing

Hi. I keep getting hundreds of spam emails with the following
header-type. I would really like to create an email filter which
will delete them from my junk folder. I normally like to check my
junk folder for false positives before deleting them, but this