Search results for query: *

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...

This happened to me back in October. The situation was that I got a new computer at work and they load Access 2000 on all new computers. Since we have a lot of applications still in Access 97, they had to load it also. There were the usual Access 2000 & 97 on the same computer problems that had...

I have created an acess database that is to be used by 4 users (including myself). I placed it on the network in a secure folder in which the 4 people have access, thus eliminating the need to use access security, of which I know absolutely nothing. I have done this in the past without a problem...

I have a database that contains a table of individuals. I would like to send Email messages to all, or select individuals within the table. Can anyone advise me on the best method to perform this task. Your help would be greatly appreciated.

Thanks, but If I do that, I will have to change the default value every month. I want to be able to enter the date on the form one time and then be able to enter the copy count for each copier. Any other ideas? Joe

I am creating a database to track copy machines. Once a month I must report the number of copies each machine has generated. I have 2 tables - Copy Machine Table - with all of the copy machine info (serial#, Manufacturer, Location, Etc) The second form is Copy Count (Serial#, Month end date...