Hi, I am using a wet and cold holiday weekend to learn about Access. I want
to create a simple sales order entry function.
I have set up 2 tables Orders and Order Details. The Orders table holds
order number, customer, due date, etc and the Order Details table is to hold

I have 2 fields... FirstName and LastName.  I'm trying to get both into one
field.
Thanks

I want my database to display only the form window when users open it,
without showing the user the Microsoft Access window in the background or the
database window?

I'm using this SQL phrase that is working on Several forms, but n one
form I keep getting he dreaded 3134 Error.  Any help appreciated.
Thanks
DS

I have a form where I would like to password protect a field, this needs to
be done to prevent other users from entering a Supervisors name?  

i build a form based on a query.
this query is returning the new values after doing requery
the problem is when you do requery the screen returns to the first
record.

My form has 12 textboxes to fill in different dates like
date of arrival
date start loading
date completion

For some reason, our database crashed yesterday.  In one of the records, each
field had an "error" in it.  I opened the table, deleted that record, closed
the table and clicked on "Compact and Repair"  At that point all of my
relationships disappeared.

I want to change the size of a list box vertically (and perhaps horizontally)
when the form resizes. Can someone please point me to some code.
PS I would like to not reinvent the wheel as I know there are some tricky
issues due to form's min/max size etc.

In Form_current event I did the following procedure
If Me.StatusXK < 80 Then Me.AllowEdits = False Else Me.AllowEdits = True
It works, but I have a problem. In this form, I have a combo box to filter
records. When the Me.AllowEdits = False I can't filter, I mean, I can't use

I created a database we've been working on for years.  When we open the form,
the cursor rests on the first field which is called "clientname"  We would
then click on the find button and the default setting would be:
clientname

I have the following SQL statement.  The problem is that whatever I
enter into the TxtName field (Unbound) on Form5 a box pops up asking for
the parameter...at the top of the box is whatever I typed into TxtName.
 Is this a Syntax problem?

I have an access 2002 database
I have an entry form in it
I have a command button that opens a report on it and reflects filtered
results.

I would like to put an image on a form that is over the text boxes and other
things.  But I still want to be able to see the form behind this image.
Does anyone know a way to do this?  I've tried to make an image transparent
but I don't believe Access forms support transparency ...

First of all thanks for all info so far.  I'm still trying to display one
form or another based on an If stmt in a ""close cmd button" from one form
that has finished data input. I have the following expression on the "close
form" button.