Search results for query: *

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

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

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

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

Hi, I have a subform that jumps to a record based upon a combo box. That same combo box shows the first object in it's list after I update a field in the main form. My problem is that the subform wont jump to the record displayed in the combo box, unless I actually manually select it. This...

Hello, I am looking for a way to autoexport the calendar in outlook to a Personal Folder File (*.pst). I know that you can set outlook to autoarchive, but that would also remove past "Appointments". With the Import/Export option they remain where they are, while a backup copy is...

I have a report that is referencing a table of reservations. The report sorts by date of reservations. My problem is that if there are no reservations on a date then the report does not list the date. I want it to list the date, but have no records Beneath it. Is this at all possable...

I have code to send specific data from Access to the Outlook Calendar, but i need to know how to have it use a specific Outlook Form. Right now it uses the standard form "Appointment." I have designed another form to use in the calendar, but I don't know how to tell access to use it...

I was wondering if it is possible and how, to view multiple folders in Outlook Calendar? I run a confrence center and we have 4 room that we rent out, and i need to see the daily schedual for all 4 rooms at the same time. Thanks

I have a Program that Enters data into an Access Table in several cells. I need this data stored in the Outlook Calendar as well. Editing the original program is not an option, so i need a way for Access to automaticly send data to Outlook everytime the new data is entered into the table. I...