Search results for query: *

Hey, if someone wants to make this better, feel free. I don't have the time to so.... I was given a half hour to design a program for a non-native english speaker, who has problems with the intricacies of sentence structure, that would build and upload a webpage to an ftp server. This way...

I was searching today for a VBA script to take care of those words that are not supposed to be capitalized in the title of a book. I work in a library, and am typing them on a regular basis. I could not find one that was any good. So I gave up and wrote on myself (I hope others will put it...

That helps, but I run a conference center and we have thousands of appointments on our calendar, and that process works but takes several minutes to search through every single appointment item.

I have been searching and searching for any clue how to start. I have a code that adds an appointment to an Outlook calendar via Access (based on a record in a database). I need a way to find an delete a recorded added to in this fashion.

I am looking for a piece of code that will send messages saved in my draft folder in outlook, without having to manually go into the folder and do it myself. I am not sure where to begin. I am actually using Access to put the file in the draft folder. So ideally i would like to not have to...

Awesome Awesome Awesome. That is exactly what i needed Thanks

I am changing a record with the following code: DoCmd.RunSQL "UPDATE tblContact SET fax='" & Me!Fax & "' WHERE ContactID=" & Me!ContactInfo A confirmatin message box pops up every time, is there a way in VB to prevent this message box?

Within Access, I need to be able to isolate a particular record, in a table not at all bound to this form. And, in a specific field I want to reassign the value. I am dealing with the primary key of the table so I am sure of the particular record. Is there a way to do this in VBA. I was...

Oh, it is. That only prevents it from predicting what I am typing. I defenetly don't want that either, incase we have one group with the acronym "OSPI", and then we get another with "OSP". Thanks though.

I have a dropdown box, with the on key press event, dropping down the list. When a selection is made, other fields auto fill. The field is the acronym for a group. In the list the group name is also displayed. What I need is to be able to both, enter an acronym have the list scroll down to...

Does anyone have a code that will auto fill a combo box, with the first item in its list? I have a combo box looking up its info in a query, and that query is looking up info based on a field on the same form as the combo box. I want to have the combo box auto fill on lost focus. thanks

Does anyone know the code to make this work. I can get AppActivate to work with other MS Office Programs, except Outlook. does anyone have a suggestion. thanks

Does anyone know how to get this to work? here is the code I am using: AppActivate "Microsoft Outlook" I can get it to work for any other Microsoft program except Outlook. thanks

I have searched for quite a while, to no avail. Does anyone know a good thread that they could recomend for me?

I need code to check and see if excel is running. If so then activate it. If not then open a new spreadsheet and activate it. thanks

Here is the dilemma I have an Excel table with cells that contain multiple lines. Here is an example: ----------------------- Setup: Theater for 160 tables in back ----------------------- I need to be able store the first line in the cell as a variable (in this case "Setup:"). The text...

I am using the Find command to locate the first date in 2004 in a list. Then I want to delete all rows above that. The problem is that I have no way of selecting all the rows above that without having the computer know what row I am currently in. Is there a way to have this value returned...

I have not had any luck finding anything on the subject. Do you know of a specific thread that I should look at. thanks

I am trying to Automate Outlook to export the calendar to an .xls file using the Sendkeys function. My problem occurs after this code SendKeys "%ft{up 3}~{down 4}" It will not proceed to the next menu. I have tried sending an enter command a command to press "n", and even tabbing over to the...

Hello, I need to know how to set multiple cells equal to different columns in a singular combo box, with out using excel. Is this even possable thanks trace