Recent content by mpadgett

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.

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

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.

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,

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,

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.

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

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

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

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

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

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

What Mac computer do you guys use?

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

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