Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ezyflo

    Multi-Select List Box Search 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!
  2. Ezyflo

    Word Form Data to Access

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

    update statement

    Cool Beans!!! Thanks!!!
  4. Ezyflo

    update statement

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

    Custom Menu Bar File->Print Problem

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

    Help With Syntax for Multiple If Criteria/Statements

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

    Help with delete statement.

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

    Help with delete statement.

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

    Combo Box Index Feature?

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

    Combo Box Index Feature?

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

    Help With Entry of Empty Records

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

    Help With Entry of Empty Records

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

    Securing the database

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

    Manually Assigning Values to Items In A List/Combo Box???

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

    Neep Help With Nested IIf Query???

    Thanks for your help! Works fine.
  16. Ezyflo

    Neep Help With Nested IIf Query???

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

    Record already exists message box?

    Thanks! I'll give it a go.
  18. Ezyflo

    Record already exists message box?

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

    Help - Link/Import Access Database to Frontpage or VB?

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

    Need Help on Sql Query Calculation - Please

    ...RMVPropertyClassRates.Limit, RMVPropertyClassRates.ClassRate1, RMVPropertyClassRates.ClassRate2, (Forms!RMV!txtAmount)*0.00158002 AS Q1, (Forms!RMV!txtAmount)*0.00029901 AS Q2, (Forms!RMV!txtAmount)*0.00023785 AS Q3, (Forms!RMV!txtAmount)*0.00013592 AS Q4, * FROM RMVPropertyClassRates WHERE...

Part and Inventory Search

Back
Top