Search results

I'll give this one bump since I really need some help. Thank you.

Hello folks, I'm trying to write a line of VBA code (in an existing Access 2010 DB) that changes the Subject Line of all selected emails in my Outlook Inbox to today's date. I have researched this and have not been able to find a simple solution. Please help! Ben Bolduc

Hi David, Thank you for your reponse. I will likely bring the data into tables for more in-depth analysis in the future, but for this specific application I actually want to change the subject lines. We use "In-cell editing" to change the subject lines of all our emails (for standardization...

Hi folks, I'm trying to automate some processes and need some help to get started. My company uses Outlook 2010 and every day we need to go into our "Sent" folder and rename the Subject line of all of our sent emails. We change the subject to a standardized format depending on the content of...

Thank you so much, this worked like a charm. Please forgive me if I sounded lazy, I was very tired when I wrote this. Works flawlessly! :) Ben Bolduc

Thank you, that is encouraging to know it's possible to do what I need to do. If anyone would like to help me get there, I would be very grateful. :)

I'm afraid that web site was not helpful. Does anyone have any other suggestions? Thank you!

Hi Folks, I need to retrieve the count of emails in a shared exchange mailbox in Outlook 2010. I found the following software that retrieves the count I need, but only in default folders or ones that are 1 layer deep. The folder I need is two layers deep Mailbox -> Inbox -> Completed. Is...

Ok, I found somewhat of a solution even though it doesn't make sense. I'll share it in case someone has a similar problem in the future. In order to get the forms to open up without shrinking, I had to set the the AutoResize = True and then save/close the form immediately. (Though I'm not...

Hey folks, I don't mean to pester about this. Are there any other resources that could perhaps help find a solution to this problem? Thank you so much for any help you could give.

Hi everyone, I've noticed an alarming trend in my database design. (Access 2003) Suddenly, every time I make any change to a form that has both the "Pop Up" AND "Modal" properties set as "Yes", the form will shrink to a tiny box upon opening. If I stretch it back out, save the changes and...

I'll give this one bump. I was hoping it would be easy, but I may just need to take a different approach.

Hi Everyone, I have somthing I know should be relatively easy to do, but I can't find it in the forums. (I found a post on HTML, but I couldn't get it to work with a spreadsheet). Here's what I'm trying to do: On click, I'd like an email auto-generated, (using Outlook), with some basic...

Thanks for the tip! I looked up the Name Statement and it was actually very easy. I just didn't know where to look before. As for the Primary Key, why is it not ideal when the value can change? Does it mess up the indexing or cause preformance degradation? Thanks for your help! Ben

Hi Everyone, I've recently set up a feature that creates a folder on our server for every customer we have in the DB. It is working great, but the problem I'm having is when we need to change the Account Name. The Account Name is the primary key throughout the entire Customer Service DB...

This worked perfectly! I couldn't have asked for a better solution to my problem. Thank you for taking the time to post. :) -Ben Bolduc

Hello everyone, I'm working on a customer file management system for our database. The purpose is to provide a quick link to all of the files within a customers specific folder. Open selecting a customer, a folder is created using the [Account Name], (If it does not already exist.) You can...

Dear Microsoft Access I just wanted to take a moment to express my undying love for you. You make data fun! I'll never let go Access, I'll never let go... :D Love Always Ben Bolduc

Pat, I appreciate your personal attention to this. I'm afraid Im still a bit of a novice when it comes to SQL progamming. I usually relay on the nice, friendly query building screen lol. Where exactly do I put this code to make my Combobox work? Thank you so much, I look forward to hearing...

Hello everyone, Im trying to set up a combobox on my Customer Contact Information form, where you can enter a phone/fax/cell/pager or any misc number, and it will bring up the appropriate customer. Is it possible to make a query that will show the different phone number fields as one field...