Search results

Thanks for that.. I had got there before I saw your amended post....I enjoy a challenge. Much appreciated.... Code Dim Outlook As New Outlook.Application Dim NameSpace As NameSpace Set NameSpace = Outlook.GetNamespace("MAPI") Dim ContactFolder As MAPIFolder Set ContactFolder =...

THanks for that. I had thought about that however I am not to sure how to send the data to a table.I would want it to be a temp table which would be overwritten each time this COntact data is collected. ANy clues would be great. Regards IC

I have written this code, below, which populates a list box with outlook contact items. This is working very well. I have the List box row source type set as Value List. The code simply builds the Row source string and inserts. The issue I have though is that the list is not in Alphabetical...

I have a worksheet that every month when running a month roll over VBA code, creates a new month column on the right side Therefore increasing the number of columns. I have frozen the left hand column with the row labels. I am using code in a form to go to the particular worksheet however I...

I have a database that is built in Access 2007. It utilises a nice command "Docmd.RunCommand acCmdAddFromOutlook" which opens a browse window of outlook contacts and then imports selected contacts into an Access Table. My problem is that the database has to be run in Access 2003 and this...

Using code I want to make a particular field null as a part of some other actions that are taking place. I have successfully done what I want when the form is set as Single form however when I change the form to Continuous the same code will make the particular Field null for the first record...

Hi All, In Access 2007 there is a built in Macro that has an "Add from Outlook" Macro which when used in conjunction with a contacts Table template imports the fields from Outlook Contacts into an Access table. This is a very nice feature. 2 issues however.... I have this button set on a...

Unbelievable......I just took your advise and removed all the locks that were on the subform I didn't want to edit. and bingo I could edit the other subform I need to.... I think I had set record locks on the first before I had created the second so I did not put two and two together...You have...

I had already tried that. I even locked the records in the query. This did not solve my issue however. Thanks for the suggestion though. IC

Hi All, I have an unbound form with 2 sub forms. The first uses data from a particular table via a Query and requires no data entry. This is basically used as a list of names to select the required record in my second subform. The second subform is using data from the same table as the first...

Thanks I will check it out.

I really just need to know if there is a way of testing if a control has currently got focus....I assumed I could do it like the test for null ie.. if isnull(Textbox) then dosomething endif I have tried if me.textbox.setfocus = true then dosomething endif however this is also...

Hi all, This will be a quick one...I have searched and cannot find this. I want to test if a particular control has the focus eg if gotfocus(mytextbox) then dosomething endif the gotfocus(mytextbox) is not correct I know...can someone tell me what is correct top do this. Thanks

Before you click Enable you can go to the Allow location area and drop in the directory that you want all Access databases to be allowed. I did desktop and all sub folders and my main work directory. Doing this will stop the Enabling process every time you open the database...

Hi there, I found a solution to this problem. Thought you might be interested... In between each DoCmd.OutputTo acOutputReport, "rOldBooks", acFormatSNP, Filename, False you need to set the focus back to the form that is running the code ie DoCmd.OutputTo acOutputReport, "rOldBooks"...

Hi there, I am having the same problem as you have indicated...I noticed that you did not get any replies....Did you mange to find a work around...? Any help would be most appreciated Curry...

This Works perfectly....Thanks for your help... :) Curry

Hi All, Below is some code I am using to check that a selected DB is the appropriate DB to import a data table. I use a public function PromptFileName() to select the DB and the path of where it may be sitting, which could be any where a user saves it. I want the selection to be checked before...

Fixed it....I had the subform Record Source set to a query.This is fine if just viewing the record but not when updating...I changed the record source to directly to the table as the extra data from the query was not needed and the Write Conflict has stopped and all updates as needed....Phew...

Thanks for that..however no go...returned another error which basically said Access was unable to update record...????