Search results for query: *

I would like to have a multi select list box of certain fields in a table of where to search and have unbound text boxes where the user can enter the words to search for. Any help would greatly be appreciated. Thank you!

I have a look up field for "benefit group" in my table where they their are about 6 choices. Of the 6, 3 groups have the same vacation schedule. I am trying to write an if statement for their vacation time. if benefit group = Local 49 or Dispatcher or Police Officer and Status = FT...

I have an Employee table with a yes/no field for "Employee Allocation". I have an employee allocation table that stores the percent and the "to department". On the Employee form, they can check yes for the allocation and then go to another form to enter the allocation...

Is there a way to set the properties to a combo box so that when the users enter a letter, it will cycle through all choices starting with that letter until they reach the one they want? I did do a search and found some information in the Visual Basic forums, I'm using Access XP and not too...

I have an input form that users can go and select data from a combo box and 2 fields where they can input data. The problem I am having is that sometimes when users open the form and to enter data they click on the combo box and make their selection and then decides that they do not want to...

I have a table with fields that uses the lookup wizard and pulls information from another table where I have specified a "condition" and assigned a point value to the "condition". I will need to use the point value in a calculation in a report. The problem I'm having is...

I have a query that calculates the years of employment for employees based on their start date. From the years of employment, I would like to create a query that will automatically determine their vacation time. Year 0 - Vac 0 Year 1 - Vac 80 Year 2-3 - Vac 96 Year 4-10 - Vac 144 Year 11-15 -...

I have a table with the primary key set to EmployeeID. Users will be inputting information via a form. I would like a message to pop up after the user enters the EmployeeID on the form to confirm that it is correct before they proceed. I also need to have a message pop up if the EmployeeID...

OK. So I created this wonderful database. It is has a form that the user would go in and select their “Property classification” from a dropdown combo box, input their property value in a text box and click a button to calculate their various taxes, which are also displayed on the form. I have...

I have the following sql query in a database. Is there a way for me to incorporate the If Else statement in? I have a form where the user will select their property class from a combo box and enter their amount in a text box. With that the various calculations below. I need to make the...

I have complex calculations that need to be done in Excel. Is it possible to have excel do the calcs and have the results show in Access? If so, how would I go about doing this? i.e. I have a form where the user will be prompted for information. Depending on what they input, various...

Is is possible to have an access form on a website? The form will not be writing data to the table, it will be used for informational purposes only. The user will input some information and press a command button to run a query to do a calculation and display the result in a text box on the...

I want to create a form where someone will provide some information and depending on what they put in - do a calculation. Example: I have a combo box with different classifications. On the form they would select their classification and then input a value. The classification has a rate - if...

I have a look up column in a table with the fields "Experience level" and "Point Value". I want to store the point value for calculation in a report. I am having trouble, some of the point values are the same (ie Experienced - 50pts; Professional - 50 pts). The lookup...