Search results for query: *

Hi, I have a table full my contacts. the tables creatively called contacts. What i want to be able to do is set up a drop down list where i can select one of my contacts from a drop down list then click a button pull up a invoice report with all the contacts details already entered into the...

Hi, I don't know where to start with this one seems a bit strange. I have 1 server 2003 machine, which is running exchange 2003 and isa 2004. On this machine i have setup OWA using SSL. This is where the problems start, sometimes it works and sometimes it doesn't. Today for example got into...

Hi, I don't know if this is possible but here goes!! Basically if i had a word document could i specify individual page settings so some pages are landscape and some are portrait Thanks a lot Dan

Hi!! I'm new to working with VPN's so go easy on me!! lol Here's my problem, i own a WAG54G and currently use Netscreen VPN client 8.2 to connect to my place of work. This unfortunately doesn't seem to work to well and is no-where near reliable enough for me! What i was wondering was is...

Hi, I have just recently purchased Veritas BE 9.1. I've installed this fine along with our Certance LTO2 Auto loader backup device. The only problem is i can not perform a backup to this device and i don't really know where to start looking for a solution. I have run BE Diagnostics and get...

Hi, i don't know if anyone will be able to help with this but here go's I've got some data win and loose columns with figures in. eg WIN LOOSE FRED 5 5 What i would like to show in the bar chart is The height of the bar going to 10 for played 10 (5+5) and then within that...

Hi, I am using a very in-flexible piece of software that produces a report in an xls file. I want to automate importing this file into a database. I have tried to set up an import spec but i am finding that i don't have the advanced options availible to me because i'm using an XLS file. Is...

Hi, I am a bit stuck in excel. I have two worksheets of data that i need to find matching rows of data in each. This part i managed to do using VLOOKUP. My problem now is that i need to search the two sheets and then pull a figure out from another location if they match. so i need to...

Hi, I have inherited a monthly job that involves copying and pasteing a lot of figures from other spreadsheets into one master spreadsheet. I was looking for ways to stop me falling asleep while doing this job and decided that the best solution would be to link the spreadsheets together so...

Hi, I have aquery set up that does everything that i want it to except one little bit. The data that i am running the query on can contain prices or the word refer. Is there any way that this can be set up so that i run the query and all the Refers are replaced with 0? Thanks a lot dan

Hi i am try to perform and average calculation on a field in a table which is fine and i can do that without any problems. My problem arises due to the fact that the fields can contain the word 'refer' which you can obviously not perform a calculation on. Is there any way that i can perform...

Hi, I have two tables that i am trying to run a query on. I need all the fields from both tables to be included in the query, however when i set this up and go to view the results of the query i get 'too many fields defined'. Is there anyway round this? thanks Dan

Hi, I have a copy of Access 2002 and none of the wizards don't work. I have Windows XP PRO and have been through most solutions that i have found such as reinstalling the wizards, uninstalling and reinstalling office. All of this to no avail. Does anyone have any other suggestions on how to...

Hi, I am setting up a query based on multiple tables but when i add all the fields that are required from all the tables and try to view the results of my query i get told that too many fields are selected!!! Is there any way round this little problem? None of the tables contain sililar...

Hi there, I have a database that has a table and a report. The table contains a lot of data and i need to filter some out for printing on the report. To achieve this i thought i would set up a query to run on that table and then set the query as the record source on the report. this is...

Hi, I am using an access database that has a particular report in that needs to be printed, this is fine but its 300 odd pages long and only 20 or so of the pages are needed. So printing this results in a lot of wasted paper. The report is made up of data from 2 different tables containing...

Hi, I have got a table that i have created by importing some data from a CSV file. I want to create a report to display some information from this table. I have created the report and now want to work out the average number for each of the columns in the table and then display this...

Hi, i have a MS-DOS based programme that i was running on my windows 98 machine. While i was using this programme if i was to press ALT+PrtScr and then F10 it would send the page i'm looking at to the printer and print it off. however since i have upgraded to XP this key combination only...

Hi, I have recently set up a VPN at work and am now trying to access my work email from home. I can do this fine by using web access. However i would like to set it up using my copy of outlook 2000 i think i have set this up ok, it resolves my mailbox name fine no problems there but every...

Hi, I have a slight problem with keyboard shortcuts. I have a ms-dos programme that pulls up a load of stats information now when using this programme on a windows 98 machine you can press alt+f10 and it will print a page out. However when you try to do this on an XP machine the keyboard...