Search results

Does anyone know how to add a signature to an Outlook template - not my own signature, but someone elses? I am trying to write a project in Access 2007 and use Outlook 2007 to write e-mails to a group of students at my college, but using the signatures of our department heads. I have tables...

I'm trying to set up a project for e-mailing notes to students at the college where I work, but am having trouble with the "Sent On Behalf Of..." piece of my code. I'm currently in test mode and so am using an office co-worker as my "guinea pig". When I try sending an e-mail to myself on...

I have created a little system that sends e-mails to several thousand students at our college. The system was designed for several counselors, with the students being divided among the counselors. Here's my questions: Is it possible to programatically change the sender name in my code to be...

Not sure if this is the right spot, but.... I'm wanting to take a text or excel file of thousands of e-mail addresses and perhaps via MS Access (Version 2003 or 2007, preferably 2007), e-mail messages to these e-mail addresses, but with using different sender names per every, say 1,000 email...

Not sure if this is the right forum spot, but.... Can you copy from a mainframe (VM/CMS) screen and then paste the copied info into an Access 2007 form or screen? If so, what's the best way to do it, and what might be some headaches to avoid? Thanks in advance!

DOes anyone know of a way to programatically remove lines of code from source code? Example: I have the following code: "********************** Start Blah **************** code line a code line b code line c code line d '********************** End Blah ****************** What I'm looking for...

I've got a database of documents, some of which have pages where there is nothing but the character "*" on an occasional page. I want to write a query that will process these documents, but ignore the pages that contain nothing but that pesky character, "*". If I wrote a query like SELECT...

I had asked this question a while ago, but got no response, so will try a different way of asking. On a report, I've got a text box with a bunch of alphanumeric data in it. However, the data appears to get split at the end of a line, with part of one piece of data on one line and then the next...

I've got a report that has several text boxes of data on it. In one particular text box, with "Can expand" set to yes, the data can be a combination of numeric and alpha, such as: 1, 2A, 3, 4A, 4B, 8, 9, 10, 11A, 11B, 20 and so on. My question, how do I prevent a piece of data from...

One of my users keeps getting the following message when he opens an Access file: "Security Warning: Unsafe expressions are not blocked Do you want to block unsafe expressions?" My question is, how can he turn off this warning? It is filling up a message log on his PC and since the .mdb's...

I've got a bunch of Excel files in multiple folders that I want to programatically convert to txt files. The folders are nested several layers deep, ie, \\LevelA\LevelB\LevelC\LevelD\LevelE\LevelF\uniquenameA \\LevelA\LevelB\LevelC\LevelD\LevelE\LevelF\uniquenameB...

I have a form that contains a field for inputting a date. I would like to have this date get transferred to Outlook's calendar as an appointment. My kicker is, I need to have this appointment show up on several people's calendars at the same time. Would I use a group concept in outlook, in...

I've got a really wacky text file that can contain a ton of verbiage, followed by several rows and columns (almost looks like Excel data), which in turn is followed by a bunch of verbiage, another several rows and columns of data and so on. Incidentally, the row and data portions of the text...

I have a report that contains several columns of data, and I would like to change the widths of some of the vertical lines on the report, but not all of the vertical lines on the report. For example, If my CtlDetail is "widget" or "wadget," I would like to place bold vertical lines around those...

I know how to create an appointment in Outlook from a form in MS Access with VBA code. My question is: Suppose the date and time in my Access table and form are changed..... how would I go about changing the date and time of the appointment in Outlook, using VBA? Would I have to somehow...

After you've created relationships between tables, does anyone know how to find the names of the relationships? Thanks so much in advance!!

I've got a piece of code that contains a few queries. My problem is that some of the queries work, while others give me a "Syntax error in INSERT INTO statement" message. I'm going crazy trying to figure out why some queries work, but others don't. If someone could take a look and offer a...

I have two tables..... one table is my "master" table, and the other table is a table of all of the records I want to delete from the "master" table. I tried setting up a query where I match up the records and then running the query to delete records, but it did not work. Does anyone out there...

I know you can manually delete table relationships in an .mdb, but I was wondering: Can you programatically delete table relationships? If it is possible, how would it be done? Thanks in advance to all you nice folk who reply.

How might I go about inserting a new field into a table programatically? What I want o tbe able to do is: Open a table Insert a new field, including its type (char or num) and length Thanks to all of you fine folks on this wonderful forum!