|
|
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
|
0 |
1,556 |
|
|
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...
|
|
2 |
1,347 |
|
|
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...
|
|
1 |
1,174 |
|
|
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...
|
|
1 |
1,104 |
|
|
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...
|
|
6 |
1,366 |
|
|
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
|
2 |
1,875 |
|
|
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
|
2 |
1,404 |
|
|
Validation Rules by
Tim Ferguson
"Jason Wills" wrote in
:
but i would like to make sure that people don't
type in...
|
|
1 |
1,350 |
|
|
|
|
3 |
1,446 |
|
|
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
|
0 |
1,324 |
|
|
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
|
0 |
956 |
|
|
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...
|
|
1 |
1,151 |
|
|
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...
|
|
2 |
1,079 |
|
|
#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
|
4 |
1,206 |
|
|
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...
|
|
2 |
873 |
|
|
|
|
1 |
887 |
|
|
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...
|
|
1 |
784 |
|
|
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...
|
|
1 |
945 |
|
|
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
|
1 |
907 |
|
|
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...
|
|
1 |
1,322 |