Recent content by missinglinq

  1. missinglinq

    Wrong form has focus - how to set on the proper form?

    And FYI...you can only SetFocus to a Form if it has no Controls which may have Focus.
  2. missinglinq

    Solved How to convert number in words in Microsoft Access form?

    Probably a variation of it...but not for 'currency.'
  3. missinglinq

    Solved How to convert number in words in Microsoft Access form?

    Here's another one: From the Access Object Dialog Box click on "Modules" Click on new to make a new module Copy then paste the following code into the new module: '################## Beginning of Code ####################### Function SayNo(ByVal N As Currency) As String Const Thousand...
  4. missinglinq

    Form Button vba and Combobox conditional formatting

    As the Friendly Ogre said...being able to 'lay hands' on your actual file would help us immensely in helping you! Having said that, though, if by you mean that after going into the VBA editor then going to Form View the button works...but simply opening the database and then opening the Form...
  5. missinglinq

    Solved How many digits have I typed?

    i.e. If Len(srchRecIDFrom.Text) = 5 Then
  6. missinglinq

    VBA code

    So...did that resolve the problem? Linq ;0)>
  7. missinglinq

    VBA code

    Paying close attention to everything else you've been told...if you're entering an A or B into the Type control: If Me.TypeBrand = A then it has to be Text and the code needs to be If Me.TypeBrand = "A" Linq ;0)>
  8. missinglinq

    Is the Me. syntax required in form vba when referring to controls?

    Also, when typing in Me.txtAge VBA's IntelliSense should finish it by popping up Me.txtAgentID If it doesn't...it means VBA can't find txtAgentID...isn't valid name...perhaps because it's misspelled! It's a good 'spell check,' if you will! Linq ;0)>
  9. missinglinq

    Disable texboxes

    Since nobody else mentioned it...the problem with your code lies here: Me.textbox2.disabled = True Notice that Intellisence didn't capitalize the 'd' in disabled! That's because there is no 'disabled' Property! Arnelgp's codes shows the correct Property here ctl.Enabled = Nz(Me!Textbox1...
  10. missinglinq

    Goto new record on subform

    Sorry...but your scenario doesn't make sense! An Unbound Form (i.e. a subform which is unbound) doesn't have any Records (it's Unbound) and so can't have a New Record! An Unbound Form only contains Unbound Controls, for entering data. This data doesn't become a Record until it is committed a...
  11. missinglinq

    Subforms on tab controls that are on tab controls

    You are correct theDBguy...at least thru v2007. I found this workaround in an ancient file in my archives: The workaround for this is to create two forms. On FormA have your original tabbed control. On FormB place a tabbed control. This will be the tabbed control within a tabbed control...
  12. missinglinq

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

    I tend to agree with others, here, in that simple is usually better! You have to keep in mind that Access is for developing business database applications! You want your interface to be professional looking...not looking like a webpage or an online catalog! Color is sometimes...
  13. missinglinq

    Data Entry Form - Open Table Button - Current Record Not on Table

    Or better yet, in the same button you use to open the Table, prior to the code that does that, use If Me.Dirty Then Me.Dirty = False But as has been said...you really should replace the Table with a simple Form, such as a Datasheet View Form, that looks just like a Table. Linq ;0)>
  14. missinglinq

    Solved How to edit filtered records on a single form

    See if Allen Browne's article shines any light on your problem: http://allenbrowne.com/ser-61.html Linq ;0)>
  15. missinglinq

    Solved Activating a tab in a navigation, problem SendKeys

    Not sure what the SendKeys " ", True is supposed to be doing (?setting SendKeys to nothing?) but try replacing it with Sendkeys "{NUMLOCK}", True and see what happens. Linq ;0)>
Top Bottom