Search results for query: *

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

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

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

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

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

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

Hi I want to run a sql query against an MS access database and then pass some of the slected values through a Com Object into a SQL Server Database. As I am a little green around the gills, could anyone point me in the right direction. I was considering an ADO connection to the MS Access...

Hi Folks I am trying to create an MS excel Query which uses the cell references in an Excel Spreadsheet. I have no problem running the parameter query with 1 or 2 cells, but my source spreadsheet will have a variable range of cells, greater than 30. Could anyone tell me if there is a way to...

Is it possible to use a query in a MS Access database, to pass values to the parameters in a SQL Stored Procedure, on a SQL Server 2000 Database. If so, could anyone point me in the right direction.

I've recently developed an Access 2002 database for storing contact details. However the people I have been developing the database for, use Access 97 SR-1. The actual conversion went correctly and the database will infact open on the clients network, however on the one form (where contact...

Could anyone help me with the following error message I have used the add-in manager to put the Data Form Wizard on my Addin Menu. If I set up a connect to the Biblio.mdb and run the application I get the following error message. "Compile Error Procedure declaration does not match...

Can anyone help me on the above question. I am trying to produce a data entry form, with the Main form(1) containing the header details, Number, Date etc. The subform will contain another main form(2) and subform to contain a page number in the header and the data entry screen in the subform...

I have a database containing user details category type firstname lastname Initial Some of the fields will contain Nulls The user enters the criteria for the query from an Access form, but may not enter values in all fields. How do I get the query to return all the data even when one of the...

How do I get a text box to look up a record from a database, when the text box gets focus N.B. The record is a single field in the database Wotrac

I have a form with a memo field. The user wishes to enter text with a mixture of spaces, carriage returns and tabs. Problem is when you use the tab key it exits the field. I have considered using an alternative key ( say F12) but am unsure how to go about it, as my vba skills are limited...

I have a form with a memo field. The user wishes to enter text with a mixture of spaces, carriage returns and tabs. Problem is when you use the tab key it exits the field. I have considered using an alternative key ( say F12) but am unsure how to go about it, as my vba skills are limited...