Paul Hartland
paul.hartland at googlemail.com
Tue Mar 12 14:01:58 CDT 2013
I was going to suggest cstr() (well that's if it exists in access, been doing VB6).....The number issue I used to have a table (tblNextID) with just one field say called NextNo when they start entering a name grab the number from the table then increment the number in the table straight away. On 12 March 2013 18:56, John Clark <John.Clark at niagaracounty.com> wrote: > 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. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- Paul Hartland paul.hartland at googlemail.com