Recent content by bacardi451

Hi, I have a form that has the following fields: Date, Name and Score I am trying to build a query using the date and name field. I have figured out the criteria for the date which is Between [start date] and [end date] but cant figure out the name criteria. I just want the person to be able to...

Hi, I am trying to build a querie from a table. The form is a vessel tracking database. which contains Vessel Name, Type, and Id number and date enter port and date left port. As the vessel goes in and out of port a record is made everytime. I have one vessel that are in 6 records with diffrent...

I have a form where I have a "case no." field. what I would like to do is to have a event procedure in the field to check if the case no. was taken already (duplicate) the field already is set to unique in the table. I have search everywhere with no luck. thank you AL

Thanks that work great. Al

Hello, I did a search on this topic but with no avail. I have a command button that is used to email a report. I would like to add a yes or no msg box to that command button. when the user click on the command button I want the msg box to ask if they are sure that they want to send an email...

Thanks those codes worked like a charm. Thank you Al

I have a form that has to fields. One is a BPMC score field and anotherone is Bpmc qualified field. The score field is numeric max is 3 numbers the qualified field has a dropdown box that has menu with three choices. example: Marksmanship Sharpshooter Expert What i...

Thank you very much. That work like a charm. Al

I cant get it to work. where should i put the code? Thanks in advance Al

Hello I have a database that keeps record of test taken that are valid for 6 months. I have to fields one is the date tested and the other is expiration date. I would like to have the access automaticly put an expiration date for 6 months from current date. Example date tested - 02-Nov-02...

Thanks. I tried that but it does not work. Al

Hello, I have a database that is used for tracking the truck that go out to a job site. on the form there is a checkbox that is selected when a truck is out if it is in the checkbox is deselected. I want to generate a report that only give me the list of trucks that are out according to the...

I have built a database in access 2000. I have a form with a subform. The subform is for logging information. It has Date, Time, and a Memo box where a member buts in there text. Is there a way to put a command button on the form and have a certain text behind it, so when a member clicks the...

Hi, I have created a custom date and time format (MM/DD/YYYY HHMM) I am trying to get the default value to put the date and time when someone puts in a new record. I have tried the Now() in the default value and it gives me the date and time but the only problem is that it gives me time in...

Hi, I have a form that i have built thru a query I have a print button that prints the report for the form. There is a date text box were it has "mm/dd/yyyy - mm/dd/yyyy". Evertime I print, It request the date thats in the box. I was wondering if there is a way to make it print without asking...