Getting Started

Problem with rounding error
I am using the Round worksheet function in a query. ExtendedPrice: Round([UnitPrice]*{Quantity],2). It works ok except if the answer is XX.5 it rounds down rather than up. Does anyone know why this is and can I change it to round up rather than down. Any help greatly appreciated John ... 28 Feb 2007 19:40

urgent!! getting stared into vista
I HAVE TRY DOWNLOADING SOME PROGRAMS THAT I WAS ABLE TO RUN WITH XP AND NOW THAT I HAVE VISTA THEY ARE NOT RUNNING... WHAT AM I DOING WRONG.. ... 27 Feb 2007 18:05

Europe Tests Established Chemicals on Millions of Animals
Tony Nottingham England 27 February 2007 TO: All People Who Care A new European Chemical Testing Policy called REACH has now been finalised by the European Union. Under these proposals Chemicals of every kind - from those used in industrial processes to the ing... 27 Feb 2007 13:45

No clue on what I am doing
So yeah What is Access for I have no clue what to do and I'm suppose to do this thing for school and yeah no clue please help me ... 28 Feb 2007 04:02

Enable command button
Hi All, I have on dirty behind my bound text boxes the following code. Private Sub RegisterNumber_Dirty(Cancel As Integer) 'Enable SaveAddNewRec1 only if ALL required textboxes are dirty If Me.AddNewRecIN.Enabled = True And Len(Me.DateReceived & vbNullString) = 0 Then ElseIf Me.AddNewRecOUT.Enable... 27 Feb 2007 20:12

Access cannot open
"dxmah" wrote: Happy holidays: I've been using Access 2002 for a while. This past week I copied a .mdb folder from my home PC onto my flash drive to work on at work. When I brought the flash drive back home to copy back onto my home PC, the folder could not open. I've tried "compacting and repairin... 27 Feb 2007 10:32

Delete A Record
Hi All, could you please let me know if the following is possible. I have a form linked to a table and I'm also using Allan Brownes audit log program. On the form I can add new incoming records, new outgoing records and also edit these. What I would like to achieve is to delete a record. On the form the use... 1 Mar 2007 00:53

how to create acuratefinancial records
I have been asked to creat databases for a car seller he wants me to basically input sales (price in/out etc) input staff wages expenses etc then calculate the P&L for this as wekk as be able to pull up VAT for selected quarter any ideas would be much appreciated thanks ... 27 Feb 2007 14:51

Checksheet
We have several forms that we use to track Audits that are done daily. I have been looking for an example of a simple Checksheet in Access so that I can lrean how to recreate those excel checksheets into Access Data that we can track our monthly performance on each item. Item 1 might be "Check for uncontrolled ... 27 Feb 2007 09:28

General question about setting properties
hello all I'm thinking about the best place to set certain properties in my database. Lets say my table has a numerical field. If I set a property like 'Decimal Places = 3' in the table, can I have confidence that this property will be passed to any queries and ultimately to forms / reports? What if the ... 27 Feb 2007 04:35