Recent content by Dan_T

Ok its all sorted. The problem was with my MDAC. Took half the day to resolve but I found a useful site that offers some help on the subject. By following the instructions there I rectified the problems with MDAC I had outlined before. For future reference the site that helped is...

In addition further looking at the results from the MDAC component checker I have 20 registry settings not found and 8 Com objects not found... I have searched around this forum and google and not found an answer as to whether this is an issue or what to do if it is. well none that I understand...

Right i think I need some help understanding my MDAC installation. I have downloaded and run the MDAC component checker and the results don't seem to be perfect. It looks like I have some files namely MSADCO.DLL msado15.dll MSADIMD.DLL MSADOX.DLL MSJRO.DLL msxml3.dll shown in the results colum...

tehNellie I am picking up with this again this morning. I will post back how it progresses.

haha not at all. I appreciate the replies.

Thanks for both replies. Modest, although the code compiled execution doesn't get beyond the first line. tehNellie, As Modest says I don't think I need it as I am using the New keyword. However I did try the code example you posted and the same problem arrises. Not progressing further than...

Hi, I am having my first real stab at calling stored procedures from Access and I am having some difficulty getting past what seems like a silly hurdle. I have built a very simple stored procedure to return a single value from a table. I have tested the sproc in the query analyser and can...

Meltdown. Actually with further thought your idea may well be the answer. I have been playing around with it and it works. There is one but which you or someone may be able to help me with. Its the speed the search is conducted. Possibly a question for the outlook forum really. The issue is that...

Hi thanks for the reply. I was hoping to have a restricted list of emails to a criteria in outlook rather than view an inbox and search from there. From the option you suggested can I summise that I still need to manually perform the search? It's this I want to avoid. I have since found this...

Hi, I have a requirement to find emails from a particular sender. The way I would like to do it is to create an instance of outlook and automate the find function. Therefore displaying the found emails within outlook so the user can carry on from there replying or whatever to particular emails...

Am looking for pretty much the same thing I think Paul. I want to display emails sent to and from the current contact in a CRM application. Thats fine can list all of those but how do you open the specific email to read and perform an action on? Many thanks, Dan

sure. Give me an email address and i will send it to you. Dan

Hi modest, the way you suggest is essentially how it is for the queiries. For i = 0 To db.QueryDefs.Count - 1 'Action for each in here. Next i I was confused as the d variable didn't appear to be set anywhere but knowing you can learn something new every day and ghudson...

I've tried stepping through it and the parts for both forms and queries work fine. Errors occur for the steps for any part using the d variable for documents (Forms, reports, scripts). So I set a break point at the line: Set c = db.Containers("Forms") 'Declared Dim c As Container This...

Hi I am having a wee bit of trouble with executing the function: ExportDatabaseObjects() To me it looks fine but at this line. For Each d In c.Documents I get the error: Error 13 - Type Mismatch. Up until this point all is fine with the world and the tables and queiries are...