Search results

I'm struggling with the syntax for a dlookup with multiple criteria. (Also, you'll see that my Msgbox is wrong (as I can't recall how to handle a string variable). Any assistance would be appreciated very much. Dim iDirectorID As Integer iDirectorID = Nz(DLookup("nameID"...

Hi, Bob. I forgot to insert Me. in front of the combo box name - which led me to consider trying SendKeys. Now that I've inserted Me., it is working the way I wanted. As for the Save reference, I have a command button next to the combo box to save the selected name from the combo box. The...

I'd like to get a combo box to drop down automatically AFTER the user SAVES his first combo box selection. That is, I don't want the dropdown to happen on the first selection. In the coding for the SAVE button's "on click" even, I set the focus back on the combo box. Then, I was going to...

Worked perfectly, lagbolt ! All I need to do now is insert a requery line of code into the Save command button. Many thanks.

I currently have an unbound combo box on a form which uses a query to list several employee names. The form also has a "Save" command button so that the unbound employee name can be saved in a table together with the employee's "Function". Once the employee name has been saved with the...

The 4 columns are set up based on the measurements suggested. However, I did make 1 error in describing what I see after selecting a record. The item which is visible after exiting the combo box is not the invisible bound column (column 1). Rather, it is the item from column 2 (or the 1st...

The dropdown list works fine with those settings. But after the user selects a record and moves onto the next control, the combo box shows the bound column value only.

I have placed an unbound combo box on a form. This combo box has 4 columns, but only 3 of the columns are visible to the user. The "invisible" 4th column is the bound column. After making a selection and moving onto the next control on the form, the combo box displays the previously...

I have an unbound combo box on a form which offers users a list of names to choose from. I want users to be able to add new names to the list so I have filled in the List Items Edit Form on the property sheet of the combo box. An icon now appears at the bottom of the combo box list which...

I tried DMax, but get the same error message that I got with Dlookup. "Invalid use of Null". If I was dealing with integers here, I think I would be tempted to try Nz in combination with Dlookup (or DMax). But since I'm trying to pull a date out of a table, I'm not sure that Nz would be the...

Is it correct to say that Dlookup is better for looking up text fields, while Dmax (or Dmin) is more appropriate for date fields ?

I have a form with an unbound combo box that allows user to select from a list of existing client names. The user then inputs the new name of the client into an unbound text box and then indicates the effective date of the name change. I'm trying to introduce a validation check to make sure...

I think I solved the validation problem with the unbound text box. Within the If structure, I placed the following code: MsgBox "This name already exists. Try again." Cancel = True Me.ubdtextbox.Undo DoCmd.RunCommand acCmdDelete The above coding allows me to eliminate the incorrect entry...

That helped. For the combo box problem, I used DoCmd.RunCommand acCmdSaveRecord in the coding for the Save command button (together with me.combobox.requery in the coding for the combo box control). But I still have a validation problem on the other form when entering in a completely new...

I'll give it a try. Thx, Paul.

Paul - Your SQL coding worked perfectly. Thank you. One other question - This little model has 2 forms in it: 1) A form to enter the name & other info about a new person; and 2) A form to select a person's latest (current) name which will then be updated. (The Change Name form)...

I think that might work, Paul. I'll give it a try and let you know tomorrow. Cheers, Robert

I want to create a combo box which will allow users to select from a list of people's names. The combo box queries a table which contains all the individuals' names (plus a field called "EffectiveDate"). The complication is that some people have aliases and I only want the combo box to show...

That's too bad. Oh well. One extra click won't kill anyone !

Did that. The little calendar icon shows up when the focus switches to the unbound text box, but I'm wondering if I can get that icon to open up without having to click on it. That is, on entering the text box, I'd like to see the days of the current month rather than that little calendar...