Search results

Can anyone suggest why I'm not getting a response to registration from UtterAccess? Does it usually take a while to get a 'registered' confirmation email from them? I registered 2-3 hrs ago, and no sign yet.

I see you were contributing to the thread on UtterAccess, the question was posed by Mike60Smart, and is actually my problem, which Mike was kind enough to take on and (with a heap of code from Daniel Pineault) return with an almost total solution for me. It only remains for the code to be...

Is this not just attaching multiple files to any or all emails? I don't see any selection based on Boolean fields (in the Member table)?

Does it usually take a while to get a 'registered' confirmation email from UtterAccess? I registered 30 mins ago, and no sign yet. I'm hoping to ask for some detail in this thread: at utteraccess.com/topics/2066496/... The code is working great as it is, but I need optionally to add another...

So it's not about making it easier for us to know one thing from another, and all about uniquely identifying the right file to attach to the right email. Am I right? (Which [did I say earlier?] is very important, as I must follow GDPR rules, of course.)

" Trick is to use data in your member table to name things, that way you'll use the same name for the attachment. " Could you spell that out for me, please? with an example, perhaps.

Thanks - very sensible. The image of the membership card is not important, but renewal paperwork, currently consisting of pdfs printed and posted, is what I need to replace with emailing if possible. Previously differing members have had slightly different data and in some cases additional...

Sorry for the delay in responding, and now of course, I'm short of time! I'm not good at programming, but see there is the EmailDatabaseObject macro. Is it reasonable to use another macro to cycle through the output of a query, or better, perhaps, to use a macro to cycle the query through that...

Until now the database generates a report of one A4 sheet per member which is ('printed' to pdf, and then) sent to someone else to print on paper. Some members require more than one different forms. (If the email process will work, then it won't matter that some members get unneccessary forms...

Yes! , and you've made me think about it and realise the Qualification_Category is not just for Observer level, it works for all qualifications. All Members are qualified, and all qualifications are held by Members - or those other ContactTypes who [historically] held qualifications (e.g...

Local / national. -- There are many groups already in existance, I have wondered what they do / how they do this. Yes it would make sense, be potentially kind and thoughtful to make it available, but whether they want to change or can is another matter! TBH I really don't want to take that on...

Sorry, George, I forgot to thank you for moving my question to here. Thanks.

NB I'm only dealing with a local group affiliated to the national organisation. Given that each post and each qualification has a start date and an end date, what will the IsActive flag add? I think the membership side of things is all in order - obviously you are not seeing all the fields...

Thanks for your reply. I'm surprised at your reaction to my diagram, as it is just as I was taught in higher education by people who had come from deploying RDMSs in a national industry. 'Do your data analysis, and figure out your relationships diagramatically before attempting anything more'...

...and should i post this in: theory-and-practice-of-database-design instead?

I'm working on a database I've inherited which has successfully worked for a local group belonging to a national organisation of Advanced Drivers. It is largely based on one table of member details, not attempting to record any detail of members' qualifications nor who held positions [and when]...

Thanks, I wanted confirmation that my proposed relationships were good, which they are. :) Now knowing that, The implelmentation will be quite easy.

Interesting points but unneccessary in this case, thanks.

Many thanks. I appreciate the extra points.

SORRY I didn't mean to post this as a sticky! Admin, please move, as I don't seem to be aable to delete it. (Embarrased!) I expect to take over a datavbse of 'club' members, actually a local group of a national association. This local 'club' has its own committee, with a chairperson, treasurer...