John Clark
John.Clark at niagaracounty.com
Wed Dec 23 09:17:08 CST 2009
Like I said, this project I am doing, is really the first one for me, for Access 2007...I did something really tiny, earlier this year, but that didn't have much code at all. So, even though I am not completely finished, I had a date w/the user...the District Attorney's office...to show them the program, as it is now. I was very embarrassed, when things weren't working. I had no clue why, but after you put in the date, the first thing that should happen is the mileage rate is filled in, and that did not happen. That has worked for about a week now, so why it wasn't working all of the sudden, was a complete puzzle to me. I moved on, assuring them I'd fix this pronto. Then I get to the actual voucher (report), which again was failing on every calculated field. I had just run through this, before going over there, and I was confident it would work fine. Anything I have left to do, wouldn't be a big problem...the auto numbering needs to be done, but the number is there and I just say, "I'm working on this today"...and the dollar amt on the report is not in currency form..."I'll fix that!" But, the meat of the program was looking great...until I showed it to them. This time at least, I got a clue...the bar across the top saying something about disabled content. So, I quickly realize, "Microsoft is trying to protect me from myself again!" I find a place where I can trust my network drive...of course this is "not recommended"...and I add the network drive, and voila! it all started working. I still had one little glitch I don't understand...because it works on my PC...but at least I showed them what was going on and didn't end up looking like a totally incompetent idiot.