Please can someone tell me how to resolve this.
Server running SQL Server 2000
Client running Windows XP
MS Access 2005

I have a query with a field name of "Street", however, I would like
it
to read "CAT:STREET".
This query is exported to a csv file that requires the format of the

I am using Access 2007.  I'm trying to set the [End Time] control on a
subform to the current time.  My code is:
Private Sub Command7_Click()
With Me.[frm_Time_subform]

Hi all, I have a form that shows student information (primary key =
student ID). I have buttons on this form to bring up other forms that
can be used to register student for certain events. The first form is
data from a student table, while the ones for registering the student

We have a Access app that has been split with the backend on SQL 2k.
We setup an ODBC connection on the clients to point to the SQL server
and we are using NT Auth to connect to the SQL Server. Its been
working this way for years.

I use Access 2007 and create queries with a number of calculated
fields/expressions (I'm still a novice so please forgive me if my
wording is imprecise...), like: MyCalculation = Field1 - Field2.
However, I noticed that I cannot query the database setting a

I have created a commission report based on monthly activity.
However, I would like for the report to also show when a surveyor has
laid an egg for the month.  However, when I do the join to the ARBill
table, even tho I join as "all from employee and only those that match

Hoping someone can help me find a solution to the following problem I
have.
I have a query that currently pulls the following information from
Table A

I need your help.   I created a relationship on four tables.   It
works nicely.  Each table has a code type.
Group A Table
--- Field Name:  Code Type    "T"

How do I extract a surname from a name field in which the name is in
the form: <surname, given names>.
My first though was to run an update query, but I can't find the
function that will give me the position of the comma in the field, so

I am having a problem with locating my database window. I click on the
database window in the toolbar but the database window does not pop
up. I checked under tools and startup and the check is next to display
database window. I also have one day's worth of data that has went

I have noticed an odd problem and I'm wondering if anyone can shed
light on it. Perhaps it is a bug, or maybe it is a characteristic of
the QuickSort feature that I wasn't aware of.
I have a query that returns 53 records. However, when I run the

I am working on this query that includes two tables. the first
table(withpay) has detail information and the second table (txdata)
has the summary of data.
withpay (join)                           withpay

Hi,  I can convert my report to Adobe PDF, but the photos are very
poor.  They were taken as RAW images and I've tried saving them at
different resolutions as JPEGs, but it doesn't seem to make much
difference in the PDF output.  I have about 500 images in the 200ish

I recently updated one of my clients from Access 97 front-end to Access
2003.  (Database still in 97 format).
They have about 5 networked PCs.  On one of these PCs only, the user
gets a warning message when logging in: 'you do not have exclusive