Getting Started

Access 2007
Somehow I clicked on the wrong button and did something to one of my access database files that makes it inaccessible. I get a message saying something like, 'You don't have permission....see....administrator' I'm a single user; only one profile. How do I delete this security and get back to my old configurati... 24 Feb 2007 22:50

Library system in access [help and advice plz]
hey im currently creating a small library system for my college project, and i need some help and advice. My tables are; * PK = Primary Key tblBook (PK)ISBN Title AuthorID PublisherID NumberOfCopies CategoryName PublicationYear Picture tblBookCopy (PK)CopyID ISBN DatePurchased ReplacementCost ... 26 Feb 2007 15:30

Counting items in a report
I am using Access 2003 I am running a report from a query and I want to make a summary at the end. I have two types of data , amounts and invoice reference numbers. These are analysed by supplier for each detail line. There is not a reference for each supplier on every detail line. The invoice reference nu... 25 Feb 2007 11:34

access 97 problem
I have had an Access 97 database on the network for 5 years that over 100 members of our staff use daily. The database has worked perfectly. Recently I amended it slightly and added a few validation rules. It works ok for the majority of staff but a few have had trouble accessing it - I'm not sure exactly wha... 25 Feb 2007 11:34

General number formatting question
I have a general question about formatting numbers. Is formatting (getting the right number of decimals, etc) usually best left until the values "arrive" in a form or report? Or, is it better practice to control formatting from the table/query end? thanks ... 23 Feb 2007 21:16

Access 2007 templates not working
Hi I have problem with access 2007 application templates both included and from office online. None of them works. Every time there is a message like 'Table 'xxxxx' not found in ...may be damaged..' or something similar. What is the problem and how can I fix it? Thanks Regards ... 23 Feb 2007 21:16

How to filter name type data?
I have a Names table that contains all the names of the database (with a nameType for each name). The Names table is related to the Main table with the Main table's pk related to the fk of the Names table. I want to myForm to list each nameType (there are 12+), along with the firstname, lastname, DOB, etc., i... 26 Feb 2007 16:02

Designing a Form in access
Im currently attempting to design a form in access. What i want is this. 1.)The form to open up with blank input tabs when newly opened (example, if there are 100 entries in the database, the form to open up blank when im opening the database and be ready to input entry 101) 2.)I have a column in my table for ... 23 Feb 2007 21:16

Access Newbie Adding fields
I have three tables. Here's a brief example of what's in them. Table1 has 100 PartNumber records, plus cost. PartNumber,Cost Table2 has Customer2 sales by PartNumber, 45 records. PartNumer,Sales Table3 has Customer3 sales by PartNumber, 75 records. PartNumer,Sales What I have done is created a relationship from T... 23 Feb 2007 16:09

Calendar Control 12.0 help
Hello, I am new at this so please bare with me.. I have a database built in access 2003 and I have been keeping track of employee attendance. I want to be able to bring up an employees name from a combo box and show thier attendance on this calendar. I also have an attendance code (Text) that gets entered for i... 26 Feb 2007 09:10