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

    Modification of AceMan's Answer to thread702-1459928

    Thanks, PHV. I was clearly overcomplicating this. I am going to use the double click method with Me.M15=Me.14 for the user to update only particular records and an update query if the user wants to update all records. Thanks again!
  2. kristi1023

    Modification of AceMan's Answer to thread702-1459928

    I modified the code to find something that works, it's probably not the best solution: Dim Nam As String, hldVal Nam = Screen.ActiveControl.Name hldVal = Me(Nam) Me.M15 = hldVal So, my next question, is it possible to copy M14 to M15 for all of the records in the...
  3. kristi1023

    Modification of AceMan's Answer to thread702-1459928

    thread702-1459928 Instead of copying and pasting the contents of a textbox to the one below, I'd like to copy and paste the contents to the one to the right. Is that possible? The name of the textbox I'd be copying from is M14 to M15. WOuld it make a difference that these textboxes are on a...
  4. kristi1023

    Message Box on First Click Only

    Thank you for your suggestion Ace. I implemented it, but given that it's a checkbox, I fear that the user will click before the Control Tip appears. So I also put a small label on the form with the same explanation as the Control Tip. ------------------------------- Joe, to answer your...
  5. kristi1023

    Message Box on First Click Only

    Oppps Remou...Sorry about the mispelling
  6. kristi1023

    Message Box on First Click Only

    Thanks, Ramou. As I thought about it, I need to pop up the message before the user clicks. I think I'm going to implement a yes/no msgbox on the click event that prompts "Continue?" and then base my next event on if yes or no is selected.
  7. kristi1023

    Message Box on First Click Only

    Hello All, Is there a way to show a message only the first time a user clicks a checkbox? Or even something like a mouseover event in html? Thanks so much, Kristi
  8. kristi1023

    On Current Event?

    Randy, lblStaffingComplete is always red no matter what the date is or if the date field is null. lblStaffingComplete will be updated according to the code that I posted when I switch between design and form view, but as we've established users won't be doing this, so I need the code to...
  9. kristi1023

    On Current Event?

    Randy & Joe, Here's the code I use to open the form: On Error GoTo Err_OpenProgReqs_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Directorate Program Input" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_OpenProgReqs_Click: Exit Sub...
  10. kristi1023

    On Current Event?

    It's finally working! I moved the code to the On Mouse Move event of the Detail section of the form. Now let's just hope that the users will actually move their mouse! :) Thank you all! Kristi
  11. kristi1023

    On Current Event?

    Randy700 and JoeatWork, I want the code to be activated when the user opens the form. You're right the user won't be looking at the form in design view and switching to form view. This is my dilemma. AceMan, I tried the OnLoad event with no success. Thank you All, Kristi
  12. kristi1023

    On Current Event?

    Randy, below is the code, but the code isn't the problem; activating it is the problem. Onefootout, I am color coding a label, so it's not in the tab order. I might try this solution and change the label to a textbox if nothing else works! Thanks,Kristi ------------------- Code: If...
  13. kristi1023

    On Current Event?

    Genomon, I want the label to be color coded on the open event only. I have tried moving the code around to different events, like on open, on current, on activate, but the only time it works properly is when the code is in the on current event and when I switch from design to form view. Thank...
  14. kristi1023

    On Current Event?

    Hello All, I have code on the current event that is color coding a label on a form. The code only works when I switch from design view to form view. I tried adding me.visible=true to the on activate event with no success. Any suggestions are greatly appreciated. Thank you, Kristi
  15. kristi1023

    Color Code Combo Box

    Hello, I have a manpower planning database and I'm wondering if it's possible to color code combobox rows? For instance, if an employee is overstaffed, I'd like their name to appear as red in the combobox list. Many thanks for any suggestions! Kristi
  16. kristi1023

    Build Filter using 2 columns of Multi-Select List Box

    Thanks for your help. I figured it out... For Each varitem In Me.lstSkills.ItemsSelected If varskill <> "" Then varskill = varskill & " OR " varskill = varskill & "([Skill] = """ & Me.lstSkills.ItemData(varitem) & """ AND " & _ "[SkillLevelID]=" &...
  17. kristi1023

    Build Filter using 2 columns of Multi-Select List Box

    I'm sorry I meant to say SEARCH rather than append I am thinking about 2 different problems at the same time. I need to search based upon the 2 columns in the multi-select listbox. In the example above, if I choose C++ and Expert, I need to search the table for skill AND skill level OR...
  18. kristi1023

    Build Filter using 2 columns of Multi-Select List Box

    Hi IIHTP, VarSkillLevel would return one skill level with each skill, i.e. Skill: C++ and SkillLevelID: 4(Skilled). The code I posted is an excerpt, a subfilter is used elsewere that's why i'm stripping off the last and. Yes there is a skill level with each skill; listbox looks like: C++...
  19. kristi1023

    Build Filter using 2 columns of Multi-Select List Box

    I am using a Multi-Select List box that searches Skills and it works great. However, I now have to add Skill Level to the list box and perform the search based on 2 columns (Skill and Skill Level ID). Here is my code: Private Function BuildFilter() As Variant Dim varWhere As Variant...
  20. kristi1023

    Changing Color &amp; Caption of Command Button

    I got the color coding to work. So simple, I had to change backstyle from transparent to normal. :-P

Part and Inventory Search

Back
Top