I do not know even how to approach this one, so help will be GREATLY
appreciated.
The line I currently use is:
DoCmd. RunSQL"update CAEmployees set[Name]=[NickName]&' '&[LastName]"

I inherited a database from a former employee and am trying to locate
any query that contains a particular field name. Is there a way within
access or 3rd party software to show all the queries that contain a specific
field name.

Context:
Access 2003, MDB file
Setup:
I have a query defined (schematically) as "SubqueryA LEFT JOIN SubqueryB".

Folks I apologies if this has been asked recently...and for being an access
airhead..i can't to the programming stuff
I'm looking for a way to get a calendar to drop down from a parameter
dialogue box so i can enter the dtart and end dates for a parameter date

I want to export to dBase IV using query. In my query, one of the field is:
Name:[Last] & " " & [First] & " " & [M]
After exported, I opened dBase, this field is 254 long. I tried:
Name:Left([Last] & " " & [First] & " " & [M],20)

First off, thank you so much for your help.  It is truly appreciated.
I am trying to write an expression in a query that counts how many times a
particular string of data repeats in a text field.
ie:  THE BUS IS A VERY BUSY BUSINESS.

I have plant-fertilizer-season Table, where applied fertilizers to
plant is different for seasons, fert1 is main fertilizer used, fert2,
fert3, fert4 would be for the secondary, auxiliary used, below is a few
records for reference:

..breaks the links between tables. Is there any way to open the query in
design view and preserve the links for diagnostic purposes?

Having a lot of trouble with this...
What I want to do is to concatenate the results of a query into a
string to display on an Access report.  I thought - easy enough, I'll
write a quick function that opens the query in a Recordset object,

I have a table that with the SSN as the first field.  It is formatted
so it is always 9 digits, no hyphens.  It is formated as text with an
input mask of 000000000;;#.  Everything looks good until I export the
table to a text file.  It drops all the leading zeros.  The client this

I have not run into this problem before and need some assistance.  I created
a simple database on a shared network drive.  Those I am working with can
open the database, but when the select the queries or reports to view/run -
it gives them an error message.   The error message ...

I am running a query that concatenates two text fields into one, the
statement in the Field box in the query design grid looks like this:
Site: [Table]![Station ID] & " - " & [Table]![Station Name]
As stated, both [Station ID] and [Station Name] are text fields. The query

Is there not a simple way to do this?  The help page for the time date
functions say that they are to be used in calculated controls in
forms.  If I set a control in a form to something like =date(), how do
I then get it stored to the table that the form is based on?  I'm sure

Version 2002.  How can I have the date field automatically adopt the
date of the creation of the record?  I've checked the help file but
I'm either asking the wrong question or not understanding the answer.
TIA.

I have a form tied to the query below. If the query doesn't find the
workorder number entered the form still opens and people try to use it.
I need to make it so an error message pops up if the workorder isn't
valid. What are my options?