General

NEGATIVE NUMBERS
I am using conditional formatting in Access and am trying to format by fill colour three separate conditions which are based on the sum result of two other cells. First: greater than 10 (Green); second: between 9 and minus 5 (Red); third: less than minus 5). Can anybody assist as I find only two of the colour f... 31 May 2006 06:30

.crd file
how do I open a .crd file? ... 23 May 2006 05:50

invoice in access
I have 300 rows [clients] down, and 25-30 colums [ie first name, last name general info] across. i would like to print 6-8 different types of invoices containing the information in thes colums to 1 or many clients. How do i create a report or invoice? ... 18 May 2006 17:12

-newbie- Number Format
Hello, I made a Table where there is a entry: "ft 2" I need to enter a number with 2 decimal places. I just finished a form, but I haven't managed to set it to have the number in that format, it gives no decimal places. What do I need to do? thanks in advance ... 17 May 2006 14:56

automate open text file
Want to automate this simple sequence from Excel VBA: Start Access, but no need to be visible. File Open text file. Comma delimited, first row are field names. Save as .mdb in specified folder. Seems simple, but I can't see anything that does it. I understand that unfortunately Access doesn't have the option t... 19 May 2006 15:26

Financial Returns...
Hi Guys, I am currently working on a putting together an sql query that calculates, given an index, the percentage returns over a given period. I have written the qeury that can calculate the percentage return. However, the problem that I have is trying to combine these queries into one large query that will r... 1 May 2006 20:10

Sandbox mode
Hi, I'm going to deploy Office 2003 via SMS 2003. However, we keep seeing "unsave expressions are not blocked" message when I open any Access files on a few test PCs. We are mainly using Windows 2000 with SP4 and also the Rollup 1 so that should take care of the Jet 4.0 part. I know that I can click "yes"... 26 Apr 2006 08:05

popup block.
An unknown error has occurred. Account: 'Hotmail', Server: 'http://services.msn.com/svcs/hotmail/httpmail.asp', Protocol: HTTPMail, Port: 0, Secure(SSL): No, Socket Error: 12019, Error Number: 0x80004005 ... 19 Apr 2006 15:03

saving docs in word
Word will now not let me save a document or open existing folders, it goes into non-responsive mode ... 19 Apr 2006 08:13

scatter plot
I have the values for my scatter plot in two columns of a query. But when I try to create a scatter plot from them, all of the dots appear on a vertical line (the x=1 vertical line). I have played with every option of Microsoft Graph and changed the source table format but it always does the same. Every other pro... 18 Apr 2006 12:49