Search results for query: *

Hi All I have some Outlook Rules set up that run a script that ive written. The script launches Excel and Updates a number of spreadsheets. We have a slave machine and this allows users to email the machine with a pre set word, this launches the code, updates the spreadsheets, job done. The...

Hi All I have some Outlook Rules set up that run a script that ive written. The script launches Excel and Updates a number of spreadsheets. We have a slave machine and this allows users to email the machine with a pre set word, this launches the code, updates the spreadsheets, job done. The...

All A number of windows updates got applied to all clients yesterday (8 in one day). Since then my clients have all been losing connection through outlook to our SBS2003 server. They are all using cached exchange mode and this didnt appear to be an issue before yesterday. When outlook says...

I am trying to set up some mandatory fields for my form. I have placed the following code in the beforeupdate event Private Sub Form_BeforeUpdate(Cancel As Integer) If Delivery_Cost > 0 Then GoTo end1: Else: MsgBox ("Please enter a delivery cost") Cancel = True end1: End If End Sub this is...

I am using the following function to calculate something called compound deflection in my spreadsheet =(DEGREES('Upright calc'!C$24/CALCULATION!C$141)*1.5) + (DEGREES(H25/D$15)*1.5) This part works fine and will give me a number ranging from between 0 and 30 I then have an And function that...

Hi, after some suggestions on the best way to group data. I have a spreadsheet laid out similar to one ive made up below Orders A B C D Fruit Apple Orange Orange Orange Quantity 5 2 2 2 (above is completely fictional but the best way of explaining what...

I have an access 2003 database that we use to control orders for production and amongst other things also produces order acknowledgements. When inside the order acknowledgement form you have the option to select the name of the person sending the order from a combo box. Once you have selected...

all, i have written the following schema and want to use it to pass the quote value to 2 decimal places. I belive i have the correct code but it doesnt seem to change the number of decimal places at all. It seems that it is ignoring the fractiondigits value. Please help its driving me mad <?xml...

All Apologies if this has been covered by the search function doesnt appear to be working correctly I have a sonicwall TZ170 and SBS 2003 running exchange server, i use POP3 connector to collect my mail from the host. I have recently installed Sonicwall Enforced Anti Virus and Anti Spyware...

All, apologies if this is posted in the wrong forum but it seemed by best chance of getting an answer. I have purchased a linksys network camera which we have currently installed in a reception area of our business. Since the vast majority of people are situated in another office i would like to...

I have emails being delivered into my exchange server from a particular sender. Sometimes the recipient address that they send to changes. I would like all emails from one particular send to go to a designated email address. Anyone know how to do this?

I am trying to develop a forecasting system to bolt onto Sage, i have currently linked all of the required tables and written querys to give a running balance of inputs and outputs. My query currently shows several transaction dates throughout over a period of time, a plus or minus figure...

Hi, i have written a query that takes one criteria string and searches every field returning any records containing that string. I would like to add a second criteria and return any records containing both criteria. Copy of existing query below, please help SELECT TblQuotation.[Quotation...

I have a large database with two distinct tables, one is for live orders and the other for archived orders. The first called TblOrder and the second called TblArchivedOrders. The field names in both tables are identical i.e OrderNumber, Customer, Product. I wish to write a query that will search...

Because of new legislation my company is required to add a sub note to all emails showing our company name, registration number and address. I am using SBS2003 and exchange and cannot find anywhere to do this without adding it to everyones email signatures. Any help appreciated.

Hi, have a recently installed SBS 2003 server. all of my client pc's are using as their DNS server. It seems to take a very long time to display any web-sites. Quite often it will fail to display the web site at the first time of asking. When i switch all of my clients to use my sonicwall...

i am using SBS 2003 as a server and xp pro on all client pc's. all pc's are running outlook 2003. a problem we are experiencing is that at points in the day, outlook will put itself offline. when attempt to reconnect we are prompted for a username and password. when outlook is restarted you can...

I am using SBS2003, i have scripts written to connect a couple of network drives when users log on to the server. I can see that the scripts run and most of the time work fine. Some days though i come in and all of the users have lost their drives. has anyone any idea why?

I have public folders set up to capture emails for my sales team from a generic email address. Once one user has viewed an email in a public folder i would like them to be able to delete it from the public folder so that no other users see it. (save them duplication work). Does anyone know how...

Hi, i have recently installed exchange 2003 and have about 20 users set up and working ok. For a number of my users i would like them to be able to send out from the email address sales@domainname.com. All of my users are set up with addresses under their own name and i would ideally like to...