Search results

Could you explain how to do that?

I have tried using the HTMLBody code to do something similarr but having issues with it as there is 128 lines of html. Any ideas how to get around this: The HTML is as follows: <style type="text/css"> <!-- #Heading_Text { font-size: 18px; } #oraclecommcentre { text-align: center; }...

Out look opens the oft template but does not replace the placeholder text at all. No errors or anything like that.

I am trying to create an email from an oft templaye and replace certain part using the replace() function. I can get the email to open up but not of the replaces are working. Can anyone off any help? Dim myOlApp As Outlook.Application Dim MyItem As Outlook.MailItem Dim objDoc As Object...

I have two tables one for employee information, the other for salary. The two tables are linked via ID. The salary is constantly updated after each wage review. What I want to do is pull a report that shows the employee name and the last record for that employee in the salary table. Any...

Works great thanks :)

I have been give a lot of data that is very badly formatted in an excel sheet. It is formatted across two columns A and B. Name: Name1 Address: Address1 Phone Number: Phone1 Name: Name2 Address: Address2 Phone Number: Phone2...

That works and calculates correctly :)

I dont think so as simply changing the formula back to =sum it calculates correctly and shows the 0.5

Actually no it is not working. It seems to be only counting one of the values. For example one of the records has 19 and 0.5, 0.5 was the last one entered and its only including that in the count. When it was =sum it would show 19.5. Anything else I can try?

Cheers worked perfectly.

I have a text box that counts the number of days from a selection. The problem is if there are no values in the range the box remains blank. What I want if there are no values to sum it will = 0 I have tried the following but it does not seem to work: =Sum(NZ([No of Days],0))

I have a table 1 and it has a number in it. Table 2 that has 20 numbers in it. I have a form that has a box with the number from table 1. There is a second box that has the total of all the numbers in table 2. I then have a third box that calculates box 1 - box 2. The result that is in box...

If the back end is on a server I am assumin it is a server all the clients can access? If the back end is on a server I am not sure what you are asking about packaging the back end this should be placed on the server no need to package it at all. It does not matter where on the client machine...

Is the back end hosted locally or remotly to the clients machine?

I am looking to have a button that transfers all records from one table to another. Basicall I have Table 1 and Table 2 When the button is pressed I need it to move all the records from table 1 to table 2.

Nope made no difference. I am waiting on my client getting back to me once they have spoken to the sender.

I have recieved an email from a client that is .zipp - yes double P - I have tried opening it with Winrar and winzip with no luck. Any ideas what to open it with?

Yes I understand but the issue is all this data came from different excel sheets. Table 1 Have some companies duplicated as I have 2 - 3 contacts within that company. I am just trying to join all the tables to create one to import into the our CRM

Yeah that is what I have: SELECT [Company List].Company, Industry.Industry, Country.Country, Source.Source, [Company List].Status, [Company List].[Call Comment], [Company List].[Data Change], [Company List].Contact, [Company List].[Job title], [Company List].[Main No], [Company List].ddi...