|
|
AutoNumber for Primary Key by
MT DOJ Help Desk
Access 2000
Is it possible--or wise--to use the AutoNumber data type for the primary
key? I seem to remember reading that it's not a good idea but I...
|
|
4 |
351 |
|
|
Lookup field in same table? by
eagletender
Can you create a field that will look up the id of a record in the same
table? For instance, a table of employees, with the SupervisorID as a field
so that it...
|
|
2 |
410 |
|
|
Calculating Feilds by
Stacy
HELp save the remainder of the hair I have not yet pulled
out.!
My question is I have a form that has freight and
material, and a field for total, when I use...
|
May 15th, 2004 05:02 PM
by
|
8 |
352 |
|
|
Switchboards by
Lin Light
Need to have two switchboards running off the same
database. I need to have one switchboard that makes
available only reports "read only" , while the other is...
|
|
4 |
564 |
|
|
Lookup ID#, etc. in tables by
savegelt
1. I have a table :"BuyerSeller" it has ID#, Company, Contact, Tel, City State, etc.( I keep track of all my BuyersSellers info in here)
I have another table...
|
|
1 |
253 |
|
|
Book on Table Design and Relationships by
Tom
I have some fundamental understanding of relational table design and how to
join them properly.
However, I'd like to read up on some more sophisticated ways...
|
|
3 |
495 |
|
|
|
May 16th, 2004 06:46 AM
by TC
|
1 |
611 |
|
|
Slow performance of linked dbs by
Denise
The UNC looks something like this \\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have something to do with extreme slowness searching. ...
|
May 16th, 2004 11:41 PM
by Denise
|
3 |
433 |
|
|
help in making database structure by
Avir
I have a simple database with following tables:
MainOrderDetails
Suppliers
Clients
Most of the information stays in MainOrderDetails table.
I wish to create...
|
May 17th, 2004 06:51 AM
by Avir
|
0 |
437 |
|
|
Combining tables by
Rose
I was getting the generic "sorry, can't do that" error when
I tried to import several Excel worksheets into 1 Access
table, so I brought them over as separate...
|
May 17th, 2004 06:35 PM
by Rose
|
2 |
431 |
|
|
no relationships at database level by
Tim Zych
What do you all think about not setting up any
relationships at the database level, but instead setting
up relationships in queries "on the fly" as...
|
|
3 |
678 |
|
|
Hyperlinks can't contain pound sign? by
Shifted Insights
I am creating a table with a field defined as a hyperlink. The files that these records will link to contain the pound sign (#) in the name. When I construct...
|
|
1 |
1,237 |
|
|
Parameter query for parts of date by
Rose
My date field is the traditional mm/d/yy format. I need to
create a parameter query that asks for the month and then
the year. I'm sure DatePart comes into...
|
|
1 |
516 |
|
|
Dates by
mikerz
Is it possible to get number of days between two dates, excluding
weekends and holidays? Please advise.
------------------------------------------------
~~...
|
May 18th, 2004 06:56 AM
by TC
|
1 |
273 |
|
|
Issue with junction table by
Luke P
Hi guys.
I am building a database for my university and need to keep track of students and tutors who are using the carparks. My tables are as...
|
May 18th, 2004 11:31 AM
by LukeP
|
4 |
403 |
|
|
Adding File to Import File Spec by
Ken
I put this question out to another group but got no
responses. Thought I would try here.
In Access 97 I can edit an existing file import
specification and...
|
|
5 |
356 |
|
|
Two Tables need same Data Type by
Allison
I have two different ODBC tables and as a result of a make
table query I'm trying to change the Data Type on both
tables to read "text". One table already...
|
|
0 |
857 |
|
|
Separate database for tables? by
Holly Clifton
In Access 2002 Bible, page 86, second paragraph, it says:
"It's also a good idea to create a separate datatbase for
just your tables. By separating your...
|
|
3 |
584 |
|
|
Linked tables #Deleted by
Annette
I am attempting to link a large DB2 table and all the data
shows as #Deleted, when a view is created on DB2 it links
in fine to access with no #Deleted.
Can...
|
|
0 |
578 |
|
|
Validation Rule by
Tom
I am wondering if someone knows how to create a validation rule in a table that would throw an error message in a form.
Here's what I have in a table:
Field1...
|
May 18th, 2004 10:27 PM
by Tom
|
3 |
588 |