| Thread | Last Post | Replies |
|
| line breaks in reports | 06 Apr 2008 06:17 GMT | 1 |
Is it possible to put line breaks in a report? I have a full page of records (all the same group) and they are hard to read.Is there some way I can put in a line break every 5 records or so?
|
| Menubar in Access 2007 | 06 Apr 2008 05:08 GMT | 1 |
Is it possible to remove the ribbon and quick access bar in 2007 and create your own menubar as in previous versions of Access
|
| Question re composite key | 05 Apr 2008 17:46 GMT | 5 |
I have to design a database. It will contain details of planning applications. I've been told there is not a single item which will identify a site. There may be two reference numbers. I think this is a composite key. Are there any important points I should know if I use a ...
|
| Create table statement constraint syntax | 05 Apr 2008 17:36 GMT | 3 |
As part of a school assignment, I must create a table using an SQL statement in Microsoft access 2003. My statement works and the table is visible there ready to receive data. However, I was supposed to put a constraint on one of the numeric fields that will restrict entries to ...
|
| Report Wizard layout question | 05 Apr 2008 17:30 GMT | 1 |
Does anybody know why when using the Report Wizard the layout options "Columnar" "Tabular" and "Justified" change to "Stepped" "Blocked" and "Outline" - even without adding Grouping or Sorting levels? It seems to be the number of fields I use. Is there an upper limit?
|
| table redesign | 05 Apr 2008 06:16 GMT | 8 |
I have a table that consists of the following fields name, number, effect date, term date, date posted1, item1, debit1, credit1...date posted13, item13, debit13, credit13. I submitted a question on query design and was informed that my table is poorly designed.
|
| Access 2003 Lookup Lists | 05 Apr 2008 04:15 GMT | 1 |
I am trying to create an Access Database that will track employees training by keeping track of classes they have already taken and keeping track of classes they are scheduled to, or would like to, take in the future. My plan is to have a table for employees, a table for offices ...
|
| Sales | 04 Apr 2008 21:03 GMT | 4 |
I am looking to create a database that stores sales figures for a restaurant. I have four tables. tblSales wich has sales by 1/4 hour. I add the sales to get sales by whichever time slot I need. tblReconsile
|
| Totalling nested subforms | 04 Apr 2008 20:49 GMT | 7 |
Okay I've finished my training course on Visual Basic, so I now have basic training in Visual Basic, so to speak! My question is this. I have 2 nested subforms and I need some way to get the totals from the last sub form back to the main form.
|
| Attendance part of a Database | 04 Apr 2008 20:32 GMT | 3 |
I building a Database for Behavioral Health part of a Hospital. What I'm Trying to do is Make a client builder. So when a person comes in to be Registered than from that they get a Delagated to a Clinician, but what I want the Clinician to be able to do is Record the dates ...
|
| Parent Child Tables and Relationships | 04 Apr 2008 19:14 GMT | 6 |
I have a need to design a mdb file that revolves around two tables. My main table is patient-specific and needs to have a patient ID field, a Date field and a reviewer field. I'm going to call them ID, MRADATE and REVINT. For any ID, there will be two records having the same ...
|
| Replacing MDE | 04 Apr 2008 15:33 GMT | 4 |
I've created a copy of the database on my C drive to modify some of the forms. Now I want to replace the MDE on a shared directory. Do I create the MDE on my C drive and then copy it to the shared directory, or do I replace the database on the shared directory and then create ...
|
| Linking Records within a Table | 04 Apr 2008 14:02 GMT | 7 |
What is the best way to linked records within a table. For example I have a table with 1000 records. Out of those I want to link together those who are related.
|
| Almost identical sub tables | 04 Apr 2008 10:07 GMT | 7 |
I have two datasets linked in a one-to-many relationship. The many side of the dataset comprises two identical layouts, differing in only one key field. I have so far dealt with the issue by splitting the many side of the dataset into two tables, each served by a separate subform ...
|
| Design Assistance | 04 Apr 2008 03:40 GMT | 4 |
I had a database, and now I am redisigning based on what I learn here. I am developing a database based on a table called “members”. The premise of the database is to communicate via mail merge to a representative of that member, or spouse when they pass away. Mr. Smith passes, ...
|