Search results

of bubbling yellow

Oh, what a

This may be of use: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.appevents_event.workbookbeforesave(v=office.11).aspx The event Workbook BeforeSave Trigger may be what you are looking for.

Can you post the code you are using?

I have built a similar function: varAddAnotherCode = (MsgBox("Price code " & strPriceCode & " added successfully." _ & vbNewLine & "Would you like to add another Price Code?", vbYesNo, "New Price Codes.")) If varAddAnotherCode = vbYes Then With Me .txtPriceCode = "" .cboClass = ""...

For the yesterday value, maybe a hidden textbox with a Dlookup statemtent for populating the value will work. Once you have that, the calculations should be easy to do in the expression builder. You may want to employ the Nz function to avoid errors: Nz([field],0) to default values to...

Thanks Bob Larson.

Form_frmRF.Object.SetFocus (VBA Syntax) Rather than Forms!frmRF.Object.Setforcus (expression builder syntax) It's a shot in the dark.

If the system is getting locked, it is a power setting. Ex: "This Computer is in use and has been locked..." Check the display settings: Screen Saver tab | On resume password protect option

The original Code: Private Sub txtUPC_AfterUpdate() AppendUPC Me.tblRFpick_subform.Requery Forms!frmRF.SetFocus End Sub The afterupdate procedure ends with settting focus on the form, not the control on the form.

Check the Shared workbook advanced tab. The update changes function may be getting overwhelmed. You may be able to delay the interval but solving the problem may lie in converting to a database.

Sorry, I misunderstood your query. To set focus on an object in a subform from the parent you would Parent.subform.object to referentce it in code, to set focus from s subform to the parent, VBAInet's example may work but I use Forms_Parent.Object as my model because I find Access occasionally...

Try something like this: Dim intQuantity as Integer Dim strSQLINSERT as String intQuantity = X Do Until intQuantity = 0 StrSQLINSERT = "INSERT INTO [Table] ([Field1], [Field2])" _ & " Values([Field1], [Field2]);" DoCmd.RunSQL strSQLINSERT intQuantity = intQuantity...

Check the report's "Has Module" property. I have run into the problem where code is not executed because the property fails to update when adding an event.

1. Update the declaration of the database to DAO.Database so you don't end up with a conflict defaulting to an ADO database object. "If rs.RecordCount > 0 Then" is unreliable. ADO objects will return -1 for a null recorset. If RS <> BOF and RE <> EOF then RS.Movefirst is suggested. A null...

I do not understand why the compiler failed to utilize the recordset fields in the current state even though it would recognize them and correct capitalization whitle I was typing the statement. I was able to work around this by redefining each field in variables which I then used in the sql...

You need to use the afterupdate event rather than the onchange because the value you are referencing is not committed while the combo box still has focus and therefore cannot be used as a parameter. It would also be more effecient this way since the user would have to change focus to the next...

Try this: http://www.access-programmers.co.uk/forums/showthread.php?t=188663

Try changing the recorsource on the subsequent combo boxes using the afterupate() trigger. pseudocode: combo1_Afterupdate() strsource2 = (query based on value in combo1) combo2.setfocus combo2.recordsource = strsource2 combo2.requery Combo2_AfterUpdate() strsource3 = (query based on...

I am having a similar error: "Compile Error: External Name Not Defined" When I debug or attempt to run the procedure, I get the error with refernces to the code in red. The line highlighted when the error occurs is the initial public function statement. As you will see, the fields are spelled...