I have a table where a field is set to :
Datatype: number
Field Size: Long Integer
Format: Fixed

How can you enter another value that is not a displayed
value in a lookup column?

Is there a way to logoff all users of the database using
a command button?  I am using a non-secured database,
meaning no one logs in.  Users have Access 2002 Runtime
installed to view the forms.  I can create a form and

I have an Access 2003 database containing about 150
tables.  Almost all of the tables use an autonumber field
as a primary key.  How do I merge records from two copies
of the same database from two different users?  The

Before i begin I wish to give thanks in advance for any help that this group will supply me with
I have been racking my mind trying to make a program to manage my expenses
I had originally started with trying to make a ledger program in vb.net now this is not the problem nor my ...

I am brain dead about Access, but have managed to set up a
nice SQL database. anyway, I created a table of inventory
for my company. What I am trying to do is subtract to
columns in a table. I.E.

My last question didn't make it through the translation. MayI try again?
Structure of table below:
CustID     (?? What to set this to ??)
Last4SSAN  T

Can anyone help me understand why access does not like
this statement?
   If [Forms]![Phone Observation Maintenance].[ErrPoint]
= 6 Then

Hi, I have two tables, a CAD Drawing table, and a Parts
table.  I have made a many-to-many rel. with a BOM (bill
of materials) table as the junction table.  One drawing
can have many parts, and one part can go on many drawings.

I have an Access 2000 database. I created a picture field
(OLE) in one table. I then inserted 8 picture objects
into 8 separate records. All of the picture files (.jpg)
were about 30KB. However these 8 pictures caused my back

Hey Group,
I`ve created a table, and one of my feilds is Telephone Number, I have my
feild setup as a long interger. As im in the UK all telephone numbers start
0. My problem is when i type in my number as for example 01234 567890, it

I get the following error message:  "Microsoft Access
Can't Change the Data Type, There isn't enough disk space
or memory"  when I try to change a text(255) field to text
(25).   Since there are types of data imports where you

I posted this the other day to the general group.  Thanks
to Nikos Y. for responding but I don't think I did a very
good job of describing my situation and goals.  Here is
another try.

Numbers on my report occasionally change.  For example,  in my form I type 253.75.  When I print the report the number shows 253.76. When looking at the query, in datasheet view, the number shows 253.75 however when I click the field, the number shows a third decimal place 253 ...

Is it possible to use autonumber to generate a multiple-field key?  For example:
OrderID = 123  ProductID = 1
OrderID = 123  ProductID = 2
OrderID = 124  ProductID = 1