|
|
DB Design and Relationship Questions by
tjr
Thank you, in advance for your help. I need to determine best practices for
establishing relationships between following tables. But first:
I have clients who...
|
|
7 |
450 |
|
|
Linking Access table to Excel by
Daniel Lee
I have a table in Access that I run many update queries on to get the data
in the correct format. Once this is completed, I then need to export this
data...
|
|
7 |
68 |
|
|
Multi criteria SEARCH function by
Stilla
I have a simple database for storing information about research articles.
Fields on the input form include title, author, year, journal, type,
keypoint1,...
|
|
7 |
80 |
|
|
Tables won't link correctly by
eatc7402 via AccessMonster.com
I am using Access 2002. I have two tables. The primary table has an
autonumber field which is set to increment. The field is a long integer.This
field is set...
|
March 2nd, 2007 04:03 AM
by tina
|
7 |
134 |
|
|
Import 1 record to many tables by
Graeme at Raptup
Hi,
I have a set-up where I import an Excel spreadsheet (usually only 1 record)
into a temporary table that is appended to one table (Artwork approval) in my...
|
|
7 |
64 |
|
|
need help in creating table by
nishkrish
Employee Table
Employe ID AutoNumber
Primary Name Number
Secondary Number
when i input NO.1 in Primary Name it should show me Persons name in the drop
down...
|
|
7 |
97 |
|
|
database help by
Need Help
am trying to build a database and need a query build to count times example
Hound Number 999 score 35 Time 11:00
Hound Number 999 score 30 ...
|
|
7 |
98 |
|
|
Many to many to many by
an
I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary...
|
March 10th, 2007 04:01 PM
by an
|
7 |
97 |
|
|
Status Field by
FIECA
Hi All!
I want to create a ("status") field in my contracts tracking table to tell
me the status of the contract based on whether or not some other fields in...
|
|
7 |
103 |
|
|
Db Relationship problem by
Stuart Jack
Hi
I am building a database for patient information and am having a problem at
the earliest stage with the relationships. So far I have 3 main tables which
I...
|
|
7 |
118 |
|
|
Relationship Issue by
Jason Lepack
tbl_parts:
part_id - autonumber - pk
part_description - text
tbl_bom: (bill of material)
bom_id - autonumber - indexed(no dupes)
part_id - number -...
|
|
7 |
170 |
|
|
Access Field default format by
GHatch
Can you set format a field with a default that would calculate a date + 4
years and put that date in???
|
December 27th, 2006 05:56 AM
by MarioFan
|
7 |
154 |
|
|
Is the use of Enity IDs bad? by
asc4john
I have a table that hands out Entity IDs to every item in my database,
that is every item now has a unique ID in the database as well as an
Autonumber ID in...
|
|
7 |
90 |
|
|
Combo Box by
Fred
How can I use 4 combo boxes to each show all information from a table? I am
only able to get 2 combo boxes to show 2 table fields.
|
|
7 |
88 |
|
|
Don't know how to explain my problem!!! by
Sue
after working with Access 97 for years,i finally switched to 2000.i'm having
a problem when i set up a new table with numerical fields (for example: a
table...
|
|
7 |
66 |
|
|
Verify Front End for expiration by
xquestions
We are building multiple databases for different purposes in the company and
we are splitting each one of them with a front end and a back end. The front...
|
January 29th, 2007 01:54 PM
by Klatuu
|
7 |
182 |
|
|
Total calculated time is incorrect by
CMTH
Total calculated time from 11:30pm to 12:10am is being returned as 23:20
instead of 00:40.
Expression being used is =Format(-,"Short Time")
|
February 4th, 2007 04:52 AM
by CMTH
|
7 |
68 |
|
|
|
February 8th, 2007 04:45 PM
by Deanoh
|
7 |
141 |
|
|
Database design by
ckloch
I have a database which tracks client investments. Periodically we
have to recommend a change to these investments. When we recommend
changes I need to...
|
|
7 |
87 |
|
|
Table Troubles by
[email protected]
Ok here is the situation. I a looking at setting up a database for my
company that tracks manufactures/potential manufactures and their
capabilities.
What I...
|
April 3rd, 2007 05:16 AM
by tina
|
7 |
171 |