I have a report which I like to print which will show my y/n boxes with a
nice little checkmark in it on screen. But when I print it, the whole column
is blank, except for the title. Everything else visible on screen prints
fine. If I convert it to a Word doc or Adobe PDF it will ...

I have a field that shows only the month. I want to format it as a date so I
can sort it by month, but the formating options for date all include the day
and the year. Is it possible to make this a date/time field but have it
formatted to only show the month. If not how can I ...

I want to have a database to record all of my departments spending.  I
started to design my database but I keep coming up with problems so wondered
if anyone could help.
The tables I have created already are:

I have a database that pulls pricing data over from an AS400 for quotes. I
want to be able to lock that data once the quote is accepted as the link to
the pricing file is live so if a price change occurs, it will change the
quotes themselves which I don't want.

I  got an error on this line:
Dim objWord As Word.Application
Compile Error: User-type not defined.
Can anyone shed any light on this?

I have 3 tables: A, B and C.  
tblA contains a PK field "Name" which is joined to tblB and tblC as shown
below... which works fine...
tblA                tblB

I'm trying to update this movie database. The original was mostly a flat db,
so I'm trying to do things the right way this time.
Amongst other things, the db tracks if a movie is based on a book, and if
so, what the title of the book is.

Does anyone know how to automate the backup process? Thanks.

I was given a table that I am redesigning.  The orig table had a City text
field and I added a popup City2 field that goes against a new Cities table.  
There are 10,000 records and I want to populate my new City2 field with the
contents of the orig City text field.  How to do it?

I saw in some previous posts that a Memo field can be a cause of corruption
because it is not actually stored in that given table, and that some people
avoid Memo fields if possible.  I have experienced this corruption on a
couple of occasions, so I'd like to pose this question.

Client has requested that if one user has started editing a record, then the
record should become read only for all other users.
Is this what is known as pessimistic locking?
Where do I set the locking option? On all the Front Ends, or is it enough to

I had put a field name (FUPDate) in Table 1 but decided that this field need
to be put in Table 2; so I deleted from T1 and put in T2.  I never referenced
this field anyway but everytime I open T1 to make a design change and click
on Save I get an error msg "Could not find field ...

Can anyone tell me what is wrong with this code. It falls with a "the open
form command was canceled" error:
Private Sub cmd_addDay_Click()
On Error GoTo Err_cmd_addDay_Click

I have a database that I just can't visualize the relationships in.  
The data going in is made up of
Company
Contract

does anyone have an employee database???   to keep track of training name ,
addrss, phone hire,  terminated, training, emergency info... ect