Is there a way to make access ignore punctuation at the beginning of
an item, such as "Field and Stream" so that it will arrange all
information alphabetically instead of arranging items in quotes
alphabetically, and then arranging items not in quotes

In AccessXP I have a report which I have a group header/footer called
HUB. On change in HUB I want to do a page break, I've found that if I
put the page break in the HUB header section the first page of the
report when printed is blank and if I put the page break in the HUB

I have a database that had been stable until 3 weeks ago. The Access
2003 database occasionally (a couple of times a week) gets corrupted
when the last user exits the application. At least, that's what I'm
assuming since they get no error while working.

How can I create reports on Crystal Reports?
I have a database already created on ms access 2003. Then, I want to
create its report on Crystal Reports. Is it possible to do?

I have an accommodation db in which I would like to link with Outlook
if the booking was received from an email. I currently record the fact
that the booking was received by an email but I would like to be able
to click a button which would take me directly to the booking email.

Access 2003
I've been experiencing some problems with my "monster" database the
last couple of days.  I imported all objects into a new database
yesterday, which pretty much stopped the crashing problems, but here's

How controllable from Access VBA is Excel?  I'm currently using automation
to dump 2 columns of data into an Excel spreadsheet so that the end user can
create a line graph based on it.  Could the line graph be created from
Access as part of the automation process?  Is it also ...

I have a Title field i.e. Mr, Mrs Ms Master etc.... then I have a
gender field.  I have been trying to do a query to enter the Gender
into the gender field based on the Title field.
i.e. Mr = Male, Ms = Female

I am appending some new fields to a table in vba and when I append a number
field with is a byte, it does not inherit any format.  I want it to be the
General Number format, but it is blank.  I have tried to change the format
with the following code, but it does not work.  What ...

Im trying to do a DLookup on the following.
I have a form field called StartDate and i want to find a price from
table where Forms!Formname!StartDate BETWEEN Start2 and End2. I just
cant get the syntax correct at all, theres too many "" all over the

Is there anyone here who does database design?
I have one nearly done but need to finish it and just don't have time to
learn queries to set up the report page.

The problem is with the Internet speed in our house. we have a 10 Mbps
connection which is used by around 10 people. When anyone used to
download stuff using torrents the internet speed used to crash for
everyone so we decided to give static IP to everyone's computer. It

We have a new project here, one that I have never tried maybe its easy
I don't know yet.
We have people that have records dating back over 5 yrs on a sql
server.

I'm using this code to pass "codice cliente" values from a form1 to
form2.
Private Sub Form_Open(Cancel As Integer)
Me.RecordsetClone.FindFirst "[Codice cliente]=" & Forms!

I want to specifying a foreign key by altering a table.
First, I create an ORDERS table without specifying a foreign key. Here
is my code:
CREATE TABLE ORDERS