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!

Tony, I would be interested in your code to update an Access table from word. I have data in Word that I want to put into an access database. Your code would be ideal! Dee

Cool Beans!!! Thanks!!!

Hi! I was looking at the update statement in vba. For what I am doing, I am running my update query from a form on an "after update" event. The problem I am having is after I run the update query and return to my orignal record source for my form, it changes the record that I was on...

I'm looking to do the same thing. I am using XP any ideas on how to copy the option from the standard menu? Any help would greatly be appreciated.

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

Thanks for your response! Unfortunately I am getting a runtime error: Update or CancelUpdate without AddNew or Edit. I'm not too familiar with VB - and I would like to understand the code. Can you explain this part of the code to me? If Not rs.NoMatch then...

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

I do understand the auto fill feature, what I would like to do is when I type in "A", it will pull up the first item starting with "A" - Amy for instance, I would like to hit "A" again and have it pull up the the next item in line with "A" (Ann) and cycles...

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

Hi! I tried what you suggested and cleared out the control source for the combo box. It made it an unbound control. When I went in to select an item from the list box, it selected that item into every record that I had existing and also when I enter new records. Let me explain my...

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

AnnSolomon, May I also get a copy of your database? Please send it to dvang@springsted.com Thank you. Dee

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

Thanks for your help! Works fine.

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

Thanks! I'll give it a go.

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