| Thread | Last Post | Replies |
|
| ID field issue when combining databases | 20 Sep 2006 22:11 GMT | 5 |
Hi, I have written a database for 6 sales reps. Each rep travels and will need his/her database stored locally on their laptop. Periodically we will need to combine all 6 databases into a "Master". I don't have any flexibility to change this procedure. I have two questions:
|
| How do you format cells to copy the formula above it? | 20 Sep 2006 20:51 GMT | 2 |
I have some spreadsheets that will automatically copy the formula above when data is entered in the cell to the left of the cell where the formula is needed. I can't find how this feature is turned on.......
|
| Setting Up tables | 20 Sep 2006 17:45 GMT | 7 |
I run a charter boat, there are many other charter boats in the port I fish out of, there are also ports to the north and south of our port that have charter fishing. What I first wanted to do was compare there rates to see what would be the
|
| Adding a primary key from a one to many table | 20 Sep 2006 17:44 GMT | 1 |
I have 2 tables in my database the first table contains student IDs which is the primanry key for the database. The second table contains the student's activity for a particular semester such as curriculum declared, hours taken, etc. I download this information from a statewide ...
|
| Data Entry on form | 20 Sep 2006 17:39 GMT | 2 |
My table looks like this: Timepoint Date On OFF I have 15 Time Points, how can i show this on 1 page in a form for data entry. Please be Basic my brain is fried.
|
| Design change prevents data update | 20 Sep 2006 16:03 GMT | 1 |
I have created a contact list/address book in MS Access. The purpose of this was to separate about 300 names into groups by employment category, and cross reference them by association with various (and many times multiple) departments. As devised, it worked as expected. From a ...
|
| Linked table not showing last field | 20 Sep 2006 13:21 GMT | 2 |
I'm making a linked table to an excel spreadsheet using the wizard in Access 2000. For some reason the linked table is not showing the last column of the spreadsheet.
|
| Is there an access example of a finite state machine? | 20 Sep 2006 00:25 GMT | 2 |
I'm trying to create a problem solving database in the form of a finite state machine in MS-Access. Does anyone know of any FSM examples? TIA
|
| INDEX ALREADY EXISTS WITH SOME AS400 TABLES | 19 Sep 2006 23:07 GMT | 2 |
Hello all!! I have been trying to solve this problem for last weeks without success. I would like to link a AS400 table with MsAccess through ODBC. I linked tables from the same AS400 without problem, but when i try to link some tables the
|
| Patient Location | 19 Sep 2006 21:16 GMT | 5 |
I am using Acess 2003 for the first time. I have been using Access 2000. I have a List of patients admitted to the hospital on therapy. I need to have their location based on Area, Room Number and Bed Number. This also will tie in with therapy type because I need to know where ...
|
| Forcing data to be stored in special format | 19 Sep 2006 19:48 GMT | 6 |
Can I make field definitions that force my data to be formatted in a special way? I have a table with different fields - some should be formatted with 3 decimals, some with 2 and some with none etc.
|
| Table design view | 19 Sep 2006 19:46 GMT | 1 |
Access freezes whenever I try to view the table in design view. How do I fix this?
|
| Can I do this ? Import tables to change some fields and leave others alone. | 19 Sep 2006 03:48 GMT | 1 |
I have a program that gathers hardware info from about 100 compuers. It puts it nicely into several fields, 30 or so. CPU Speed, Disk size, Bios name and version. That kind of stuff. This information as I say is from a program that goes out and gets the
|
| building a parts database and need to make 2 different queries | 18 Sep 2006 22:56 GMT | 2 |
i just finished cataloguing a parts database at an airplane repair shop that is split into different tables based on plane model or utility(ex. "cessna" , "engine", "electrical"). the tables are identical in terms of the types of fields they have. i want
|
| How to import text file with percent greater than 100% | 18 Sep 2006 21:44 GMT | 1 |
Trying to import a txt file (comma delimited) a field that has a value greater than 100% imports to Access with five digits to the right of the decimal point. I have tried many combinations and cannot get the right value in Access. A search has revealed nothing.
|