Search results

Looks like that did it... I wasn't sure if all the () were something necessary for the way Access interpreted SQL. The final SQL statement to pull all the desired records ended up looking like this (beginning and end trimmed for brevity): WHERE (Members.[Date...

I'm guessing that I'm missing something blindingly obvious here, but I could use a nudge (okay, shove) in the right direction. I have a table with various member information... one field being 'Date Expires' and two more being 'Regular' and 'Life' (both Yes/No). What I want is to be able to...

Well, I got a little further on the VBA code... opened the Switchboard form in Design mode, found the button on the Ribbon that said 'View Code'... still can't find anything like 'doCmd.OpenForm'. This is the part of VBA that just baffles me... finding what property is squirreled away behind...

I guess what I'm trying to say is I don't know *any* VBA. So 'go into the form coding and look' doesn't get me very far... If I open up the VBA IDE, I see 'acwzmain', 'acwztool', 'database1' (what I'm working with), and 'utility'. 'database1' is completely empty - no drop down, no nothing...

And how/where do I find that and make that edit...? Thanks, Monte

... when opened from the Switchboard. Opening it directly from the Navigation pane works as expected (it opens as a Datasheet). If I try opening it from the Switchboard, it opens in the Form view, even though form view and layout view are turned off in the properties. As soon as I select...

See the attached screen shot... Thanks, Monte

Hmmm... that would explain why I wasn't having much luck even searching as suggested. There is what looks like classes (with stubs for several of the forms) and modules (for mapping addresses online), though. Thanks for the link... I'll try to read through some of that here in the near...

I'm trying to modify the Contacts.accdb template to suit my purposes - for the most part it does what I want/need. I'm having to hunt down a few places where apparently field names are referenced in some embedded macros, VBA modules, etc. and are giving me minor amounts of grief in the form of...

Dave (gemma), I completely agree... I don't think I ever insinuated (or at least I certainly didn't mean to) that I was planning on using names as even a composite natural primary key for that very reason - we *do* have several members with the same first/last names. I fully planned on using a...

DCDrake, Not sure I follow on the 'CIU Membership'? We have a similar issue with the spouse/partner issue... 'technically' the membership is for one person. A number of years ago the by-laws were revamped to recognize women members, not just 'wife of a member'. Most people seem to have stuck...

Boyd, Thanks for the link! If I'm following along correctly here, you're using a separate table for the payments, with a discrete record for each payment/transaction - which should allow us to check if a member has made a payment each year (identifying any lapses and whether it is a renewal or...

Hello, New guy here, go easy on me please ;) I'm working on re-doing the membership database for a local club of 700+ members (the old/existing one is in M$ Works). One of the things we've never been able to track very effectively is past membership. Currently we have people check on the...