Search results for query: *

Not sure if this will make sense but here goes. I have a network throughout my home, pc's access the internet and printers via a netgear router, it works great, I have just upgraded one of the kids pc's and now I have a Pentium 3.2Ghhz, 512mb ram, etc.. spare, that I would like to be able to...

I have all my data in 1 table, it contains account that are in arrears with their payments. Every day about 6,000 records are updated into the table so we can compare movemements from day to day. What I want to do is produce a query that takes the position of all cases allocated to each...

Hi, I have a database that I want to export from, now everything is setup absolutely fine but when people are using the database one particular field has a dropdown menu and 6 options to select from. When I export that data I want to excel, it would very useful to us once you open excel to...

I have created a database with several forms and so far so good, When the database opens it shows a navigation menu which allow other forms to open. When forms open they simply open on top of the navigation form for viewing. However the new form I have created although works fine will only...

I want to create a form with an initial data source provided then for example list how many accounts were outstanding today, yesterday and so on.... Each day's data is in a seperate table, I thought about simply adding the data from each day to 1 table but then thought,no leave it as multiple...

I want to change the colour of a cell based on a result, my basic formula is: +(B9/(B7+B8)*100) This returns a % value of work completed, I want then to make that green if the result is above 80%, orange if between 50%-79% and red if below 50% Is that possible? Thanks Lee

Hello, I have some data I am adding to a spreadsheet, Its long and labor intensive as its an old system that I am copying data from and there is no option to run a query or similiar. So basically its copy rows of data from the old system and paste into Excel. The rows of data look like this>>...

Well its probably not an error just a setting. if I try and copy a formula it just keeps repeating the first value. A1 1 A2 =1+a1 A3 =1+a2 Thats what should happen when I drag down the sheet, but instead it produces all 1's anyone tell me what I have set wrong?

I have one more question in relation to a spreadsheet I am working on. Basically I have a number of sheets called Jan..Dec 12 of them obviously. I have added another sheet to the spreadsheet which contains data relating to the person who should deal with the account and I needed to populate...

Hello, I have a column of dates and what I want to do is search that column and count the number of dates that lie within a certain range. for example: date range 01/01/2004 - 01/01/2005 I want to search the 400 or so dates in my column of dates where there are dates that fall in the range...

I have a form linked to a query and want to put a text box on to calculate a total of payments received between two dates. The fields in the query are: date amount So I would want to do something like: sum [amount] were date is between x and y Anyone help? Thanks Lee

Hi, I want to insert an excel spreadsheet into word but conserve the setting of the excel spreadsheet, I have had to shrink the whole worksheet down to 1 page by 3, so its about 45% of its original size. But when I import or copy it it wont fit on the word document properly, I need to have it...

Hi, I have several forms that generate the results required from a query, when I print it all look fine but I dont know how to force some to print in Portrait and others in landscape, can anyon help? I also have a couple of forms that when I print them, although on the screen its less than 1...

What I want to do is take a date in one column and have it calculate the number of days that have elapsed up to the current date. Can anyone help me with that? Thanks Lee

Hi, I have a query setup using the design grid in access, not comfortable with the sql view yet. Basically I have 5 fields in there with the totals bar displayed, each field looks something like: Field: Promises Table: Payments Total: sum Sort: descending I want to enter something like the...

Hi, We have a server through EV1 which is used to back up customer data, every night the data is backed up to 3 locations the sever being 1, 30 days worth of data is stored and at the the start of each month the previous month is overwritten.... The server itself runs windows web server 2003...

I have done this before but I cant seem to get it to work right. I have around 1000 cells on excel with account numbers in the following format. 102498121/1 All I want to do is simply remove all of the "/1" characters from the end of each account.. Can someone help please. Lee

I already have windows xp pro installed and have purchased a new version of windows server 2003 web edition, I have tried it in vmware and it works fine but I would like to install it as a standalone on the hard drive. In essence dual boot so that when I start up the pc it gives me the option...

I thought I was through asking questions on access, but never mind :) We have a database in the new business area of the company, we are sitting here trying to figure out what has went wrong, but then we realised we cant. The following message is coming up and we suspect is locked by...

I have a number of tables that list customer accounts, each table represents a month, Jan, Feb, Mar, Etcc..... I want to display data from two tables March and April on the one form to compare them. how would I do this? I want to display all the records from table 1 and all the records from...