Search results

I have a form with a combo box which selects the record which I wish to change. I make the change to one of the fields of the selected record. Then, I may wish to choose another record, using the same combo box. The choice of records offered by the combo box should no longer include the...

Can't seem to get anything to show up in the immediate window. I placed the suggested code into the form module. Then I copied the name of the procedure into the immediate window (cmdProperties_Click) and hit "enter". The error message said: Compile error: Sub or Function not defined...

I assume that I need to create a command button on the form. I've done that. As for the code, does it need to be placed in the Declarations section of the VBA code for the form?

Thanks. I'll give that a try.

Didn't realize that it had changed! I won't claim to understand the coding, but everything now seems to work. Guess I'll have to study up on the "dirty" property. Thanks again.

Seems to work, RuralGuy. Thanks very much. There is only 1 thing that is puzzling me: When opening frmCorps directly, the form is supposed to open to a new record. It does that, but the record counter at the bottom of the form's window does not display the true number of records already in...

Is there a way to print out the complete properties window of a form or report from the VBE window ? I know it is possible to print the code, but it would be useful to be able to print all the properties settings for a form and compare forms to see if settings are similar or different.

Is there a way to have to form close automatically when the user tabs out of the last control on the form?

The LostFocus event on txtHQLocation doesn't work either. Still getting run time error #2585.

Here is a zip of the file. Just checked the on exit event again. It definitely is resulting in an error.

There are 3 controls on frmCorps: txtCorpID (bound to CorpID in tblCorps); this is an autonumber & PK txtCorpName (bound to CorpName in tblCorps); and txtHQLocation (bound to HQLocation in tblCorps). So in answer to your second question is no. There are no other controls after...

Re: NotInList Event Question - Glitch Has Come to Light A glitch has developed in closing the dialog box (for frmCorps). If the user neglects to provide an entry for txtHQLocation, then the form doesn't close on the txtHQLocation AfterUpdate event. So I tried using the OnExit event with...

I inserted that If block into the AfterUpdate event of the textbox txtHQLocation. frmCorps now closes automatically, but only when it was accessed from the NotInList event of frmEmployees. Many thanks.

Thanks, RuralGuy. It works now. One final question: Is there a way to close the frmCorps dialog box after assigning a value to txtHQLocation? Normally, I would insert an AfterUpdate event for that textbox, but I wouldn't necessarily want the form to close automatically if the end user had...

We're still using Access 2003 where I work. (However, I created this small db on my home pc, using ACCESS 2007).

I have created a simple database with only 2 tables: tblCorps and tblEmployees. Each table has an autonumber primary key. The primary key of tblCorps appears as a foreign key in tblEmployees. There is a form frmEmployees where employees can be added. The form has a combo box which lists...

Thank you, Bob. I'll give it a try. -- Robert

I am working on a db for a list of films (including the company name and year of shooting). One of the fields is Production which is used for the titles of the films. And of course, sometimes film titles include apostrophes or other special characters. eg. Look Who's Talking When the...

I have been told that MsgBox can be both a function and an action. What is the simplest way to distinguish between when it is being used as a function versus when it is being used as an action?

Thanks, Galaxiom. That worked perfectly !