John Clark
John.Clark at niagaracounty.com
Tue Mar 12 13:56:56 CDT 2013
Little Problem fix...I think. It occurred to me, immediately after sending my message, that I do this very thing, earlier in the voucher...include a number w/my text. So, I looked at what I'd done up there and saw that I just used a "Str()" command. I'd thought I'd tried that though...well, it worked this time...maybe I had a mix of issues at one point. So, I'm just down to the duplicate number issue. This is a huge issue...BUT...at least it is one issue only. And, worse comes to worse, we can still go live...we'll just have to be careful. And, if some does happen where we get a duplicate, I should be able to get it out myself. >>> "John Clark" <John.Clark at niagaracounty.com> 3/12/2013 2:49 PM >>> I've had this program in the users' hands since last week. They were to run it through some tests, and we intended to go live on Wednesday...Tomorrow! In their testing, they found two things...one that I just didn't think of, and another that I overlooked...a problem I knew about at one time, and just glossed over. In my defense, this is the program, if y'all remember, that I wrote 3 yrs ago, and they're just now getting around to using...I may have even had a fix out there at that time, but have now forgotten about it. Big Problem first... When a user goes into this application's main form, they enter a witness' name, and at that time a voucher number is created...basically sequential, built off the date...if I did one now it might be 130001, the next would be 130002, all the way to 139999, and then in 2014 the numbers would start anew. During testing two users went in at the same exact time and both began entering a voucher at the same time. It assigned 130009 to both of their subjects. This is a problem for more than one reason. First of all, we just can't have it. But, if we could get over it, it only prints the one record, even though they are both in there. This number is assigned right away, but it isn't in the DB until the record input is complete. So, in the minute or two that one clerk is entering data, another could very well get in and grab the same number...the previous not being "dedicated" yet, and the latter would gain the same number. What I am thinking of doing...I'm trying it as soon as I'm out of this email...is to hold off on assigning the number until the record is done. But, I wanted to put this out there and ask for your advice. Littler Problem now... The whole purpose of this DB is to create a printed voucher for a witness to take to the treasurer's dept and get paid for their time and mileage. Way back w/I was first doing this, someone right on this very list gave me the idea of putting all the text together via code, and then printing out the sections of text. This worked awesome actually and I'm happy I went that way. But, it my final section it is suppose to include two numbers...mileage and amt owed. I, for some reason, am unable to mix these...text and numbers...type mismatch. Here is the code... '************ Setup text for 5th paragraph P5 = "I, the undersigned Clerk of Niagara County and the aforesaid court, do certify that " P5 = P5 + [txtWitFName] & " " & [txtWitLName] P5 = P5 + ", attended 1 day(s) upon request of the District Attorney and traveled " 'P5 = P5 + [numMileage] P5 = P5 + " miles. Said witness is entitled to a sum of " 'P5 = P5 + [curMileage] P5 = P5 + "payment in full of witness fees." The problems come on the 4th...and I'm presuming the 6th...lines. Later, when I put it together, the final line of that section reads, "Me.lblParaFive.Caption = P5" I'm sweatin' it a little bit here. I am at the end of my day, and they'll be running these at around 10:30 AM tomorrow. I'll probably stay a little later tonight...OT is frowned upon though (don't ask), so I don't know how that will go either. Any help will be greatly appreciated! Thank you ahead of time...John Clark Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation. Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation.