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
Good Design Tutorials by DDM
WStoreyII, I'll address one of your questions: the database design. Note that Access itself ships with a database template called "ledger," which does some of...
April 24th, 2004 05:19 PM
by DDM Go to last post
0 738
merging databases by Miles
I have an Access 2003 database containing about 150 tables. Almost all of the tables use an autonumber field as a primary key. How do I merge records from...
April 25th, 2004 03:35 PM
by Duane Hookom Go to last post
2 677
Importing in Access XP by MadCrazyNewbie
Hey Group, How could I import a Data from a Excel Spreadsheet, into a Already Exsiting Table, also can I choose which coloum(s) need what row of data...
April 26th, 2004 02:08 PM
by Cheryl Fischer Go to last post
1 621
Autonumber by Brian C
I was trying to add a first record to a table called BOOKING with the primary key defined as AUTONUMBER. I made a mistake because I needed to put a dummy...
April 26th, 2004 05:33 PM
by Tim Ferguson Go to last post
1 525
Tables & Formulas by Averil Pretty
Hello, My company tests candidates and / or existing staff members for our clients. Currently for each person there is an Excel document created from a...
April 26th, 2004 08:15 PM
by dandgard Go to last post
6 657
Table design for a booking system by Brian C
I'm trying to design some tables for a simple booking system for school rooms. I'm having some problems with trying to come up with a workable design. In...
April 27th, 2004 03:11 AM
by TC Go to last post
2 919
Lookup table by san
I have a table customer with two fields customerid and customer name. There is one more table sales with customerid and customer name in it. The relationship...
April 27th, 2004 03:34 AM
by TC Go to last post
2 714
Validation Rules by Tim Ferguson
"Jason Wills" wrote in : but i would like to make sure that people don't type in...
April 27th, 2004 10:52 AM
by Jason Wills Go to last post
1 682
I posted this this morning but didn't get a responce??? by Shaundra
I'm trying to create: 1. choices can be typed by the user 2. hit submit, or run or go 3. box below fills with those choises only I've tried unsuccessfully to...
April 27th, 2004 03:21 PM
by Kevin3NF Go to last post
3 727
3800 excel forms to make into table by Dkline
I have been in a similar situation - although it was only 3 workbooks each with 8 worksheets which had to be combined into one file to be linked. So once I...
April 27th, 2004 04:00 PM
by Dkline Go to last post
0 671
Linking To Excel by Dkline
I have the same problem. All of the underlying Excel spreadsheets are maintained by other people. If one them opens the file for editing, you're locked out. I...
April 27th, 2004 04:07 PM
by Dkline Go to last post
0 474
Format and Input Mask by James & Darla Martin
Hello all, I use a customized Format and Input Mask for all date fields on all my forms. Is there any DISADVANTAGE to adding these to the table design...
April 27th, 2004 04:35 PM
by Joan Wild Go to last post
1 517
Input Mask Help by DD
Hello kind and helpful people. I have a field in a table for which the syntax is 8 characters (both alpha and numeric). The last 3 digits of these 8 characters...
April 27th, 2004 05:47 PM
by Tim Ferguson Go to last post
2 558
#Num! in linked Excel file by Dkline
I have a linked Excel file. Within that file is a field/column of numbers. When I look at it in Excel - I see the numbers. When I look at in Access - I see...
April 27th, 2004 08:57 PM
by Dkline Go to last post
4 572
Input Mask-Change to Date/Time Format by DD
I have a date/time field in a table for which the format is general date. The default value is Now() which returns for example 4/27/2004 12:31:10 PM. How can I...
April 27th, 2004 09:15 PM
by John Vinson Go to last post
2 480
Preventing Records from being deleted? by Amy Johnson
Is it possible to lock a table so that new records can be added but existing ones can not be deleted?
April 27th, 2004 10:16 PM
by Steve Schapel Go to last post
1 429
How do you do an inner join... by jj
on just a PART of a field? Here's the structure so far: Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins. Here's the design & some sample...
April 28th, 2004 12:26 PM
by Gerald Stanley Go to last post
1 398
Time Calculations by James Mitchell
I have set up a 'simple' database for inputting times spent on jobs and created a query whereby an individuals statistics can be calculated for a month. The...
April 28th, 2004 04:23 PM
by Allen Browne Go to last post
1 501
Consistant error by Curt
I tried multiple different changes, but without any luck maybe someone here can help out on what I am doing wrong. I keep getting a message: The changes you...
April 28th, 2004 04:28 PM
by Curt Go to last post
1 454
Importing data into a MEMO field by RoMi
How do you import an arranged text into a memo/field where `arranged text` means the text with the several paragraphs, i.e. the text split into several rows by...
April 28th, 2004 05:07 PM
by Tim Ferguson Go to last post
1 553
Post New Thread

Display Options
Showing threads 1 to 20 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 12:26 AM.

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