Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cmonthetic

    Combo Box Duplicates

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

    Auto Update Comments

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

    Cycle betrween rows

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

    Cycle betrween rows

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

    Email keeps trying to send

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

    Email keeps trying to send

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

    Split field data into 3 seperate fields

    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!!!!
  8. cmonthetic

    Split field data into 3 seperate fields

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

    Split field data into 3 seperate fields

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

    Replace Numbers

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

    Book1, re-use?

    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?
  12. cmonthetic

    Book1, re-use?

    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'...
  13. cmonthetic

    Book1, re-use?

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

    Positon of Message Box

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

    Positon of Message Box

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

    Check form input

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

    Display a running total on a form

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

    Display a running total on a form

    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) =...
  19. cmonthetic

    Display a running total on a form

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

    Delete Rows

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

Part and Inventory Search

Back
Top