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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: Daya100
  • Content: Threads
  • Order by date
  1. Daya100

    going from form to form

    I have a database and there are about 10 different forms the user goes through to enter information. Right now I have command buttons on each form that the user clicks on to go to another form - and whatever record they are on in the first form - it finds it on the other form. The code also...
  2. Daya100

    repeating

    Hi, I'm trying to repeat the code below for several different cells. Everything stays the same but the cell (range) changes and msg - there are about 20 different ones. I could just keep writing the if statement over and over but I know there is a better way. I was thinking case select...
  3. Daya100

    excel get cell value

    I tried to get help last week and it didn't quite solve the problem. So - now I have a new approach that doesn't work. I'm trying to add cell values to a collection. But, I keep getting the error that the subscript is out of range. Here is my code: Private Sub UserForm_Activate() Dim...
  4. Daya100

    list cells in list box

    I have a userform in Excel that loads on the workbook before save event. I want it to list (in a list box) all of the cells that I have specified that are null or empty. Thanks to Skip I know how to evaluate if a cell is empty. But, there are a good 100 cells that I need to look at - and if...
  5. Daya100

    if cell is empty in excel

    I'm trying to identify when a cell has not had information entered so that I can give an error. I have tried using IsEmpty and IsNull but nothing seems to work. How do I do this? Thanks! Daya
  6. Daya100

    VBA logic test in Excel

    I'm really an access programmer and can't figure out how do do anything in excel. Basically, I want some code that says if A1 + B1 <> C1 then... - I know how to put in the message box. Also, how do I require a field? SO they can't save or move to another sheet if the cell is empty. I...
  7. Daya100

    format number

    I'm trying to format a number so that it is 4 characters long. For example 1 would be 0001 and 15 would be 0015. How do I do that? Thanks!
  8. Daya100

    VBA help

    I'm somewhat of a beginner with VBA and desperately need help. I have a form in my Access DB and have a button to create a new record in the table. I'm having trouble putting together the unique ID. Once the user clicks on the new record button then I have an input box to prompt them for a 6...

Part and Inventory Search

Back
Top