Search results for query: *

Hi, Thanks for any help. I am familiar with Excel lookup functions, but I am looking for something more than VLOOKUP and LOOKUP. Lets say I have column A and B on one tab. I have column C and D on another tab. A B C D I would like to search column A for any...

Hi, Thanks for any help. I have a combo box in a subform. The box is populated by a query. Is it possible to lock the combobox (to keep users from changing the source data value) but still allow the user to select a change in the combo box from the pulldown list? As of now, the lock...

Hi, I dont know if I am asking this in the correct way but is there any way to "lock" values from the tables? The forms and reports will be used by other users and I would like to have them only select values from combo boxes, not be allowed to type a new value or overwrite an old value...

Hi, I form with comboboxes. The user selects an entry from the combobox and with the on click event of a command button, the combination of combo box entries is saved as a row in a new table. I would like three of the comboboxes to remain on the selected value until the user changes the...

Hi, Can someone help me with a problem of linking subforms to forms? I have a subform which I am trying to connect to my main form. I would like to select an entry in a combobox in the main form and display information related to that entry's ID in the subform. When I try to link Master...

Hi, I hope this is just an easy quick question. Can a combo box in a form have a table control source different than the table source of the form itself? I want the form to be linked to table tblEmployeeInfo, but then select data from other tables via comboboxes. A recordset on a command...

Hi, Could someone please help me with formatting a text box? I have a table with JobID as the primary key. JobNumber and JobDescription are both fields in that table. I then have a combo box in a form. When selecting a JobNumber from the combobox, the JobID is stored in a different table...

Hi, Can someone help me with linking a subform in datasheet view to a textbox in the mainform? I have a primary key called EmployeeID. The text box in the main form displays the EmployeeID, and I was thinking of building an AfterUpdate code to then link the textbox EmployeeID number to the...

Hi, I have a form with a recordset to populate a table. "Employee Name" is a combo box in the form. Can I create a subform that will list all of the corresponding past entries for each employee name when an employee name is selected in the combo box in the main form? I want to be able to...

Hi, I have a form which uses a number of combo boxes and each one pulls a list of data from different tables. Can I have a user select data for each combo box, enter a number in a different combo box and on the click event have this information saved to a new table? I am fairly new to...

I have a form set up with command boxes pulling from three different tables. How can I code a command button to populate a new table with each entry combination from the form? Thanks, pmkieffe

I have information in three tables which are to be displayed in a form. This form is to be used by another user to select a combination of entries from the three lists and enter a number as well. I would like each of these combinations to be used to populate a seperate table. Is this...