Search results

Thank you, I didn't realize that was what "splitting" deals with. I assume that wouldn't work with table schema changes though?

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

Let's see if it works.

But hey - whatever works

I had hoped for a more elegant solution.

Thanks for the suggestion.

But I'll try it.

That would be cheating!

Hi everyone, I was trying to post a question about sending emails with VBA. I was unable to submit the post - the error message said I couldn't post anything that contains email addresses (because I need to have 10 or more posts to be allowed that). However, the post doesn't contain email...

Thank you MarkK, will do what you suggested now that I know the design is OK.

Hello, I am designing a database to manage workshops with MSAccess 2010, and it is not behaving as I expected. I am sensing I have a problem with relationships. The purpose of the database is to manage workshops. Each workshop is held at a specific facility, and we have workshops at the same...

Hello everyone, greetings from the West Coast of the United States. I am currently building a database using MS Access for a non-profit organization. It's not that I don't know anything about databases - I feel I know just enough to be dangerous. I am a little overwhelmed with the project and...