Search results for query: *

Hi, I am creating a form in Excel to enable easier searching for users of the spreadsheet. I plan to have 3 combo boxes on the form. The first combo box will be populated direct from the data in the main spreadsheet, with the other 2 combo boxes populated dependant on the data filtered from...

Hi, I have been handed an Excel 2003 spreadsheet which contains several worksheets with one worksheet used to display data simply as a Yes/No entry. The users of this spreasheet would like to see the additonal information for each piece of linked data displayed using the 'Comments' function if...

Hi, I have created a form for inputting data to Excel 2003 and I am now adding some basic features. The feature I would like is a button on the form that will move up 1 row at a time and display the data on the form for the user to review. Appreciate any help.

Hi, Using NT4 server, Exchange 5.5 SP4 One of my users has an issue with an email they sent out to a bunch of contacts. The email went to most of the contacts but an NDR keeps getting sent back for 2 of the contacts because their email addresses appear to now be no longer valid. The strange...

Hi, Using Access 97. I have a field in a database that has been populated from unknown means by persons unknown :| over several years. The issue I have is that this field now needs to be split into 3 separate fields. The data is in a very rough format of Alpha/Numeric/Alpha, e.g. WAR26A...

I have an Excel 97 sheet that contains several thousands of numbers that should all be to 1 decimal place (e.g. 2.4) The issue I have is that some of the data has been copied in from other sheets and it does not follow the decimal place rule, you can change the format and it looks correct but...

Hi, Using Excel 97. I have several form and 1 of the functions I have included is the ability to email a specific worksheet to soemone. This involves copying and pasting the required sheet to a new workbook and then sending the new workbook by email. All of this works perfectly :) The...

Hi, Using Excel 97. Simple question I think :|, is it possible to set the position of a message box. I am trying to get the message box to display on screen so that it does not cover over the user input form that is displayed in the centre of the screen. TIA

Hi, Using Excel 97. Using the following code for a user form and for the buttons on the form. Private Sub CancelB_Click() unload Me End Sub Private Sub ClearB_Click() Call UserForm_Initialize End Sub Private Sub OKB_Click() ActiveWorkbook.Sheets("SectionB").Activate Range("A1").Select Do...

Hi, Using Excel 97. I have several forms used for data input. On 1 of the forms I need to have the running total displayed which updates when each new record is input, the running total is referenced from one of the worksheets. I have tried using a Label to display the total, this does...

Hi, The spreadsheet I am working with has a large number of empty rows. As the sheet is sent to me and it is made up of several other imported spreadsheets so I never know how many blank rows I am going to have. I know that the cells in column A only every contain a serial number and are...

Hi, I setup some forms in Excel to be used as data entry, all of the forms work fine and the data is entered on to separate workheets as required. What I need to do is to be able to select parts of the different worksheets and merge/copy the information into an empty worksheet so that it can...

Hi, I have a database that runs a query from selected user input and displays the results of the query in datasheet view, when the user clicks on a record in datasheet view I am trying to get the record that is clicked on to be displayed in a form. I have got the form displaying but it just...

Hi, I have a form that has several unbound combo boxes on it, the values from the combo boxes are transfered to a query that is run when a report is actvated. Everything works okay when all of the combo boxes have a selection made in them, however I need the query to only take the completed...