Search results for query: *

I am not sure where to start. I need a piece of code to put in the "thisoutlooksession" that will set the font in the body of a new email or change the theme to "no theme". Any help is greatly appreciated. Thanks,

I have searched everywhere and cannot find if it is possible to Import Contents of XML file to a List box. The XML file i am using only has 2 lines I want imported to the listbox. Does anyone have any ideas? Thanks,

I just cannot get this to work. I have tried so many different ways. Here is my latest attempt. I want to copy - "Range("A11").EntireRow" to the last empty row on the same sheet. "objWorksheet.Range("F65536").End(xlUp).Row" Range("A11").EntireRow.Copy r.Row Code...

When importing an Xml file into Access using VBA, can you direct the data to a specific table? When I perform the import it is creating a new table based on the Xml file. I would like to be able to direct it to the table I have previously named. Any help would be greatly appreciated. Private...

How do you add additional data to existing data without wiping out the original data? If I had 20 records and I had a field call datesm which was a list of date and wanted to add another date to all 20 records, what is the proper way to do it? 1/1/2009, 1/1/2010 so how would a create a query...

When some of our different computers open my database, it strips all the VBA code from it. Does anyone know what causes it? I finally just write protected the Front-end to prevent this from happening. Thanks, Ron

I would like to be able to add a progressbar to this code as it searches, but all my attempts results in the bar being updated at the end of the search instead of during. For Each foundfile As String In My.Computer.FileSystem.GetFiles _ (PathDrawings...

Here is what I have: ======================== Query: ======================== SELECT MsysObjects.Name FROM MsysObjects WHERE (((MsysObjects.Name) Like [Enter Work Order] & "*") AND ((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1)) ORDER BY MsysObjects.Name...

I need the best method to combine mutiple tables. I want to combine 5 tables into a singe table. I have tried sever ways without success. Can it be done with VBA? Thanks

I have a report that is based on a query. on that report is a subreport based on a query. I need to take the (10) resulting fields from the subreport and change the colors based on thier numerical value. With the code below it changes all the fields of the subreport. How do i isolate only...

Using Access 2007 and the Docmd.Sendobject command I send out a pdf, but I cannot find a way to name the pdf being sent. I do not want to use an Outlook reference and go that route since a lot of people here have different versions of Outlook. Is there a way to name the pdf? DoCmd.SendObject...

I am trying to debug my database that has a Pareto chart in the report. When you open the report it asks you for a start date and an end date. Good record dates are 1/1/09 & 12/1/09. If you enter these 2 dates you get your pareto chart. My problem is that it asks for the dates twice. Start...

Here is what I have toyed with: If Check97 = True Then Forms![CAPA Form].[CAPA Title].Locked = False End If Access does not like this format. I have tried "Me.Allowedits = False" but then everything is locked. Any ideas? Thanks,

Does anyone have the proper code to click a button and send the document in an email in pdf format. I have tried the macro recorder, but it does not capture that event. Below is all I get. Sub Macro3() ' ' Macro3 Macro ' ' ActiveDocument.ExportAsFixedFormat OutputFileName:= _...

The code below is for Outlook. It takes a highlighted email and copies it to a directory on our network. If the directory does not exist it creates it and copies the email to it. The problem is that the directory it creates cannot be deleted by windows. I have to use a program called...

I wonder if someone can help? I have this code to do a search for a number in my spreadsheet. The number is stored in column A. Once It finds the number I would like it to go across the row it found my number in and open a link to a file in column L. Can anyone help? Sub SrchBk() Dim ws As...

I have a Userform in outlook and I want to be able to reight click on a field and paste into the textbox. The problem is the right click does not come up in the textbox. Any ideas? Thanks,

The script below moves Read emails to the Personal Folder creating a folder with the sender's name then puts the email in that folder. I can't seem to come up with a way to leave emails 30 days old or less alone and do not move them. Outlook 2003 Can anyone help? ====================== Sub...

I have a script that searches files using an inputbox. What I want to do is have it search, complete the task, handle the results and start the script from the beginning for another search. Basically re-start the script from the beginning. I cannot find the right command to achieve this, does...

I have this code that will Export an entire group of email to an Excel sheet. What I need it to do is Export a single email that has be highlighted. I can't seem to make the changes. Can anyone help. Thanks, The Code ============================ Private strTemplatesPath As String Sub...