Recent content by JimMiller

Thanks for your post! Do you know when controls are unavaliable/out of scope for queries and calculations?

When does a combo box update the record source assigned to it? Does it wait until the form is closed or does it update after the new value is selected? Also what event corresponds to the updating of the record source associated with a combo box? Any insites or information will be extremly helpful.

I have a couple of forms in my database that should only be navigated by the buttons developed. I do not want the user to be able to close or move to other forms without using the buttons I created (this prevents users from getting around validations). I am able to make this happen when the...

Everything works except when you maximize the form. When maximized, the close button reappears in the top right corner. I think it migth have to do with the custom menu bar I created. The close box does not appear in the custom menu bar until I maximize the form. Does anyone have any ideas or...

Never mind. I figured it out. Below is a way to loop through all the loaded forms... Sub CloseForms() Dim i As Integer For i = (Forms.Count - 1) To 0 Step -1 If Forms(i).Name <> "MainForm" Then DoCmd.Close acForm, Forms(i).Name End If Next i End Sub Loop through the open forms (a form will be...

I am looking for the code when given a form name will return if the form is loaded or not loaded in the system. Does anyone know the syntax or other ways to achieve my objective? Thanks!

I am trying to access fields in a table from a Form's VBA code. I am having trouble with the syntax for accessing tables. Here is what I have coded so far: If IsNull([Table]![Issues]![RevisedEstHours]) = False Then [Table]![Issues]![RemainingHours] = [Table]![Issues]![RevisedEstHours] -...

test

Thanks for you response! You suggestion doesn't seem to be working, I believe it is because I am setting the following properties on start up ChangeProperty "StartupShowDBWindow", dbBoolean, False ChangeProperty "StartupShowStatusBar", dbBoolean, False ChangeProperty "AllowBuiltinToolbars"...

I am trying to remove the close box from a form. I have disabled the Close Button property and have had no luck. Does anyone know any other methods to remove the close box at the top right of a form?

Rich...thanks for all your help! I figured it out.

I relize that me.undo is more reliable, but do you know the VBA code for the ESC key?

Rich..thank you for your reply! When I use Me.undo I get the following: Run-time error '3020', Update or CancelUpdate without AddNew or Edit Does this mean I must have a record inserted before I undo it...

Does any one know how to code the action of the ESC Key in VBA? The specific action I am looking for is when a record that is being updated is canceled out of.

I am using the name of the control. The control variable is not pulling the value from ther form. Do you think it could be that the control is not loaded or in scope?