I missed this thread a while ago - but if it's worth anything, i thought the previously mentioned "Psst" was great!

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

We're thinking about changing the name of our company from Prestwood Software & Consulting to just Prestwood Software. The original thought behind the longer name was that we wanted everyone to be able to identify by our name that we are a consulting firm and software maker. The reason we're thinking about shortening it is because it is shorter. Prestwood Software & Consulting is harder say, longer to write, etc. So the central question is, "Is the '&Consulting' required?", , Any thoughts?

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

Are they actual scaled down images or is the app resizing the full images down - the filesize alone of some large .bmp files can easily be > 1mb.

Posted to MB Topic: Just Conversation « PrestwoodBoards Board

If you add the expression:, , =count(PersonField), , in the person fields grouping footer, it will relay the proper results despite of the number records in the detail section., , Note that this will only work if your database is normalized properly - if all of these fields belong to one table then you will need to use a query like jd described.

Posted to MB Topic: Access VBA Programming « Access Board

I have a report grouped by state,location, and person. Each person may have more than 1 record. How do I count the number of people at a location? If I do a count on the persons id field which is in that group header it still counts their detail records. So if I have 3 records, two belonging to John Smith, and one to Martha Helms inside of a location, I get a count of 3 people, even though there were only 2. Help (I am sure I am missing something easy)

Posted to MB Topic: Access VBA Programming « Access Board

On the table level, this is not possible using only a single field to record the IP.. you could use 3 fields and validate >=0 and <= 255, , On form level, it would be a small check onAfterUpdate of the field.. grab each number (since they're seperated by .'s), and validate.. accept only a correct value. This of course would require a moderate knowloedge of vba., , If you're new to access, split it into 3 fields, it won't clout the db and since it's an IP, won't violate any of the rules of norm., , HTH

Posted to MB Topic: Access VBA Programming « Access Board