A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Database Design Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 15th, 2004 04:52 AM
by Allen Browne Go to last post
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...
May 15th, 2004 08:21 AM
by John Vinson Go to last post
2 406
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 Go to last post
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...
May 15th, 2004 08:37 PM
by Peter De Baets Go to last post
4 556
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...
May 15th, 2004 09:51 PM
by Tim Ferguson Go to last post
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...
May 16th, 2004 02:54 AM
by Armen Stein Go to last post
3 488
Table - Too many fields defined - Access 2000 by Jones
We have a simple table set up for customers. The table only consists of 4 fields, CustID, Last Name, First Name, Middle Initial. All fields were originally...
May 16th, 2004 06:46 AM
by TC Go to last post
1 603
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 Go to last post
3 428
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 Go to last post
0 436
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 Go to last post
2 423
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...
May 17th, 2004 09:24 PM
by Tim Zych Go to last post
3 658
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...
May 17th, 2004 11:09 PM
by John Nurick Go to last post
1 1,217
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...
May 17th, 2004 11:41 PM
by Douglas J. Steele Go to last post
1 508
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 Go to last post
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 Go to last post
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...
May 18th, 2004 03:11 PM
by Jackie L Go to last post
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...
May 18th, 2004 04:26 PM
by Allison Go to last post
0 839
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...
May 18th, 2004 06:20 PM
by Holly Clifton Go to last post
3 566
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...
May 18th, 2004 06:28 PM
by Annette Go to last post
0 571
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 Go to last post
3 580
Post New Thread


Display Options
Showing threads 121 to 140 of 11610
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.