Search results for query: *

I have a combo box -- call it Combo1. If I backspace over the text in the box until there is nothing and hit Enter the Click event procedure correctly sees Combo1.Value as set to "" (nothing). However, if I do the same and then change focus to another control then Combo1.Value is...

I want to disable events such as Exit or Click while other event procedures are running. Basically in one even procedure I am updating information in the text boxes. When the user changes the data in the text box I want to run an event procedure, but when I set focus to them or change their...

I want to lock all records in a table only for a small point in time during a particular event procedure. The user enters text in a text box, and I want to insert it in the table and requery the table instantly in order to find out what autonumber was assigned to that new record. If I have...

In a combo box is there a way to distinguish between a user typing in a null value and pressing enter, versus clicking on a list entry that is bound to a NULL value? I thought the ENTER versus CLICK events would distinguish these -- but apparently not. Details: I have a combo box for a list...

I have created a combo box that has "New..." as one of the list items. I want this so that when the user selects "New..." a different form will pop up to gather the appropriate information pertaining to the new entry. I have found that while I can get "New..." to...

Below is a code segment from one of my forms. I have used this same logic elsewhere and it works fine. This is the only place I think I've done it with 2 recordsets open at the same time. The second loop (on Delete1) only executes once - even when there are three records in the recordset. I...

I have written a rather simple query. It is: select field1 from table1 where field1 not in (select field2 from table2); Note that field 2 is the foreign key to field1. The query is a little more complex than this, but I can reduce it to this and the same problem results. This query returns...

I am trying to find a good way to deal with an empty record set. I was using a DAO recordset, but when it is empty a MoveFirst does not work. It seems that issuing a MoveFirst would be safer than trusting that the pointer is initialized at the top of my recordset. I noticed that in ADO there...

I have a form (call it form1) that opens another form (form2). Form1 has a listbox on it and the data in that list box is changed when leaving form2 and returning to form1. In particular, form2 allows the user to delete rows that would be displayed in that list box when the Done command button...