Search results for query: *

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

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

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

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

Can I change the color and caption of a command button based upon how many times it is clicked? For instance: One Click = White /Caption = 1 Two Clicks = Yellow /Caption = 2 Three Clicks = Orange/Caption = 3 Four Clicks = Red /Caption = 4 Five Clicks = Begin Loop at One Click Any ideas...

I have a subform which consists of 20 unbound checkboxes. The command button runs sql to insert or delete an individual record from a table based on whether a box is checked or has been unchecked. This works great. I need to prompt the user to click the button only when data has changed, i.e...

Hi, I have 20 unbound checkboxes on a subform and I'd like to update a separate table with employee id and skill id. I'm using the following code on_click event of a button: If Me.Check1 = True Then [SkillID] = 1 DoCmd.SetWarnings False DoCmd.RunSQL "insert into tblskillassessment...

I have a textbox on a form that is based on the calculation (Date()-[Promise Date]), which updates OnCurrent event. Since this calculation needs to be updated daily, is there a way to force this calculation without manually opening the form and scrolling through all records? Thank you.

Has anyone ever written a VB or VBA module that will calculate the mean time between failure for a unit or know of a Web site where I may download such a calculation? Any insight is greatly appreciated, as I'd rather not have to think so hard on a Monday morning! Thank you! Kristi

More specifically, I'd like to disable the scrolling wheel. Any advice on this is greatly appreciated. Kristi

How would I populate a list box based upon the results of a search string? The search would be based upon matching any part of a string entered by a user into a text box. I would want to search the course name field in a table and I would like to see all matching results in a list box on the...

I have a training database where an employee will both add and edit his/her training report. The form consists of a main form and 2 subforms. My problem is that when an employee enters employee id, which is the primary key, a new record is created instead of just retrieving the data from the...

I would like to delete the data in a subform on click of a delete button on the main form. The main form lists employee data and subform lists training data for that employee. The forms are linked using employyee id. Is there a simple way to complete this task? Thanks [peace]

Hello All! I am running an export macro that transfers a table locally to a network drive. In my case, it's the F drive, but I can't assume that all users will be connected to the GEC031 server through their F drive. So, how would I specify the name of the drive in a generic fashion so that...

I am running a macro that transfers a table from a local version of the db to another version of the database located on the network. I'm wondering, is there a way of detecting the identity of the person who exported the database? Perhaps, their login id? Thank you.

I'm wondering what the standard is for counting lines of code in MS Access. It's simple to count the lines of VBA code, but how does one translate the design of forms & reports into lines of code? Thanks!