Search results for query: *

Hi The report is designed to display the values from a project, by costcentre. The costcentres are grouped by type SALES COSTS LABOUR OVERHEADS When displayed on the report I wish to show the subtotal for each group when displayed. In addition I wish to subtract the value of COSTS from the...

Hi I am trying to create a report that has 4 groups. I want to subtotal group 1 and 2, and then take the group 2 value away from group 1. I then wish to take this new value and carry it forward, so that when I have subtotaled groups 3 and 4, I can take their value away from the first. A bit...

Andy Could well be as I wasn't involved in the setup. I will take a look. Question? Is there nothing I can do by copying the .ost file between my laptop logon profiles.

Hi Yes we are running exchange 2003 at work. I already have access to OWA, but this does not appear to give me access to the shared office diary. Unless we have not got it set up correctly? Paul

Hi I have an exchange mailbox at work, which I access from my laptop when I logon to the domain at work. When I go home I logon to my laptop as the local administrator, which at present doesn't have a mailbox setup. The outlook.ost file is located in my work profile. I now have a broadband...

Hi I have an Access table containing over 10,000 Customer records. The SURNAME field contains hundreds of the same Surname eg Jones, Smith etc. I want to suffix the Surname with a number and increment this for each field where the surname is the same, only resetting when the Surname changes...

Thanks for the advice

Sorry for being ignorant, but what is an evensink and where can I get info one them

Hi can someone advise me of the best way to achieve the following. I want all employees in the company to have a standard message at the bottom of all e-mails they send out. Ideally I would like the message to contain there name and e-mail address as well. Is there a way of setting this up on...

Thanks I never thought about doing it that way, I was obviously making it too hard for myself. Paul

I have a workbook containing only 1 worksheet. When I open the workbook, it automatically adds a number of worksheets based on a recordset obtained from a database. I want to be able to delete all of these new worksheets, when I close the workbook, leaving only the original worksheet. Can...

Sorry if my description was a bit vague. I was trying to run the code in the module from the combo box on the spreadsheet. It turned out that I had declared my procedure as private, when I changed it to public it worked fine. I wanted to know if there was another way to achieve the same result

Hi I have created a new module in Excel, containing code for data access. I want to put a combo box on the first sheet in the workbook, which will display records returned from the accessed data. How do I reference the Procedure in the module from the combo box.

Can anyone give me a kick start on this one, as I need a bit of help. I have a recordset which may contain anywhere from 3 to 6 records. I want each record to be placed in a seperate worksheet in the same workbook. I know how to get the data from the database, but exactly how do I loop through...

Thanks Thats the bit I wasn't sure of. Paul

Hi I am on a VB 6 platform. I only mentioned the word recordset, as I assumed this would be the most obvious way to return the result set to the list box. On that note, if I populate a recordset with a result set from a database. Can I still use the values in that recordset, if I close it...

Hi Folks I am a novice programmer who needs a bit of direction. I am developing an application which will query a SQL database and retrieve a list of stock codes, which will be used to populate a list box. This routine will be performed several times, while the application is opened, but may...

I have a reasonable working knowledge of SQL queries and Stored Procedures and a basic understanding of XML. What I want to do is extract data from SQL server and output it to XML using a predefined XML Schema for Validation, but am not sure where to start. Could anyone suggest where I should...

I need some guidance on whethern the following is good programming practice. I am running a SQL query to extract data from 2 MS Access tables. tblORDHeader tblORDDetail This information then needs to be passed to a Com object to insert into a SQL database to generate the same information, in...

Sorry it has to be Com due to the nature of the SQL database and the business rules that apply. I have used an ADO recordset to solve the problem, but thanks for your response, it was appreciated. Paul