Search results for query: *

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

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...

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...

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...

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...

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...

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...

Works well, Duane. Thanks!

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...

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...

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...

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...

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

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 +...

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

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...

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...

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

Nothing.

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...