Recent content by airmojo

Thank you again ! That's what I was needed ! X & O !

On Click Property ? If I can get the 'On Click' property for the 'read-only' data field to react by forcing the tab back to the first data file that would help eliminate the possibilty of the user changing the protected field. I've searched the access help, but haven't found a way ? Is there...

The client is using Access 97, so I set 'Tab Stop' to 'No'. This prevents the tabbing to the field, but one can still just click on the field to get to it instead of just tabbing to it. Ideally, one should not be able to click to the field and enter any data. On the mainframe, we call such a...

Is there a way to display a data field (control source) from a table as a read-only field so that it can not be changed (just viewed) ? And how does one prevent tabbing to it ? I can't see anything in the control source property that would make it a read-only data field. I want to display a...

Ah yes... that works nicely too ! It nice to know both ways. Thank you very much for the help! airmojo

Thank you Mile-O-Phile ! I think I got it ! Is there a way to suppress (make invisible) the data field (LastUpdated) when in datasheet view ? The Visble = No property works fine in Form view, but it still shows up in Datasheet view... No big deal, but I am curious... Thanks again ! airmojo

Setting a date last updated field ? What's the best (and hopefully easy) way to automatically update a special field that contains the date (and possibly the time) of when a table's record has been updated (added or changed) ? This date last updated would not be a user-updateable field on a...

Hi Flyer... I got it now... I was expecting the items to (like magic!), show selected after I moved the mouse over them. Then realized I have to surround them with a 'select box'. I got it now... Thanks! My biggest problem is that I am mainly a mainframe programmer, but I have an access...

Selecting desired report items? Hi Flyer! I can't get the this selection method to work. I'm using Access 97. I did as you indicated, but its not working. Maybe I'm misunderstanding the part about 'left mouse click outside the control on the far right'. Exactly where outside the control ...

Thanks! That's what I needed! --------------------------------------------------------- Is there a quick short-cut key to do a 'Select All' in only one specific section, like the Page Header, so that one can quickly move all selected items at once (without selecting each item by hold the...

Thanks Rich... I guess that works... but looks strange because the report also shows the previous value on the top, followed by the new value. I don't really care to see the prior value (as its on the previous page). Any way to get the report to NOT print the previous value before the new value ?

Is there a way to get a Group data field to print at the top of each page ? It will only print when the value of the Group data field changes, but the users want it at the top of each page. I have a page break in the Group footer. There may be several pages under each value of the Group data...

That was it ! Thanks, I almost went crazy on that one !

Yes, I'm aware of the individual format property, but the problem is that somehow it is being changed globably between the two users who are using the same exact access database. I thought about going through and changing each format property, but there must be a difference between the two...

I have an access system where the dates show up on one user's system in mm/dd/yy format, and on another users's system (same access database) as mm/dd/yyyy format. I figure there has to be some sort of global date format setting, but I can't seem to find it. I would think it would be on the...