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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mpadgett

  1. mpadgett

    Considering Infopath

    I've never used Infopath and am just learning about it. I'm wanting a way to easily create data entry forms for users to enter data into a SQL database as well as run pre-created reports or views of the data (possibly web based). Would Infopath be a good solution for that? The DB is SQL 2000.
  2. mpadgett

    Using Worksheet_SelectionChange

    Skip: You're correct. My appologies! Your code works beautifully. Thank you,
  3. mpadgett

    Using Worksheet_SelectionChange

    Your MsgBox is only being activated when I select all cells from F4 to F30. When I select anything less that that, I get nothing.
  4. mpadgett

    Using Worksheet_SelectionChange

    I did try and your code and it worked perfectly if I select all cells from F4 through F30. As I mentioned in my reply, I'm actually wanting to evaluate if a user selects a cell within F4:F30. Thanks,
  5. mpadgett

    Using Worksheet_SelectionChange

    Sorry, I meant to state that I need to identify if a user selects a cell within F4 through F30 not all of the cells from F4 through F30. Thanks,
  6. mpadgett

    Using Worksheet_SelectionChange

    I'm trying to use Worksheet_SelectionChange to identify if a user selects cells F4 through F30 to thus execute a macro but I'm having some difficulty with the syntax to define the F4:F30 range. Thanks for any help.
  7. mpadgett

    Read Only Access

    The company I work for is moving off of its current business software to a new one. The current application runs on SQL 2000. We want to leave the server and the application active just for referencing history data. What would be an easy and suitable way of rendering the database read-only...
  8. mpadgett

    vlookup #N/A error

    The culprit was as you mentioned. Trailing spaces! Thanks,
  9. mpadgett

    vlookup #N/A error

    I was wrong, the (') didn't work.
  10. mpadgett

    vlookup #N/A error

    In addition, if I preceed the data in column 1 of the table_array with a single quote (') the lookup works.
  11. mpadgett

    vlookup #N/A error

    I can't figure out why a vlookup formula will not work. I'm getting #N/A errors. I've used vlookup numerous times but never had this big of a challenge. It's almost like a data type problem. In the table_array, I have alpha-numeric data in column 1 and numeric data in column 2. I've changed...
  12. mpadgett

    InDesign on a Mac MINI

    My thought was to use a MINI (as I spec'd earlier in the thread) if it was going to perform adequately. And me not being a Mac or a CS user, I don't have a feel for how it'll perform. I'd probably be agreeable to an iMac also. Their specs are actually close to the MINI. They as well as the...
  13. mpadgett

    InDesign on a Mac MINI

    What Mac computer do you guys use?
  14. mpadgett

    InDesign on a Mac MINI

    Wow, it's interesting how this thread has transformed from its original entry. I do appreciated all of the replies though. It is helping. We know that the work can be done well on either platform (Win or Mac). Fundametally, I don't care what platform my wife uses. I'm just trying to be...
  15. mpadgett

    InDesign on a Mac MINI

    Well, she says she doesn't want to have to learn anything new (relative to changing to using CS on a Windows based machine rather than a Mac). It's crazy though, at least to me, because she uses our Windows laptop and Windows desktop at home to do Facebook, Internet and email & such and from...
See more

Part and Inventory Search

Back
Top