Recent content by grendal

I've just migrated from ALT-N's MDaemon to MS Exchange 2003. One of the good modules of MDaemon was the ability to append text to outgoing messages. I've tried without any sucess to find a similar option. Does this option exist within MS Exchange 2003? Cheers s-) Some girls mothers are...

I've moved our compnay users from an Outlook Internet Mail service to an Outlook MS Exchange mail system. All is well except a percentage of the (internet mail) will not open. The message displayed is 'Can't open this item. Operation failed.' I've reinsatlled Office 2003 twice without any...

Whoops - forgot to say thanks. Great tips! Cheers s-) Some girls mothers are bigger than other girls, mothers. (The Smiths)

HI, I've a formula as follows:- =([JANSALES]-[JANCOST])/[JANSALES] This caluculates the profit margin on a Sales report. However when faced with either or both fields containing zero's - I get the #NUM! error. Is there a way around this. Cheers s-) Some girls mothers are bigger than other...

I have a report which lists stock tickets bassed on status, with a value for each ticket. Where I have a negative status e.g. Missing Stock, how can I make the value of that status group report as a negative value, ensuring my overall stock value is not over inflated. Cheers s-) Does the body...

Trying to get my head round this problem. I've created a customer account sub form with 12 sales period columns, each of which has a column total within the forms footer =sum([Period1]). When the subform is viewed on its own, the total works fine. However, when I place the subform into my...

I've just created a new entry into my form. When I select my command button to print preview this particular entry, my report opens, but does not contain my new data. As this command works O.K. for existing data, I assume I need to update the form somehow. My existing command is as follows:-...

I know how to count the number of cells in a range that contain a letter. But, is it possible to count the number of cells in a range that are formatted, say, yellow?

I manage 65 pcs on my network. All users log onto a domain on a NT4 server (which contains a logon script). 3 win98 pc's logon onto the domain succesfully, but cannot be seen via NN (network neighbourhood). These machines have access to all domain services and can also see other users via NN...

Hi Bryan, when I've added your code, I receive a compile error on line 4. On your earlier point, er, maybe I am tackling this in an over the top way. Short term I'll use another method I've been playing with, as I need to complete this today. Long term, I'll continue with the direction you've...

No, there linked by the customer account number. The 'call number' is an auto number within the 'call detail' form. Cheers s-) Does the body rule the mind or does the mind rule the body - I dunno!

OK, I've a form called 'call form'. This contains static customer account details such as name, address etc. Within this form there is a subform called 'call details' which contains the details of calls logged against each customer account. Each call has a unique log number. I've created an...

The form I'm opening the new form from, is called 'call form' which has a subform called 'call details'. The 'call number' field is held within the subform. Cheers s-) Does the body rule the mind or does the mind rule the body - I dunno!

Thanks, for the above. However I'm now receiving the following error "You can't assign a value to this object". If it helps I've included the code below! Private Sub New_Customer_Click() On Error GoTo Err_New_Customer_Click Dim stDocName As String Dim stLinkCriteria As...

Thanks for the reply. Unless I'm missing something I can't see an option for a scroll bar within the field property for the web page - apart from what colour I wish to choose. I know how to select the property when designing a form, just can't find it for a web page. Any more suggestions...