Can I make a special form for running querys? Eg. if I want to find
customers account codes beginning with say, ACC******, can I input that in a
form and have it run a query. I have people who wish to find a large range
of different information from a database and I want to ...

This is my first, and very new. I was wondering if anyone could help me. I
have a table with contacts for a sporting body, and I want to make a table
with points that have been earned for a particular event, and not sure the
best way to set this up, so that ultimately I will be able ...

I have a report (Invoice) which has two subreports in the detail section.
I calculate the total value of records in both subreports in the footer of
the main report to give an Invoice Total.
All works perfectly.......  Until

I have a piece if code giving an error message:
"Compile error. Expected end of statement"
I would like to debug the problem myself, ( I will return here if I
fail <G>). Where do I find a definition so that I can work out what is

I have a series of queries that run from a command button
using DoCmd.OpenQuery. These queries are used in a report.
Is there any way to keep the select queries from displaying
and just display the report?

I have a field in a table which has been imported from an old spreadsheet
which contains client names in the format of <firstname> <surname>.
In my database I want to split the names into seperate fields.
Can someone please give me a pointer on getting just the first name and just

Hi all;
I'm writing a code for a macro in ms excel 2000 and I'm having some
troubles with MsgBox. Here is an example of the code:
Public Function RCL(PLI As Single, RMA As Single)

I'd like to sort reports by lastname, with the exception being "if lastname =
Open" (open position), sort at the end of the group.  How do I denote that
and there does that go?  
Thanks for any info or other suggestions as to how to get open positions

In the form I'm building, I have a drop down list control that gives
categories of behavior infractions.  In the next control, I would like a list
box that showed specific behaviors that would fall under the category that
was chosen.  So each of the different category options ...

1)If I change a name for a table, will I break all queries that run against
this table?
2)If I cange a query name, will I screw up other queries that use the query
whose name I am changing?

At random times and in random documents, the font size changes when I paste.  
My normal.doc is set at size ten Times new Roman.  Occasionally I write notes
to myself concerning specific bits of paragraphs I've written and set those
notes in size two font.  Sometimes when I copy ...

Please bear with me for the basic questions.  See explanation below for
reasons I'm posting anyway.*
I'm tracking our products for kosher status & proprietary status, using
Access 2003.

I have a local table (Temp) that is made of 24 columns of diferents data
types, and it will contain one single record.
Using VBA, I would like to update a record on a MYSQL server. The link is
the jobnumber

I have corrupted a database, possibly by deleting a form when I shouldn't
have.  I had a somewhat similar problem when I deleted a table before first
deleting its relationship to another table.  But I don't know how to get out
of this one.  

A couple of responses suggest setting the default value of a date time field
to
Now().  This process, however, sets the date/time of when the previous user
exited his/her entry but it may be hours before the next user makes an entry,