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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I do this in a data access page?
Hi there
I was asked by my company to sort out some shared excel workbook problems and I thought I'd give access a try.I created 3 tables each being linked to one another and then created a data access page.My question is can you run a active query on a field that constantly searches the table to see if the value exist.If the value exist then it should fill out(or grey out) all fields from the same table.I would not like that specific table to grow with redundant data and i also would not like people calling me every second because their page recieves an error about duplicate values. Any help would greatly be appreciated. Thank You |
#2
|
|||
|
|||
Can I do this in a data access page?
"Broodjie" wrote in message
... Hi there I was asked by my company to sort out some shared excel workbook problems and I thought I'd give access a try.I created 3 tables each being linked to one another and then created a data access page.My question is can you run a active query on a field that constantly searches the table to see if the value exist.If the value exist then it should fill out(or grey out) all fields from the same table.I would not like that specific table to grow with redundant data and i also would not like people calling me every second because their page recieves an error about duplicate values. Are you saying that one field should contain no duplicates? If so then you can set this at table level. Open the table in design mode, move to the field in question and change the "indexed" property to "yes (no duplicates)". Sorted. Keith. www.keithwilby.com |
#3
|
|||
|
|||
Can I do this in a data access page?
or use a delete query to delete duplicates
"Broodjie" wrote: Hi there I was asked by my company to sort out some shared excel workbook problems and I thought I'd give access a try.I created 3 tables each being linked to one another and then created a data access page.My question is can you run a active query on a field that constantly searches the table to see if the value exist.If the value exist then it should fill out(or grey out) all fields from the same table.I would not like that specific table to grow with redundant data and i also would not like people calling me every second because their page recieves an error about duplicate values. Any help would greatly be appreciated. Thank You |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Upload a Document Via web Form or Data Access Page | Robert Micciche | Using Forms | 0 | August 2nd, 2005 06:13 PM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |