Greeting all.  I searched past questions before posting again, but what I
found that might help me was over my head.  I have separated my one large
table into many small tables, all pertaining to telecom fiber jobs.  I have
made a form on which there are fields from multiple ...

I want to display all the values in a table, where a fields values do not
match the values from a different table.
If  I were to want the matches, I would simply join Table1.Field1 to
Table2.Field1.  Howerver, I want something like Select * from Table1, Table2

If I make changes on sharepoint for my team how are they notified?  Do I need
to send them an e-mail if I have a task, change the team calendar or want to
do a survey and how am I notified if they make changes?

Is it possible to do a SumProduct like function in Access?

The results from one field in my query is in this format: 2316.52
I need that to look like this: 0000231652  Which is 10 characters long, zero
filled, and without the decimal.
Can anyone help?

I put in the table under:  Display Control      -  List Box
                                   Row Source Type  -  Value List
                                   Row Source          - " X....;"Y.....;";
"Z....."

Hello all.  On my form based on a querry the add record button at the bottom
is greyed out.  How do I make it so that I can add a record on the form and
for it to add to all of the tables on which the form is based?
Thank you

I'm new to Access, but Page Setup doesn't seem to enable me to reduce line
spacing when printing reports.

I put a pictute on as my screen saver and would like to make a copy of it. It
is the only copy of the picture.

hi
i have my Patients form in which i enter Patients details including expenses
.so i want a to have a button to protect a record from editing or
deletion.and at the same time have the option to unprotect it or even delete

I have recently installed Access 2003 after a crash. Every time I try to open
an Access 2000 file from before the crash, I get a message "unrecognized
database format".  I do not have any other versions of Access available.  How
can I use my files in Access and for Mail Merge?

Using Access 2003
I have been asked to create a database in Access that contains data
imported from several old Lotus Approach tables then add forms and
reports as necessary. The thing is they want the database to be stored

I have a networked database that I have split into a front-end and back end.
The front-end being the queries, forms, reports, code, etc. in a mde file
and the back-end being just the tables with data in a mdb file.
My question is regarding relationships.

how do you number in fraction for office access 2003

Hi there, I have just split my database so that the tables are located on the
network drive, and the rest runs locally.  However I am finding that the
forms take a while to load, since doing the split, and this is when the
database only has test data in it.  Is there anything I ...