Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. THWatson

    Command buttons not working

    I finally solved it. After poking around, I discovered that the Trust Permissions didn't carry over. Once I set the path for the Trust Permissions, everything works. Thanks. Tom
  2. THWatson

    Command buttons not working

    Using Office 365 I had to change computers. I copied a database (front and back end) to a USB drive, then put it on the new computer. When the database opens it goes to a Switchboard. From there I should be able to navigate to a number of other forms, using command buttons. But none of the...
  3. THWatson

    Writing a value from a form into a subform

    Thanks, Duane The six fields in tblAwards are the awards that the Kiwanis Club has available to present. An additional award could be added but, historically, these are the awards. The most common is "Legion of Honour" which is first given when a member has been in the Club for 25 years and is...
  4. THWatson

    Writing a value from a form into a subform

    Darrylles Could be the case, but I can't seem to rectify what the problem is. One table is tblMembers. It keeps track of various pieces of data regarding members, such as MemberID, LastName, FirstName, (plus other biographical data), LegionofHonour, LegionofHonourYear. tblAwards is simply a...
  5. THWatson

    Writing a value from a form into a subform

    This is a database that tracks information for members of a Kiwanis Club. On frmMembers, there are five tabs, two of which are "Membership Data" and "Legion of Honour." The Membership Data tab has a number of controls, plus a subform "fsubAwardsGiven." The subform has four controls: Award...
  6. THWatson

    Procedure for Message Box if value entered in text box has not been assigned

    Andy There's a difference. As soon as the user begins to type in an envelope number, the combo box begins to shift accordingly. For example, say the user wants to check Envelope # 719, as soon as she types 71 you're in the right numerical sequence. That works...unless I have gotten myself far...
  7. THWatson

    code to update list box with results of text box

    Andy Thanks. I must apologize, as I thought for certain I had given Duane a star. Anyway, I have done so now. I also gave you one just now as you have persisted in trying to help, and appreciate your suggestions. Actually, in the end, after I got the Text Box all worked out, I decided - upon...
  8. THWatson

    Procedure for Message Box if value entered in text box has not been assigned

    Works well, Duane. Thanks!
  9. THWatson

    Procedure for Message Box if value entered in text box has not been assigned

    Duane That's an idea. Right below the text box is a List Box with all the assigned numbers. I made the text box so the user didn't have to scroll down through all that list box. And both work fine and populate the subform. My attempt now was to add a message box when the user entered an...
  10. THWatson

    Procedure for Message Box if value entered in text box has not been assigned

    A form, which has a subform, to edit donations from church donors. In a form, the user can enter a number in a text box. If the number is valid, the subform is populated with data. What I want to do is have a procedure so that if the number entered by the user is not valid, a message box comes...
  11. THWatson

    code to update list box with results of text box

    Duane Thanks so much for sticking with me through this. I don't know what I would do without expert help. It looks as if I have everything working fine now, and can return updates to the user. As for the difference between being "retired" and not, it is that I don't get paid for anything...
  12. THWatson

    code to update list box with results of text box

    Well, I finally found it. On the property sheet for the main form, frmEditNewGivings, click to see the properties for fsubNewGivings. The Link Master Fields line shows: Forms!frmEditNewGivings!lstEnvelopes The Link Child Fields line shows: EnvNbr That is what has been blocking the text box...
  13. THWatson

    code to update list box with results of text box

    I'm wondering where the Link master and child field lines went in Access 2016? I have only been using Office 2016 for two weeks, and some stuff has changed. Searching on the internet, I can only find references to Access 2013. My version is Office 365, so maybe 2016 and 2013 are the same. Tom
  14. THWatson

    code to update list box with results of text box

    Duane I apologize. I didn't answer your question about the linking of child and master fields in the subform fsub.NewGivings I have looked all through the subform's properites and I can't even find a line for linking child and master fields. Yes, EnvNbr is numeric. As for being aware of Ctrl +...
  15. THWatson

    code to update list box with results of text box

    I tried adding this line to the beginning of the After Update code for txtEnvNbr Me.lstEnvelopes.Value = Null Doesn't change anything. Tom
  16. THWatson

    code to update list box with results of text box

    Duane Here's what I see when I press Ctrl + G SELECT EnvNbr, [Date Given], Local, [M and S], Building, Memorial, Other, InMemoryOf, ToFund FROM tblNewGivings WHERE EnvNbr = 719 ORDER BY EnvNbr, [Date Given] SELECT m.EnvNbr, m.[Date Given], m.Local, m.[M and S], m.Building, m.Memorial...
  17. THWatson

    code to update list box with results of text box

    Duane Here is code from the List Box...and this works fine. Private Sub lstEnvelopes_AfterUpdate() Dim sql As String On Error GoTo lstEnvelopes_AfterUpdate_Error sql = "SELECT m.EnvNbr, m.[Date Given], m.Local, m.[M and S], m.Building, m.Memorial, m.Other, m.InMemoryOf, m.ToFund " _ & "FROM...
  18. THWatson

    code to update list box with results of text box

    Yes, I see the message box. And yes, the code compiles. Tom
  19. THWatson

    code to update list box with results of text box

    Nothing.
  20. THWatson

    code to update list box with results of text box

    Well, I certainly appreciate all the help...and I have corrected the typo in Andy's code (which I should have caught myself)... BUT Truth is whether I use Andy's Code or the string filter supplied by MajP, the results are the same. I plug the value in the text box, press the <Enter> key, but...

Part and Inventory Search

Back
Top