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

This spreadsheet has multiple rows and uses columns A - G. The button on the form when pressed will move the focus up one row from its current row, which could be any row in the sheet, thus displaying the information on that row from column A to G. The Userform will be refreshed to reflect the...

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.

Checked the Outbox first of all, the rogue message appears to possibly be in the Exchange database somewhere and just keeps sending every 20mins.

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

Thanks for the repsonses. I used the left/mid/right commands suggested by PHV in a select statement which populated the new fields. Easy enough to do once the data had been sorted out in to some sort of consistent pattern!!!!

Thanks for the suggestions. I have manually :( updated the fields so that the data is consistent as this seemed the quickest way. All I need to do now is to split the single field into 3 separate fields. Any suggestions on the best method on how to achieve this in Access 97? TIA

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

Thanks for the reply dhulbert but your suggestion doesn't seem to work for me, getting problems with the 'set' command you suggested. Any other ideas?

Hi SkipVought, Thanks for the reply, the line you have specified is kind of redundant as it just activates the sheet I am copying from and is not really doing much. As I said the copy/past/email works on the first click of the button, but if you try pressing the button again I get an Error '9'...

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

Thanks for the reply's. Didn't need to re-position the message box after all as the end user wanted the message box to appear over the input form so the user had to confirm or reject if they had reviewed the input in the form. In both instances either Yes or No the message box is terminated so...

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

Thanks for the response, works a treat. Have a star

hi xlbo, The code for the form and the 3 buttons on the form is below: 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 If IsEmpty(ActiveCell) =...

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, Thanks for the response SkipVought. I really want to do this automatically by using a macro or something. Basically I just want to strip out all of the rows that do not contain any data. Don't know if there is a way of doing this :|