Getting Started

Open File - Security Warning
I have a question and I'm not sure if it is a XP or Access one. I'm running Access 2000 under MS XP Media center edition and XP profesional I have 2 links to the same program. The first C:\projects\stores\Catalog.mdb Opens straight away. The second \\Dadxp\c\projects\stores\Catalog.mdb gives me the "Open ... 30 May 2008 21:18

Print selected record multiple times
I need to create a command button on a form that will allow me to print the single record I am viewing 3 times on one page (need to be cut apart for 3 different uses). I am a very inexperienced user. I was able to create a command button to print a single record, however, I need it to appear on the page 3 times... 29 May 2008 15:23

How do I make a Subtitle in Access?
I have small project on access but I have never used it before. What I trying to do I have title (Hot saw), under the title I have to create 5 to 6 sub title(example, 18 Table, 19 Table, etc,.). Now lets say I have problem in 19 Table then I want to write the decsription about the problem, Time, Date, Employee ... 29 May 2008 11:16

Displaying Information in one Table based on information in anothe
I have a Table containing Suppliers Information and the two fields I am interested in are "SupplierID" and "SupplierName", I have a Customer Table that contains the "SupplierID". I have a Form that is based on the Customer Table. On that form, I can easily pick and display the "SupplierID" because that info is h... 29 May 2008 09:13

Label Bound to another Label
Hi, is it possible to bound a label to another label with a lookup, ie, Label1 = AXY Label2 = 123 whereby there is a table showing that AXY belongs to 123? Thanks, Dolphin ... 29 May 2008 08:12

Join tables in Access
I want to join two tables . One is receivables and the other is payable. Payable table fields are : Name , Date , Amount Receivable table fields are : Name , Date , Amount Now what I need is when a query is fired For a common name in both the fields I should get the Data from both the tables for the same name. ... 29 May 2008 10:46

Cell 1 = row 1 balance minus row 2 balance
Hi, I have a table as below, and I want to create a new column NEW: Date A/c Balance NEW 1/1/08 ABC 100.00 200.00 (300-100) 1/2/08 DEF 300.00 -100.00 (200-300) 1/3/08 XYZ 200.00 200.00 (0-200) ie, next row balance minus last row balance. How do i do th... 29 May 2008 07:29

Date Problem
Hey guys, I'm creating a query that needs to be run off of Trade Date. However, all of my data is put into the database under Settlement date (Trade Date + 3 days). How can I tell the database to add 3 days to all of the items that populate, thus creating another field called Trade Date? ... 1 Jun 2008 13:44

Invoices outstanding at end of year
I am running Access 2000 on Windows XP. I need to design a query that will give me all the invoices in a database outstanding at the end of the UK Tax year. I can find all the records for the year OK. I have fields for Amount (Amount Invoiced) Payment (payment received) and Date (Payment Received). The year I ne... 29 May 2008 02:49

How do I total entries for a row
Here is my problem: I am keeping track of the number of Quality Assurance and Quality Control reviews for multiple projects. There are 35 different parameters that get checked for each project. I have five different tables: 1 for Project Information which contains the Project Engineer's name, contact in... 3 Jun 2008 20:08