Recent content by bfollowell

I am having trouble getting a report to return the correct results. I am developing reports against Maximo, a computerized maintenance management system my company uses. I’ve used Access as a front-end reporting db for years but after a recent upgrade to the main maintenance db and some more...

Everyone please disregard. I changed my whole incrementing/error trapping code into one like the code below and everything works perfectly now. I'm still not 100% sure why this works and some of my other attempts didn't but I really don't care at this point. Everything is working perfectly now...

Bob, OK, the OnDirty event didn't do anything for me. I messed around with the other events though and found that the BeforeInsert event worked well for me. My button is invisible until a new record is created and someone starts to enter data, preferrably an occurrence date. Then the Create New...

Oh, OK, I think I've got you now. I'll have to play some more. Always learning, always learning. Thanks so much for your help Bob. Sincerely, - Byron

Bob, Thanks for the reply. I see what you're saying. I know how to make visible true or false or enable true or false but I need a little more. How to I make visible true or enable true ONLY when creating a new record? I wasn't planning on recreating command buttons for creating a new record. I...

I have a db that I've developed to help members of my maintenance department create major breakdown reports. We have a numbering system for these major breakdowns that is made up by XX-YY-999, where xx is a two character system code, YY is the two digit year and 999 is the 3 digit number of the...