Search results for query: *

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!

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

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

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

Oppps Remou...Sorry about the mispelling

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.

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

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

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

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

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

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

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

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

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

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]=" &...

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

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

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

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