Search results

I have the below code set on click. Which sends a report. What I need is to have the report only send the dates that have not passed. So instead of sending the whole report I would like to send only the information to dates that have not passed on the day which the button is clicked. Private...

I have the below code set on click. Which sends a report. What I need is to have the report only send the dates that have not passed. So instead of sending the whole report I would like to send only the information to dates that have not passed on the day which the button is clicked. Private...

I am building a student registartion database. Now I have come to a point where I need to list the classd escription and dates available. Now should I have a table with all of this information? or have it in a Excel Spread Sheet with a link? Now what I need to happen is to have the date of the...

I am building a student registartion database. Now I have come to a point where I need to list the classd escription and dates available. Now should I have a table with all of this information? or have it in a Excel Spread Sheet with a link? Now what I need to happen is to have the date of the...

I have a report which I need everyone to see but I do not want them to see anything else but the report. What do I need to do and how do I do it? Beg. Access user here

I have a report which I need everyone to see but I do not want them to see anything else but the report. What do I need to do and how do I do it? Beg. Access user here

I need to set two criteras in Query. When I do it now I write the following "Pete" "Walt" I get a syntax error

I am not sure if this could be done or how to do it. But I have been asked to convert a Report into a Excel spread sheet. Can it be done and how would it be??

I am not sure if this could be done or how to do it. But I have been asked to convert a Report into a Excel spread sheet. Can it be done and how would it be??

I placed this code in the OnOpen and get a bug error 2110 Microsoft Access cannot change focus to control SeatsAvailable. Private Sub Form_Open(Cancel As Integer) Dim intSeats As Integer [SeatsAvailable].SetFocus If Val([SeatsAvailable].Text) < 1 Then MsgBox "Sorry, no more seats...

What I would like to do is design 30 questions for a test, which only 10 questions would be used for each test given to a student. What I would like to know is, if Access could logically select random questions from a pole of questions to develop a different test for each student? And when the...

I would like to set a limited number of seats avaiable and have the number of seats subtract every time somone fills out a registration form. So my form looks like Course Date Seats Admins 1 10/1/00 12 Now what I want to happen is when the next person opens the form they...

I have a form with Employee Name, Phone and Email. The subform is the Company Name, Address, Affiliation. The Employee Name,Phone and Email are looking at a table. The Subform Company Name, Address and Affiliation are looking at a query. All of the fields are Combo Boxs. What I am trying to...

I have a form with Employee Name, Phone and Email. The subform is the Company Name, Address, Affiliation. The Employee Name,Phone and Email are looking at a table. The Subform Company Name, Address and Affiliation are looking at a query. All of the fields are Combo Boxs. What I am trying to...

am building a database for the first time with Access2000. 1) I would like to have a command button that would allow someone to type there name to locate their information, if they are not listed I would like a message to pop up that would tell them that they would need to enter their...

am building a database for the first time with Access2000. 1) I would like to have a command button that would allow someone to type there name to locate their information, if they are not listed I would like a message to pop up that would tell them that they would need to enter their...