Recent content by jocat

Ken, The reason why I want to save both is because in the past we referenced the violation type table to access the violation amount when we were providing a violations listing. We recently increased the fines, so when we printed out a history, all of the old violations came up at the new rate...

Thanks Aceman. I did see one of your posts when I was checking out PHV's postings. I did use your format and it worked fine! And thanks for your response also, Ken Joe

Thanks for the info. I looked at a few of your other posts that provided a little more detail and was able to get it to worl. Have a great day. Joe

Hello all. I haven't been around for a while. There is probably a simple solution, but I don't work in Access every day, or perhaps I'm brain dead today. I have a database for parking violations. I have a parking ticket entry form with a combobox for the violation type. I want to store both...

That did it. Thank you, thank you, thank you! Joe

One more question. How do I exclude the bracket [ and the asterisk * . it is not recognized when I insert Not Like "*[*. Joe

Now why didn't I think of that? I keep telling them that I am overworked. All if my input is through forms. I just didn't mention the form in my request. Thanks! Joe

I am updating a database that contains license plate numbers. A common data entry error is to include spaces or dashes in the license plate number. I want to format the text field in the table so the clerk cannot enter spaces or symbols in the field. The field size is 8 characters. When I tried...

GingerR I won't freak out. I do use VBA but have to refer to the books because I don't program often enough to retain it in memory. I will give it a try and let you know how I make out. I'm swamped with a lot of other stuff, so it might be a little while. I'll bet you know that routine. By...

I have a database in Access 97 that records parking lot violations. Within that database is a violations history report that I must occasionally submit to a towing a towing agency that I email in MS Word. I normally save the report as an RTF file and then email it, but I want to automate the...

It worked. Thanks much. I will record this in my reference file so I don't forget again (I'm getting old). Jocat

I am working on a database to track invoices. I have created a form for data entry of new invoices and editing of existing invoices. I have placed a "Save Record" button in the form footer. I want to require that the entry clerk use the "Save Record" button. The problem is that when the enter...

Actually, now that I look closer there are currently 6000 tickets in the series. The range is 255501 to 561501. Joe

Tickets are constantly being entered. It is better to say that the ticket numbers are greater than 200000. Joe

I maintain an Access 97 database for parking violations for the parking lots of a Public Transportation Authority. I have a table of all parking violations with the ticket number as the primary key. The tickets come in books of 25 tickets and are submitted to the office for data entry. There...