Search results for query: *

Hi there I am hoping someone can point me in the right direction. I am attempting to pick out the latest salary update/reduction from personnel data - for example Employee Ref Date effective Salary Old Salary 1001 01/04/2011 15000 14000 1001...

Trying to replace a date field using following 2 examples and I am getting "function argument value,type or account is invalid". I have SET DATE BRITISH AND SET CENTURY ON. replace it_dteinv with DTOC(05/28/2010) FOR IT_DOC="DOC11320" replace it_dteinv with dtoc(22/06/2010) FOR...

Sorry if this is very basic but I am not sql orientated. I need to put a sql query together I require to say If year = year and month = month return a value if not return zero I hope that makes sense to someone out there Any pointers gratefully received Regards Jack

New SBS 2008 Setup New Clients - All Vista Business (5) I am having problems accessing network shares from the clients.. I can map a drive/open and see files. But when I try and open the mapped drive I get a Unable to reconnect Drive already in use This did not happen straight away - Ok for...

Hello there I have a spreadsheet with the first 7 columns populated via a data query, 2 additional columns that are manual input, and 6 columns that are product/sum formulae. My problem is that wbenever the sheet is updated and a line is inserted by the query - the formula does not move with...

Hello there I am not to au-fait with this so forgive me if it is really basic. I have taken over a small business and I want all the customers who would have accessed the original business site to be re-directed to mine. Both websites are hosted by different ISP currently. I dont really want...

Hello there I am using Access 2003 for data front end to a SQL 2005 DB. I am trying to design a 'job card' that will allow users to report faults/request help. What I want to do is Have a Date reported box on the job card Form that will auto input the date reported (linked to the relevant...

Hello there I am trying to setup a basic SQL DB in SQL 2005 post a sql admin course to enable a little practice. My project is to provide all personnel with a means to report faults/request for assistance. What I need to know is - how can I stop a user from overwriting a record or changing a...

I wonder if any one can point me in the right direction for a problem I am having with Public Folders My public folders are mounted and db files in exchsrvr/mdbdata look fine although I have not use eseutil or isinteg on them yet. From my exchange drive (M) I cannot connect to the Public...

Backup Exec 10d SBS2000 - HP Ultrium 230 Whenever I apply an update - I have just installed SP3 - Backup exec fails to communicate with drive. Presumably the SP updates the drivers causing this? But the stranger thing is that neither Microsoft Firewall or Web Proxy services will start until I...

Hello there I wish to create a formula for the following: I have a spreadsheet where one column gives me the date of an assistance request and another gives me the date of completion. For stats: I wish to compare the two columns and produce a third that would say give me an output for a...

Hi there I have established a VPN from one office to another. The main office has a SBS Server on a domain. The second office has a small workgroup - no server. I have connected via the vpn to the main office and mapped a network drive on the PC that is running the VPN. That is working fine...

Hi there I have got myself into a pickle with my exhcange log files. After moving a server and getting disk errors which we corrected we found we could not mount the Public Folders and received error c1041724. We followed various possible solution re file permissions but non worked. At the...

Hello there This is one of those I am sure I have done before but for the life of me I cannot get it right. SQL2005 CRX1 I have a part field and a date field showing the dates that a part has been issued to a job and the cost of that issue. The rpt is grouped on the part number. Therefore I...

XTAL 11 SQL 2005 Hello there, I will attempt to briefly explain my problem - I have 2 reports. 1 is a list of parts required to make a product. (BOM) 2 is a list of the parts we purchased to make a batch of that product. They differ in as much as we may have a number of parts in stock, so...

I am investigating the feasibility of running 10 blackberries for our sales team. At the moment only 2 will get their email that way. We are currently running a SBS2000 server Exchange 2000. I was informed to setup a stand-alone server for the BES by RIM when I spoke to them about our setup...

I currently am running SBS on one server. The company wish to utilise Blackberry phones. I therefore have been advised to setup a stand-alone box with exchange for just the Blackberry software to utilise. My question is - is it possible to install just the exchange server software from the SBS...

Hello there Outlook 2k and Exchange 2k I am having a peculiar problem with one workstation on my network. When outlook attempts to log on to the server - the following error message is generated - Microsoft Exchange Address book cannot log on to the Microsoft Exchange server. No other...

I have a @totalcost formula that simply multiplies QTY against Cost in a daily report of cost adjustments. As some QTY are adjusted down there are some negative costs i.e £-20.05 as well as some positve (£20.00) I wish to simply sum the negative costs in the footer seperately from the...

I have a a drop down list of various names and I need to link each name to a seperate image. I can link the first one but I am unable to link each one seperately - i.e I can only make one link per list box. I wonder if there is a way to have a drop down list and link each item in the list to a...