| Thread | Last Post | Replies |
|
| Tables and all that. | 22 May 2004 03:35 GMT | 1 |
I compile the list of music played at a group. I am just starting in Access 2003 after using a Sinclair QL and Psions Archive for many years, so please bear with me.
|
| Forms and tab controls and tables | 21 May 2004 18:48 GMT | 2 |
I am using Microsoft Access 97. I have created a form with a tab control. On it I have added six pages. These six pages each link to six tables. However, at run time, I am unable to click on the first page and enter data to go into the first table and then click on the second ...
|
| trying to pull 2 fields from another table into this table | 21 May 2004 18:17 GMT | 3 |
I have a database which has multiple tables. There is a table for products which has various columns including ProductID, CategoryID, Product_Name and Product_Description.
|
| Table relationships | 21 May 2004 17:40 GMT | 1 |
Hello, all. We have an Access db that we use as a front-end to a SQL Server db, with the SQL Server tables linked in via ODBC. Is there any way to automatically pull in the table relationships (diagrams) without having to recreate them in Access? Thank you.
|
| Northwind | 21 May 2004 15:03 GMT | 3 |
I want to modify the Northwind db example. Looking at the design, I want to include another 3 or 4 tables that follow the schema of the "Order Details". If I look at the relationship between "Orders" and "Order Details" I think I want to be able to create multiple 1:M tables. For ...
|
| Calculation problem | 21 May 2004 15:01 GMT | 3 |
I took on a project at my work, that has me stumped now. I am trying to get this done, since currently, the raw data is entered into an Excel spreadsheet, that performs calculations. The results from those calculations are
|
| Is this structure going too far? | 21 May 2004 13:50 GMT | 3 |
I'm in the process of revamping my database, splitting the one table it's currently once based on into several related tables. I'm now trying to decide how to organize my Customer area. I normally do business with bookstores, but I also occasionally deal
|
| What queries are using a certain table | 21 May 2004 07:03 GMT | 1 |
Is there a way to find what queries are using a specific table? I have a database with over 100 queries and I need to find out which ones are using a specific table. Is there anyway to do that besides going through each query?
|
| Table and Relationship Limitations | 21 May 2004 07:02 GMT | 4 |
I have a table in my database that has 42 fields and is connected to 10 different tables through 1 to many relationships. This is just a part of the system too. Have a gone past the limits of access. I am having
|
| Error message "Invalid Argument" | 21 May 2004 02:27 GMT | 1 |
I get an error "invalid argument" in one of my tables' on the last record of the table the word '#error' is in every field. It will lock me up and it will not let me delete the record/ How can I delete the record.
|
| Reports created from forms | 21 May 2004 01:32 GMT | 1 |
Hi, I have a database which has quite a lot of queries built upon other tables and queries, they are all linked by a primary key called RUN NUMBER. The data input end is via various forms all linked through the sub form format so when I create a new record RUN NUMBER it creates ...
|
| Field Format | 21 May 2004 01:27 GMT | 3 |
Hi all - I have recently redesigned a database that I inherited. There is a particular field that has to display as 4 digits, with leading 0s. If I set the field as Long
|
| Adding multiple records at one time. | 21 May 2004 01:22 GMT | 3 |
I am trying to create a way to ask the user to [Key Name] and then have it ask how many times this name should be added to the database [Key number of records needed]. I have tried everything and nothing seems to work, not even
|
| Table Relationship | 21 May 2004 00:16 GMT | 2 |
Here's the scenario: (first database) I'm trying to create a database for Forklifts and how their batteries are used. (charged) 1. The program should prompt the user to input the dead
|
| creating an appointment diary | 20 May 2004 22:12 GMT | 2 |
i am doing a college project using Access. I am setting up an practice management system for my dad's podiatry clinic. I want to include an appointment diary (a table with dates, days of the week, times of day) into which
|