Search results

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

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

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

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

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

Hello, I have created a form that just a message as a reminder. Is there a way to make it open when the database is open for about 15seconds and close automatically. And is there a way to make it come up only at certain times from 6pm to 1am when a person open the database at those times I...

Hi, I need advice on is there a way to make a label flash on a form. I would like it to flash every 5 seconds. Thanks in advance Al

Hi, I have a record that has contact name, update combobox, date, and 2 number fields. What i am trying to achive is when I go to update a record instead of changing all the information I would like to select the record and create a new record with all the information except the date and update...

Hi, I have a form that has two field that have sale amounts on them. My employee puts the sale amount in every day after the day is over. I would like to make a querie so that i can get the total sales amount from let say three days or even a week. I have tried everything but no luck. Thank you...

I have a form that has a date field that has to dates (example: mm/dd/yyyy - mm/dd/yyyy) I made a report for this form using a query. Here is my problem I am trying to print the report but if there is 10 records 10 reports print out. I need to set a criteria in the query that when a person hits...

Hello, I have created a form with a subform where shift supervisors and employess enter information throughout the day. There is in the main form it has a date field and supervisor field. The subform has time field and data entry field. I created a query and made a report with that query. Here...

Hello, I am trying to create a report for a form. When I create a report I get blanks. I have two tables. Table 1 has the following field names: Date, Section supervisor, and section employess. Table 1 is used for the main form. Table 2 has the following field names: Time, data entry. Table 2 is...

Hello, I am trying to create a report for a form. When I create a report I get blanks. I have two tables. Table 1 has the following field names: Date, Section supervisor, and section employess. Table 1 is used for the main form. Table 2 has the following field names: Time, data entry. Table 2 is...

Hello All, I am trying to print a Report from Form where the Form was built by a Query. I set up the command button on the form and I get all the records on the form. I just want to print the opened form. Thanks in Advance Al

Hello. I have a print problem I made a query, then built a form with the information of the query and made a report for the query. Now this is where my problem starts I put a print commad button on the form so I can print the form but I end up with all the records printed in form view. How do I...