Text data type field size
Fri, 9 Jan 2009 12:03:05 +1100
Hi guys and gals
Just wondering. From a storage perspective, if I have a field that has the
data type Text with a size of 50, does Access actually allocate storage
space in each record for all 50 characters if there is nothing in the field
or if the data in the field is less than 50 characters long?
Than ...
|
Designing Access Table in Excel >> Copying to Access Desgign
Thu, 8 Jan 2009 15:21:49 -0800
Hello,
I have a large database I am palnning designing in Excel (Thousands of
fields, etc). For each table I have all the fields, data types and field
names in excel just as they appear in the access table design view.
Question, does anyone know how I can copy, move or import all the fiels per
table fro ...
|
IIF statement in text box
Thu, 8 Jan 2009 12:01:07 -0800
I am trying to create an IIf statement that will generate the sentence "Your
account balance is $XX.XXX" for customers who have a balance due. Balance
is a field in my query.
I have put in the statement =IIf([Balance]>0.01,"As of the end of January,
your account balance was $" & [Balance] ,"") For cus ...
|
Incrementing a key value
Thu, 8 Jan 2009 09:46:43 -0800
I need to increment a key value by "1" with each new record and the "1" needs
to be a text field so that the format of it can be "L0001", "L0002",.....
Using Access 2003.
...
|
Normalising a Many-to-Many Relationship
Thu, 8 Jan 2009 06:32:18 -0800
I am designing a Components database to analyse forecast costings of parts
based on quotes. I have two tables that appear to have a Many-to-Many
relationship, and I want to resolve this into two Many-to-Ones. My tables are:
tbl_Parts, consisting of:
txt_PartNumber (PK)
txt_PartDescription
etc.
tbl_Price ...
|
Formatting and working with dates/months
Thu, 8 Jan 2009 05:46:51 -0800
My database has a calculated date when calibrations are due again, for
example, =date()+90 from the last calibration date. My problem is, the
calibration can be done anytime during the month - so if it is done on the
1st or 2nd, then it shows up on the overdue report in the month that it is
actually due. For ...
|
data is repeating itself
Wed, 7 Jan 2009 15:01:25 -0800
I have set up a DB for our Transport Managment Dept. Containing a main table
holding our trucks details (Vehicle Details). I have created a Servicing,
Maintenance, Inventory, Equipment, Defects and Equipment tables. I have
created a Single Main form with sub forms for all the tables. Everything
seems fine wi ...
|
|
|
MS Access 2003
Wed, 7 Jan 2009 13:17:06 -0800
I have a small tracking database with about five users. Recently when a user
logs in it locks all the others out of the database. I have been using this
database since 2004 and this just started happening. Anybody have an idea
why?
--
Don Wyman
San Antonio, Texas ...
|
New database
Wed, 7 Jan 2009 08:07:01 -0800
i have a current database that is quickly outgrowing the previous design. I
want to create another database that will be more in line with current
designs. My reluctance is that I don't know that much about relationships
and could use help in designing the newest database. ...
|
Linking Sub-forms to Forms
Wed, 7 Jan 2009 08:06:26 -0800
I made a database with 17 tables. It is an inspection with 16
sub-catagories. The main table has Location, Date, Time ect... and the other
16 tables are sub- catagories. I made a form with 16 subforms and set
autonumber as the primary key for all of the tables.
When I create a new record in the main form ...
|
