|
|
referential integrity and lookup by
buggirl
Hi all,
I want to enforce referential integrity between two fields in two separate
tables:
tbl FishTaxonomy (includes the full name, common name, and...
|
|
2 |
989 |
|
|
MultiSelect List Box (pre Access 2007) by
ShelleyS
I want to achieve (in Access 2003) what the built-in function in Access 2007
does by allowing users to select multiple items in a combo box or list box.
See...
|
|
3 |
989 |
|
|
Default to data in a different table? by
Flopbot
I know this might seem technically wrong and therefore, I haven’t found
advice on how to do it on these postings. I have an Access 03 table...
|
April 30th, 2010 12:53 AM
by Flopbot
|
2 |
986 |
|
|
|
March 12th, 2010 11:28 PM
by Bill
|
3 |
986 |
|
|
Accessing Database design mode by
luv2bike2
There is an DB that was create well before my time at my job and I have very
little experience with Access and need some help here.
Access 2003, XP SP3. ...
|
|
5 |
985 |
|
|
Auto populate field in table by
gm via AccessMonster.com
I have an Access data base that has acumulated 7 years of HR info. We plan to
moving this info
to HR Application. The new application has a field called field...
|
|
3 |
985 |
|
|
Table Structure Help by
Ron A.
I am needing some assistance in creating a solid table structure in creating
a database that stores vehicle permenant waiver items (items that will not be...
|
March 31st, 2010 07:26 PM
by Ron A.
|
3 |
984 |
|
|
Select statement includes "AS xyz_ID_xyz" by
Eva at Work
I used the table analyzer on imported data. good.
Noticed that a SELECT statement on the imported data includes the term as noted in the subject line, as xyz...
|
|
1 |
983 |
|
|
Table Normalization by
Jonathan Brown
I didn't normalize my database as well as I wish I had. I have a table
called EmpInfo that's built essentially as...
( 1 2 3)
|
|
27 |
980 |
|
|
|
|
8 |
980 |
|
|
CaseManagement by
Joe
Hi all,
Just created a database to keep track of case management for clients. I
have all demographics, types of case management intervention, but I'm having...
|
|
3 |
977 |
|
|
MS Access Table Design Look Up??? by
Laura1 via AccessMonster.com
I am trying to design a budget database and I want to have consistent
categories and expense.
I have a table with Category and Expense It looks something like...
|
|
2 |
975 |
|
|
Field Validation Rule to Exclude Ampersand by
Ken Hudson
I am trying to create a validation rule for a table field that will prevent
the use of the ampersand character (&).
InStr(1,,"&",1)0
does not work.
What is...
|
|
3 |
973 |
|
|
Sorting data by
Rob H
I have a table named Items, in this table the items are defined by Name,
Size, and Format. When first setting up the table I added a few of my items
to get...
|
March 17th, 2010 02:39 PM
by Fred
|
3 |
973 |
|
|
Clients and multiple accounts by
lanjoudun
I'm building a database for my personal training business, and currently I
ran into a huge pickle and don't know how to bite it. My problem is this, a
client...
|
July 7th, 2009 02:10 AM
by tina
|
9 |
973 |
|
|
Change blanks to 0 (zero) by
Jodie
I need to do an update to change all blank fields to a 0 (zero). In the
criteria, I have tried IsNull and it is not returning any of the blank
records. I...
|
|
5 |
957 |
|
|
Point of Sale database - does it exist? by
brainmush
I need to (very quickly) create a program that is user friendly that would be
used by a small corner store to track sales/inventory/expenses/employees/etc.
...
|
|
5 |
956 |
|
|
|
|
3 |
956 |
|
|
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 |
|
|
Access 2000 OLE Insert Object Dialog box by
Roger C. Bledsoe
How do I get Access 2000 inside the table to make it
recognized PhotoEd.exe in Insert Object dialog box so I can
add .jpeg or .gif photo into my database OLE...
|
|
0 |
954 |