| Thread | Last Post | Replies |
|
| DATABASE CRASHES when creating new report from existing report | 25 Jan 2008 01:55 GMT | 6 |
I tried to create a new report from an existing report by using "save as" while in report preview. It seemed to work. When I went to the database window under reports, my new report name was not there. I get the follwing error message:
|
| Multiple error messages | 24 Jan 2008 17:09 GMT | 5 |
I am the creator of an Access database and currently the only person having this problem...I get errors of many types when I have left the database open and return to or attempt to scroll through records. The errors are intermittent and seem to occur when I have multiple ...
|
| Duplicate Values Question | 24 Jan 2008 16:02 GMT | 15 |
I have a table containing, among others, a field titled numSerialNumber ("SN") and a field titled strBoardNumber ("BN"). The SN field is the primary key, and the BN field is required. Additionally, the BN field must contain a unique value, unless the SN
|
| Lookup Wizard not displaying all field choices | 24 Jan 2008 14:32 GMT | 2 |
I realize a bunch of people posting do not like lookup up columns, but i really have never had a problem with them...until today. We are creating tables for a new database - eventually, everyone will be using a form to enter data. Until the form is created, testing data entry
|
| One to Many and Auto Number Problem | 24 Jan 2008 03:54 GMT | 26 |
I helped a co-worker set up a One to Many design. The parent table had a field called TransID and we linked it to a child table which also had a field called TransID. However, in keeping with the goal of having unique records [a Primary Key], even though I don't like them, we ...
|
| Integrating "Blocks" of Constants | 23 Jan 2008 20:34 GMT | 4 |
GIVEN: A spreadsheet containing a dozen "blocks" of constants data. Each block consists of 16 columns and 12 rows of constants, and each block relates to a named, geographical location
|
| ODBC Linked Tables | 23 Jan 2008 17:02 GMT | 2 |
Is there any way to point the linked tables that I have to another source. I have the same tables in a test database as I do in live, whilst developing the database I pointed everything to test now it is doing what I want I want it to look at live. Is there anyway to change the ...
|
| Calendar Control 12 | 23 Jan 2008 16:41 GMT | 1 |
How do I display event information in the calendar on calendar control. I want to be able to click on a date and see the appointment information for that date in the calendar such as in Outlook calendars.
|
| How to prevent duplicates of non-primary key | 23 Jan 2008 13:55 GMT | 14 |
I am using Access as a front-end to an SQL database. I need to be able to prevent having duplicate keys without using a composite primary key. I have a table that allows an employee to have multiple skill sets: SkillID - as my primary unique ID field
|
| Transferring cumulative weekly time 40:00:00 from Access to Crysta | 23 Jan 2008 08:52 GMT | 2 |
I am creating a database with weekly staff hours in a format of 40:00:00, I figured out how to get access to accept these numbers but now I need to transfer this data accross to a crystal report to help compile it all. I believe their may be a setting in Access to allow this ...
|
| appointment scheduler table structure | 23 Jan 2008 02:28 GMT | 1 |
I know that I may have more luck posting this question in an Outlook group, but these Access groups are the ones that I most frequent, and I like all of the regulars here. This subject comes up quite a bit in these MSAccess forums, and I have actually already designed a database ...
|
| Junction Tables | 23 Jan 2008 00:36 GMT | 7 |
Is this valid? Three tables (call them A, B & C), each with a junction table between (call them a, b & c). Six tables total, in a related in a circle? Is there something I'm missing with the junction tables?
|
| ms access relationship problem | 22 Jan 2008 16:03 GMT | 1 |
I created a database in access with the following table. but when ever i try to enter data it gives an error message. "You cannot add or change a record because a related record is required in table 'Insti_details'
|
| Design strategy | 22 Jan 2008 11:33 GMT | 6 |
This will be a bit difficult ot explain, hope it clear. As a product manager I'm responsable for a few brands. This means, I need to keep SAP up-to-date for these products. t.i. buying and selling prices, taxes etc.... On the other hand i retrieve data from SAP for analyses and
|
| simple inventory for printer toners | 21 Jan 2008 22:43 GMT | 1 |
I need to order and track printer toners. We have many many different printers, therefore many toners. When a user requests toner, I need to enter their department and name. At the end of the month I need a report that lists which toner the user took, date they took; so I can ...
|