I want to delete some numbers from a field in the
beginning of a table (eg 012 abcdefg, etc) There will be
loads of these numbers so I want to do it in code. The
actual number of digits will only ever be 3 max -

New at access so please help.  I have added 6,000 plus
records and it will no longer let me add the next
records.  How can I fix this so I can add to my database

Hello I would like an MSGBOX to pop up on the switchboard
whn a database is opened. I would like it to have a MSGBOX
to say that the following ID is up for review on (DATE
HERE).

Dear listmembers,
Is it possible to change default values in the table design view.
for example: De default value for the fieldsize of a textfield is 50. Could
I change that value by default.

Several years ago I saw an app that would look in an
Access database and list all the tables, column names,
etc., obtain query names and SQL, code behind forms, etc.
and save it to a text file. This was great when you

Thank you
Should Name Foreign key = Name of Primary Key..
example OrderID Primary = OrderID foreign If Yes (Why)
should Foreign key = Autonumber data type (like primary key) (IF Not)

I built the following Sub, in order to create tables automatically.
The button is placed on a mask where there are 3 txt box, two of them
contain the "Bank name" and "Bank a/c". I want to name the new table with a
string composed by the "Bank name"&"Bank a/c", How I could get it?

Can access handle a 1000 product web database?
Thank you
HigherMeaning

I think this question should be straight forward, but I'm surprised I
can't find a similar question on this newsgroup.
I have a table which has three fields in it that have Default Values.
I'm going to add data to the table by appending from another table (by

I have a table of chemicals' properties. The fields contain numeric data. But there are some substances for which some property has a non-numeric value. Like, say, Flash Point some liquids have a numeric values for it, whereas others have it equal to "None".
How do people get ...

Firstly - I'm no expert.
What I'm trying to achieve  - This is a simple club membership
requirement. I have some data held in an external system which I can
export via csv format. This is club member data and each record has a

I am trying to set up a reminder that will notify me before an upcomming appointment. getting a macro to remind me on a particular date is no problem. However I am not sure about the correct syntax to use for the time field. working with times seems to be more elusive than dates. ...

Can anyone tell me if memo fields are of a fixed size or
if each item of data stored has a different size depending
on its contents? I am currently using 255 character text
fields, but these are sometimes not big enough. I'm

Ok, I have been trying for two days now to turn this thing off and you guys have helped me and I appriate it. The only problem is your help isn't working much. You keep telling me to go to design mode and the combo box and stuff but I have no clue where to find ANY of this at. It ...

I need a default value in a field to be the last reading
from another record.  The database has a subform that
records hours a piece of equipment is used. The hour
field contains a start reading and an ending reading.