Search results

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

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

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

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

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

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

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

Hello there, I have a combobox in a form used to bring up inventory information, by Item Description. Several of the items have apostrophies in thier discriptions. When I use the combobox (using FindFirst), to pull these up, I get an error. I've no doubt that the apostrophe is causing the...

Hello everyone, I'm trying to import data from our current Database Pro v1.0 DB to an Access DB that I'm creating. Our DBPRO is essentially a flat-file data entry program. It has a "subform" for history events that isn't actually in it's own table, but all concatenated in a single [History]...

Hello everyone, I need to run a line of code that checks the "TempPurchase Order Entry" table for duplicate [Product Code]'s. If there are duplicate [Product Code]'s, I'd need a msgbox to come up for user verification. Thanks so much for your help! Ben :)

Hi Everyone! I'm having problems and am frustrated as usual ;) I'm trying to select a specific row in a listbox in the OnKeyDown event on my form. Basically, while in a subform, I want the enter key to move the focus to the list box, specifically to row After the last selected. Here's an...

Hello, I have a report that I would like to group/sort by [Brand]. The problem I'm facing is that for this report, I need the Brand to be listed in a specific order; niether acending or descending. Is there an easy way to list the order I would like the brands to be displayed in? Thank you so...

Hi everyone, I have a report whose query criteria is set to a series of comboboxes on the form that opens it. I can get the comboboxes to work great together using Iif statements, but the one problem I'm having is with the date. I have two fields on my form that I would like to be able to...

Hello everyone, I'm trying to create a criteria in the query of a report that is based off a text box in a form. It works easily if I just put [Forms]![Prod Sched (BP)]![TheLine#] in the Line# column of my query builder. My problem occurs when I don't want to specify a number and want to...

Hi everyone! I'm having a simple problem with one of my list boxes, or so it seems. All I'm trying to do is make it go to the next record in the list when I hit the PageDown key in a subform. I've tested the On KeyPress event and that's workig fine, I just can't seem to find a...

Hi Everyone, I have a report that needs to open with the Product.GroupKeepTogether property in the sorting and grouping section either true or false. This would depend on a toggle switch on the form that opens it. I can't seem to find out how to do this in code. I figured I could just do a...

Multiselecting Woes- Please help Hi Everyone! I designed a form a long time ago that has been working great ever since. Bascially I can double-click an item in a list and it will bring up a form based on the supplier of that item. Right now it will show everything associated with that...

Hello! All I need is a simple control on a form that counts down the number of days between the current date and 3/6/2004. It seems so easy and yet I cant figure out how to do it. Thanks for your help!!