A question for the experienced programmers on how to "release" updated versions of the same data base to the users frequently:
I am working on expanding the functionality of an existing Access data base (.accdb), which is being used on a daily basis by 1-5 users (never concurrently). I want to...
Thank you so much! I just tested this on a form and it works beautifully. (I just had to change one thing: it should refer to PK_Student, not StudentID I think). Will test on the subreport next.
Thanks CJ_London, that is a very useful and elegant function. If I understand it correctly, it doesn't _quite _ do what I need: I need the resulting string to exclude the record I am currently on, which my code actually does. I thought I only have a reference problem in my code or when I call it...
Hi jdraw,
I apologize for breaking protocol by posting 10 irrelevant posts. However, I didn't find another workaround. I had nothing to upload (as suggested in your reply), and the post was rejected for reasons I thought were not applicable. I was eventually able to post it - not sure what part...
Thanks everyone! You are all awesome. I have solved this with a combination of your suggestions. See code below, in case anyone ever wants to do something similar.
Note: this assumes the existence of a table called tblEMailTemplates, which has the fields EmailPurpose, EmailSubjectTemplate...
I am trying to add a calculated field called ‘txtWith’ to a subreport. This field needs to be present for all records, so it can’t be in the header or footer. The code that “fills” the field generally works fine elsewhere – I already used it successfully to calculate the same field content on a...
Thank you for your suggestions. I will try them and let you know how it goes. I was surprisingly offline for a couple of months, apologies for the delay!
I have a data base from which I can send emails via Outlook, using VBA. One use case is sending meeting invites. The information for the emails – meeting topic, date and location – is stored in tblMeetings. On the form that displays a particular meeting to the user, the user can click a button...