Recent content by dwichmann

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...

thanks for the help. just what i was after

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...

hi all, thanks for your help but the problem seems to have corrected itself. A very strange problem indeed. The 0's and 1's were only ever 0's so they didnt translate to true or false. As i said i have gone in this morning and the issue is now reporting true or false. Nothing has been changed it...

thanks geoff my AND formula is just =AND(G25<1,J25>180,I25<1) where I25 is the result of the degree formula

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...

Thanks for response, completely agree with structure, would never do this myself and is indeed very bad practise though not an option. I have now achieved what i wanted using a series of Hlookups.

i realise this, its a costing spreadsheet ive inheritied. Unfortunately its huge but the number of types is never greater than 8 so limitations are not a problem. Changing the structure is simply not an option. Any suggestions other than this are greatly appreciated

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...

thank for the help both, i will give it a go. i am using the schema to export the data out of excel and into a different application.I have tried formatting in the data in excel before exporting it but it doesnt seem to make any difference. i will keep you posted, thanks for the help.

apologies i wasnt aware of that, not sure if your able to help me. I wrote the schema to allow me to export entries into an excel spreadsheet in xml format. I have formatted the excel spreadsheet but when i export in xml it gives me full values where i would like them rounded to 2 decimal...

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...