Search results for query: *

Lo all, I'm trying to create a query that will give me the 'Average' time it took to close a case based on the dates from [open date] and [closed date] I've got the DateDiff working (guess that's the easy part) but how can I incorporate the Average to get the value required? Hope this isn't...

Hi all, I'm having difficulties with a query (suprise suprise) maybe you can offer some help? I need the query to check values in a field and if the value is between 1 and 5 it should give a level1, if it's between 6 and 10 give it a level2, if it's between 11 and 15 give it level3 etc... I'm...

Hi, I've been helped in getting a query to show yes or now based on the criteria specified in a table and I've now been trying various ways of getting this to automatically work on the form so when I finish entering details into the specific fields a text box will display Yes or No. In it's...

I need to convert a few excel formulas into access queries and was hoping for some advise. :-) one of the simpler ones is like this If all these fields meet the specified criteria the outcome is Yes otherwise No field1 | Field2 | Field3 | Feild4 >= "2" | = "Y" | > "3" | <= "3" When the...

Hi, I was asked to create a database and up until we got to the conversion of the excel workbook that they have been using up until now. There are about 10 cells that either have a number or y n I gone though all the other formulas and I should be alright coverting these into queries. I don't...

Hi, Is there any easy way to convert excel formulars into access queries? Basically there is a spreadsheet that is currently being used, the user enters data into cells 1 - 10 for example then based on these values it will change the value in another table. All sounds straight forward and...

Hi all, We have quite a few access databases that have been create by different people / departments. I now have the task of reviewing all these and making them all consistent. I'm currently wrtting up some design guidelines and would like any advise you have. I know what the colours, fonts...

Hi, I've just been tried to find out why only one person can open/access a database that's in a shared area. I tried opening the databse from within access using the exlusive / read only options but that didn't help. The only message I get is that someone else is in the database and I can't...

Hi, I've created a database, changed the startup options so that certain options aren't visable and I know that holding the left shift key when opening it will allow me to see the otherwise hidden objects / menus. Is there anyway of changing the key options so that holding down the left shift...

Hi, I'm putting together a HTML news letter for internal use, I've created my info boxes and when I preview them in Internet explorer they look fine and just how they should. When I then go into Outlook and select the same HTML page the table has small gaps in certain areas and nothing I've...

Hi, I have a Sony VAIO PCG-SR21 notebook with a bad installation of Win XP that needs reinstalling. The problem is, I don't have an external CD drive or any other device other than a network connection. So, the question is, can I install XP onto this laptop over the network? If so how...

Hi all, On MS NT 4 I can find out who is in a particular user group by doing the following: Right click Click Security Tab Permissions Add Click Group Click Members and this shows who's in the group... How do I get this same information on a Win2k workstation? And do I need Admin access to do...

Hi, I have set my combobox to 'Limit To List' and have tried various Input Mask options but I haven't found out how I can stop people going to a new record if all the combobox fields haven't been selected... Basically my form has a few comboboxes and each one of these needs to be selected...

Hi all, Could someone advise where I need to go to locate the problem for this error? "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate...

Hi all, Is there an easy way to limit input so that only a selected item from a combobox can be used? I have a combobox with a list of names, so varying lengths and I want to make it so that one of these names has to be selected and not typing them in manually. Thanks Tezdread &quot;With...

Hi, after a long week of re-installing and re-configuring my Win 2k server I've got Exchange setup and everything is ready to go...but where do I go? I've gone through the Help file, looked on the web and can't seem to find the basics?! So, I have setup a couple of users in AD and entered the...

My signature couldn't be more true!! My last posts were about getting my DNS sorted, which I've pretty much done but it looks like it's at the cost of my AD?? After rebooting I checked the Event viewer and noticed this: Event ID: 1126 "Unable to establish connection with global catalog." I...

Hi, I started running through the prelim steps to install Exchange2003 on my Win2k Server (PDC) and when I came to run dcdaig and netdiag I get these error in the logs. ====================== Dcdiag ====================== Testing server: Default-First-Site\ABSOSERVER Starting test...

Hi all, I'm putting together this HTML tool that will display system downtime and other information in a calendar type page. (http://213.105.99.12/newdesign/kit.htm) The main page is displayed in an IFrame and the Month links point to their respective months anchor, however it doesn't always...

Hi all, I'm putting together this HTML tool that will display system downtime and other information in a calendar type page. (http://213.105.99.12/newdesign/kit.htm) The main page is displayed in an IFrame and the Month links point to their respective months anchor, however it doesn't always...