Search results

Please disregard my prior post, as the problem has been solved! :)

Hi Minty: I downloaded the database with the search box that you added and this is exactly what I want, but with a slight modification. I am retired and keep a membership database as an unpaid volunteer for a non-profit organization (we are all unpaid volunteers). The only other thing I would...

I would like the cursor for all forms, etc., queries, etc., to be by default, on the search bar above the status bar in Access 2007. That is the section that has three boxes -- the record # box, the filter box, and the search box. Right now the cursor is on the first field of any form, etc...

Thanks very much. It works now, exactly as I want!!!

Thanks, I tried using this (It's Dmax not DSum that I want, but for syntax questions, I guess it does not matter). Anyway, I tried just this: DMax("MembershipYear","tblMembersTrans","MemberID") and the returned result listed the one member maximum or last membership year was 2016. That is...

I am trying to get the DMax function to work differently than it is working. I am retired and do volunteer work for a non-profit organization, as a Membership Chairman. I have two related tables: tblMembership and tblMembersTrans. The Membership table has all membership data, such as...

Problem Solved -- I did a little research and learned about using an update query. That solved the problem.

I decided to have the entire database affected, and thus did not use the MembershipYear > 2008. I looked up Google, as suggested, and also tried to use syntax that I found in other VBA code in my database, that was written for me by others. This is what I did: Function...

Hi: I would greatly appreciate it if someone would please convert the following into VBA code for an Access 2007 field on a form. It is needed to create a conditional default value based on another field's category: (Note: TransType, MembershipYear and Dues are field names and are all on the...

Thank you very much, CJ, that does solve the problem. :)

Hi: In a transaction table, I have a currency field. When its Format was Standard, and Decimal Places was 2, if I did a copy of the table, which appears on a form together with data from a main table with names, addresses, etc.and pasted it to either MS Outlook or MS Word, the cents, even when...

Hi: I just noticed that the code failed to work now that we are in January and the current month = 1. I found the error and I'm posting it here, really for myself, because I've been copying this thread by saving the webpage, complete onto my computer so as to have it for reference. Anyway...

Hi Plog: I corrected the query. Incidentally, all of those redundant and contradictory statements did look strange to me; however, Access automatically put them in when I added (pasted) the complete where statement that you wrote for me. So, I guess Access did not translate it well. Anyway...

Hi Plog: I did that and researched a beginners book and was able to correct the error. However when I open the query in question qryMembershipMailingListNEW it opens without any error messages, BUT, it does not work properly. The database originally had a few hundred records. I deleted all but...

Hi: I finally got around to trying the above suggestions. I made a copy of the database to work with. I added the two new fields and updated all records to include the data for the new fields. I also created a revised form and MailingListNew query. I copied and pasted the above codes, the first...

HI Plog: You're right that the setting up would be more work than that which I do manually, especially since we only have three regular mailings per year. However, your solution is a perfect way to accomplish the task, not just for the one member but is universal for any and all current or...

Hi Plog: First I'll clear up the apparent inconsistency. I have on occasion forgotten to run the query that shows an error situation; that is, the archived box is checked ("true") but there is no archived reason (ArchiveReason is blank). When I run that query, if any such inconsistent records...

Hi Plog: Thanks for your reply. I am an unpaid volunteer (as is everyone else) for a non-profit educational organization. We have a paid membership and mail publications to members a few times a year. Some members are not required to pay as they have a special category status. Also, to...

I do not know VBA syntax or how to properly set up programming using VBA code in MS Access. I would like to automate changes to two records in the database depending on the current date. The situation is that I have two records for one person (each with a different primary auto number field)...

Hi. I'm not sure by table structures if you mean the properties, etc. of each field. However in message # 9, above, I have attached the database (sanitized to eliminate the members' last names, addresses, etc.) in a zip file. In that file I had tried the query again, using all 3 join methods...