Search results

Hi, Have you checked the vba for the Name text box (eg on GotFocus or on Click or similar event procedures) that is making it think it is null? There must be something. You could just use SetFocus to move focus to another control, but then you'd never know why!

Sorry shafara7 that code doesn't work (Me.[subform name].Requery) - I just tried it on one of mine. What worked was Me.Refresh

Hi shafara7 The code I posted was in answer to your question "I want the Inspector combo box be controlled by the Project combo Box" This can only be done if each combo box contains a column referring to the other. I have to agree with Gasman and missinglinq that it would be best to use...

(Alternatively you could set the Visible property to No. That would disable it.)

Are those circumstances something you could put into an IF statement? If (circumstance = true) Then Exit Sub End If

Try using objOutlookMsg.SentOnBehalfOfName = "aaa@bbb.com"

If you must use Value Lists as the row sources, this makes it difficult but not impossible to do what you are asking. I am assuming your row sources have 2 rows for each combo box, each containing Project and Inspector (otherwise how could you filter them?) And you want to limit the list so...

Try setting warnings: DoCmd.SetWarnings False DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True I haven't tested this but in another thread on the pcreview site, this was found to allow the spelling corrections to show, but suppressed the "Spell Check Complete" popup. Hope that helps

In my response yesterday I mistook "Exit Sub" for "End Sub" - sorry. So End If should come after Exit Sub of course. And it may, because I now see you haven't included code beyond Exit Sub! The point about "Me." still applies though.

Hi ECEK, I can see a couple of things: First there is block if without End If. Second, assuming "cnm_reason" is a field, you should include "Me". So the total code would be: Private Sub Command70_Click() Me.Refresh Me.Requery Me.datediffs = Me.rep_rb - Me.drc If Me.rec_type = "Completed"...

Hi, I'm a copy and paste person too! Your code: strPathToFile = CurrentProject.Path & "" & c_strFile is missing the backslash. CurrentProject.Path gives a folder with no backslash. Change that line to:- strPathToFile = CurrentProject.Path & "\" & c_strFile and see how that goes.

Hi dafne, In your line If Me.checkNP_clausal.Value = "-1" Then you don't need ".Value", nor the quote marks. Try changing the line to: If Me.checkNP_clausal = True Then That should work ok. The ".Value" property is different and explained in a Microsoft article - just google "Value Property".

DoCmd.RunCommand acCmdSaveRecord only works with the Current record. If you are updating data in a different form from the one you are in, you can do this by temporarily re-setting the focus to the other form - thus making it the current record. Here's one I did earlier. In this example, we...

Been programming in Access since 1995 - completely self-taught. Thank goodness for Google, and the "for dummies" books! In the 6 years before that it was DataEase :banghead: During this time I designed and operated a Document Management database in the Oil and Gas Engineering industry, as a...