Can someone tell me what i need to do to allow my data generated by a query
to be edited in a form.  Right now I have my data looking the way it is
suppose to look but I am unable to edit it in a form view.  
Any leads would be appreciated.

I have a query that I'm using to identify audit questions as determined by a
combo I want this query to return audit questions based on a value in a combo
box on a form.  I also want to add a field to the query that will populate
with PrimaryID field on that same form.

For some reason I have the hardest time with DLookup syntax. Please help!
I'm trying to lookup a contact name in tblMembership where MEMBER_ID (in
tblMembership) = Primary_Contact in tbl Business. Here's my DLookup:
PriContactName: DLookUp('[FIRST_NAME] & " " &

Hi there. Using A02 on XP. Have never had a loving relationship with crosstab
queries. I try, goodness knows, I try.  I know this is so simple most folks
reading this will need to contain themselves but I need some advice.
I have a simple Excel spreadsheet that I'm importing and I ...

I have a query that potentially results in multiple rows of data for the
same critical fields (Order # and Due Date). Whenever the same Order # and
Due Date appear (concatenated if necessary) I would like the rows to come out
as additional columns and thus have one single result ...

I have a query make-table query that works.  However, I need to add one more
if statement and when I do, along with the additional left ), I get a message
"Query too Complex..."
Is there a limit on the number of if statements Access2003 can handle?

I have an access DB that currently handles a company's finance's.  Is there
some way to lock all information relating to a particular year
CM

I have two tables with these pertinent fields:
tblProfiles
txtProfileID (PK)
Description

Access 2003
I'm wondering if there is a way to have Access type queries more TSQL like.
For example, the query below is from Access:
SELECT Product.productID, Product.productName

I want to include code to export a Table file to a comma delimited text file
that uses no text qualifier and includes the first row as the field names.
Ideally, I would like to save a copy of that file locally and e-mail a copy
to someone in another department. Can anyone help me ...

How do I use the Like operator in parametric queries which prompt the user to
enter part of the value for a field?

I have a large collection of mostly classical music CDs and LPs and am
looking for a good but simple data base on which I can list them by composer,
piece, performer etc. I don't fancy using excel, plus as I understand it, a
data base allows one to cross reference and provide ...

A few years back, someone on this list provided me with the following
module, which takes a list of words and reverses them (ie, "word" is
changed to "drow")..  The words exist in a one-field table, each row
of which contain one word.  I used the module in a query and it worked

My query collects accounting data. Each query must be assigned a batch number
which the user manually enters according to stated criteria. I need to add a
field to the query that will identify each record by a line number:
1,2,3,4,5, etc. Can someone help me with either SQL or ...

How do you make a log file in Access vba?  I want to log certain
characteristics when running an Access 2003 query. (Specifically I need to
know if the returned data contains any tab characters and I want that logged
to a file.) The vb logmode and logpath property, or the ...