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
How to undo a record which was created through a macro? by Sally
The form is opened with a macro to open it to a new record with a autonumber. How can I undo this record if the patient's last and first name has already...
July 23rd, 2004 07:56 PM
by Steve Schapel Go to last post
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...
July 23rd, 2004 07:27 PM
by Craig Alexander Morrison Go to last post
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...
July 23rd, 2004 02:28 PM
by instauratio Go to last post
4 241
counting cells in a range having certain format by
Is there a way to use the countif function to count cells in a range with 1) a red background and 2) that contain letter "A". Something like the...
July 23rd, 2004 01:54 PM
by Lynn Trapp Go to last post
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...
July 23rd, 2004 01:43 PM
by Van T. Dinh Go to last post
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 Go to last post
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...
July 23rd, 2004 05:32 AM
by Tom Ellison Go to last post
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...
July 22nd, 2004 08:15 PM
by Steve Schapel Go to last post
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...
July 22nd, 2004 05:29 PM
by Tim Ferguson Go to last post
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'...
July 21st, 2004 05:59 PM
by Tim Ferguson Go to last post
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 Go to last post
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
July 19th, 2004 05:53 PM
by Craig Alexander Morrison Go to last post
7 386
reconnect split database by John
How do I reconnect a split database in Acc 97?
July 18th, 2004 07:57 PM
by Douglas J. Steele Go to last post
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 Go to last post
1 93
Table structure, Child/Parent relationship for Family Tree Databas by Mike
Of all things, I'm creating a Family Tree database which uses many of the same terms as database such as Child/Parent etc.... My question is: What's the best...
July 17th, 2004 11:39 PM
by rpw Go to last post
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...
July 17th, 2004 02:26 PM
by Jeff Boyce Go to last post
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...
July 17th, 2004 02:21 PM
by Jeff Boyce Go to last post
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...
July 17th, 2004 02:09 PM
by Jeff Boyce Go to last post
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,...
July 16th, 2004 05:40 PM
by Tim Ferguson Go to last post
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...
July 16th, 2004 05:32 PM
by Tim Ferguson Go to last post
4 158
Post New Thread


Display Options
Showing threads 11181 to 11200 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 09:17 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.