| Thread | Last Post | Replies |
|
| I would like to create a database in access for my work place to . | 10 Apr 2005 20:26 GMT | 1 |
I want to be able to create a database that would allow me to make my job easier. I want to create a database to input data on quarterly damage reports from approx. 5,000 facility owners per year and 300 non-damages. be able to input damages, where,how,when and by whom. ...
|
| Find Record Command Box | 10 Apr 2005 16:46 GMT | 3 |
I am new to data page design for the web. I want to have the user put in an id number and the attached database will find their record. I have been trying to use the toolbox command wizard but it doesn't seem to have a function for find a record. Is there an easy way to do ...
|
| Calculating A Field Value | 10 Apr 2005 13:57 GMT | 1 |
I want to add a field called Payments to a table. The value of this field is calculated by multiplying the Days field and the Fee field together (the Days and Fee fields are both in the same table as the Payments field). Could any one point me to information on how to set this up?
|
| Still Stuck on Alpha Numerics | 10 Apr 2005 13:29 GMT | 11 |
I need to sort a numbering system comprised by multiple alpha characters and numerics, and I need it to sort this list numerically, and not using a text convention. The records are in this general format with each character in a separate
|
| EUROCONVERT Trouble | 10 Apr 2005 03:25 GMT | 2 |
I have tried to use the EUROCONVERT Function to convert £ to Euro's but it keeps coming up with "Subscript out of range". How do I correct this problem? I am putting it in a Label DblClick procedure to convert the amount in a Text Box. I am using a Varient Variable, which has the ...
|
| Club Membership Database | 09 Apr 2005 20:10 GMT | 3 |
I have been thrown into the world of MS Access due 2 a school project! Being a complete beginner and have no idea where to begin with the project! The project is to design a badminton club membership database (which has no tournaments and is open every day), however having no ...
|
| Keying linked files | 09 Apr 2005 17:55 GMT | 3 |
I have two linked files that are generated from mainframe sales reports. I want to key these linked tables as the reports contain subtotal and total lines that are obviously unneccessary and even cause some problems. Does anyone know of any way to key - or otherwise ...
|
| Integrating Excel and Access | 09 Apr 2005 12:55 GMT | 4 |
I have been given the task of designing a database that would store customer information. However, It should be done in a way that when an invioce is created in excel it will be automatically recorded in the access database. All help in carrying out this process, is greatly ...
|
| Table design Updates | 09 Apr 2005 10:43 GMT | 1 |
1. I have set up a DB in access 2003 (ac200 format). I have split the db to front/back end. Installing a new version of the front end is easy. Copy - paste - replace. But for the backend?? Let's say I want to change a table (in the backend). What is the best way to
|
| At Your Survey Question | 09 Apr 2005 06:33 GMT | 1 |
I have been going through the At Your Survey template (thank you Duane) and have a question. I would like my 'RspnsType' to be various things, some text, some yes/no some date etc. I'm not sure how to use the RspnsType associated with each question to
|
| Is Data Just Data? | 09 Apr 2005 02:15 GMT | 4 |
If what I am considering is poor DB design I don't want to do it,,so if someone could give me clue I'd appreciate it. I have a particular table that I'd like to cull down to fewer fields. It is my equipment list. It has various fields that enable me to sort entries.
|
| Tables Relationship Question | 08 Apr 2005 18:45 GMT | 6 |
I am new at this so please have patience with the ignorant. I do not understand what is happening and hope someone can explain. I have two tables: Table 1 has several fields. The field called "telephone number" is the
|
| Proper multi-category structuri | 08 Apr 2005 04:27 GMT | 1 |
I'd like advice on the following issue: I have a "Categories" table with fields (*CatID, CatName), and in my "Items" table I need to have the necessary fields some that each record can be associated to any number of categories. Of course, I'd
|
| Access97 and composite unique indexes | 08 Apr 2005 02:45 GMT | 3 |
I am trying to put a unique constraint on three fields of a table, but in the Index dialog it complains that I have three rows with the same name. So, when I try to enter three column names on one line, it says there is not such column.
|
| Normalisation | 08 Apr 2005 00:55 GMT | 3 |
Basically I have a Database that keeps a log of all call monitoring sessions (where you listen to someones phone calls and give them marks if they fulfil certain criteria) this is my structure: Calls(CallID[PK],CallTime,CallDate,CustomerID) (The phonecall Monitored)
|