|
|
|
|
3 |
126 |
|
|
AutoNumber (Primary Key) by
Gregg Knapp
I'm setting up an Access DB (v2003) for use as the backend of
a web application. As the db grows I see the potential of upsizing
the db to SQL Server.
So I'm...
|
|
7 |
312 |
|
|
Document management by
instauratio
I have recently been aproached with questions about
Document management / Relational Databases for managing
business. I also recently attended a presentation...
|
|
4 |
241 |
|
|
|
|
1 |
660 |
|
|
Missiing field by
GADGET
We have an old database where one field has gone missing.
If you check under design the field name is listed. But when you open the
table the field is...
|
|
3 |
139 |
|
|
Export Table does not work? by
Kayek
I am using Access 2000.
I am having troubles exporting a table. It don't always
work?
1. select the table
2. select from the menu bar File then Export
3....
|
July 23rd, 2004 10:06 AM
by Theo
|
1 |
131 |
|
|
add an integer to Date the get Date? by
aa
I have a table "Invoices" containing, among other things, the date of the
invoice, as type Date
I have another table "Customers" containing, among other...
|
|
7 |
303 |
|
|
single or multiple tables by
AdmSteck
Here is my situation. I already have a database with a list of all the parts our facility manufactures: PartID, PartName, PartNumber, etc.
I need to create...
|
|
5 |
422 |
|
|
datasheet window resize by
Andy
Using Access 2003. Have a utilty db with a lot of small
tables (2 or 3 columns, 10 or 20 rows). Each time I open
the table in datasheet view, I'd like it to...
|
|
1 |
296 |
|
|
A Complex Scenario by
Scott Matheny
Say I have a tables of records that are tests, and each
has a sponsor company and a test company. Also, there is
another single table with all the companies'...
|
|
7 |
175 |
|
|
Product costing by
Bronjd
Quite simply, I want to 'design' a database that will keep track of the cost of individual items so that I will know what to charge when I sell items made up...
|
July 21st, 2004 07:13 AM
by Epicpic
|
2 |
152 |
|
|
Multiple Primary Keys by
Mike
Hello,
Can I have 2 primary keys where Access requires that they
are both not the same. For example...
Field1 Field2
a 1
a 2
b 2
|
|
7 |
386 |
|
|
|
|
1 |
118 |
|
|
Many members, many events by
Microsoft
Greetings,
I am using Access 2000 on W2K & XP Home machines. I am designing a db to
track calls for a volunteer fire department. I have a table for calls...
|
July 18th, 2004 04:57 PM
by rpw
|
1 |
93 |
|
|
|
July 17th, 2004 11:39 PM
by rpw
|
5 |
435 |
|
|
Number format problem by
Stu
I believe I have experienced this problem before but I'm
not sure. Isn't there a problem when number data is
inserted into a table like: 01001, 02002 ??? I...
|
|
2 |
226 |
|
|
HELP ADDING RECORDS by
Katrina Kleinhans
I need to know how to add a record inbetween two records
that I already have. I have been looking in the help, in
books, and on the internet and can't find...
|
|
2 |
243 |
|
|
Staff vs. Contact Tables by
Kelly
I'm pretty sure I have a design problem here but can't
seem to see it (although I'm sure it's right in front of
my face!)...
I have a database that stores...
|
|
3 |
519 |
|
|
Input mask question by
CMB from Omaha
For some reason I just cannot get my head wrapped around the concept of input masks in Access database design. Can someone pls explain this concept,...
|
|
5 |
354 |
|
|
Defining Relationships by
Jacob
I can define my relationship as 1:1 or 1:N but what about implementing business rule restrictions etc. For example can i show that a table is Optional or that...
|
|
4 |
158 |