Search results for query: *

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

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

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

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

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

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.

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

I have a situation where we have a remote office and we want the staff to be able to enter complaints (and their subsequent resolution)into a database. Note that this office is not connected to our lan. We want to be able to view the information on that database at the home office. I am...

I am attempting to track employee sick time using a Microsoft Access Database. The purpose of the tracking is to provide reports indicating the number of sick days and the number of sick turn-ins for each employee. (A turn-in is an unbroken sequence of days out sick. The weekend, or a holiday is...