Search results

Good morning, I have been researching how to extract data from an .msg file into a text file and I have found some information which I was able to modify to achieve part of what I want, which is shown below: Function ReadmsgFile() Dim OL: Set OL = CreateObject("Outlook.Application") Dim Msg...

Hi thanks for your observation, Those code snipets were disabled when running the debug, but I've identified the problem I couldn't see it for looking, my Import specification was named slightly differently and so the glowwork text file wasn.t being imported in the automated actions but because...

Good day Folks, I'm hoping someone can help me here, I have two code modules that are constructed exactly the same with the only exception that they are picking up data from seperate text files in seperate folders. Please also note that I do know that they are both using the same Import...

Hi thanks for your response, I will take on board your observation and use your suggested method. Regards John lee

Hi Again, Thanks for your help, I have resolved the problem, I re-wrote the expression as following and got the desired result: ThirdLineAdd: IIf([strThirdLineAdd] Is Null,"x",[strThirdLineAdd]) Regards John Lee

Hi Thanks for that, done what you suggested and where the records for that field have no data it doesn't return any field length, of the 8 records 4 records return a fleld length which is correct because only those for records have data in that field and the other four return no information as...

Hi Thanks for your response, I don't know how to do that, can you give me a pointer please Regards John lee

Good day, I have written the expression below in my query and for some reason it isn't working, can anyone help please. ThirdLineAdd: IIf([strThirdLineAdd]="","x",[strThirdLineAdd]) What I am trying to do is if the third line address field has nothing in it, I then want to populate...

Hi, I'm not sure if this is the right place for this, but here goes anyway. How do I get the "Allow Full Menus" option back under the Ribbon and Toolbar Options in the Access Options window. because on clicking the button in the top left corner the "Access Options" button is no longer...

Thanks Gemma, I currently have a db in Access 2000 which I am moving to Access 2007, I noted that Access 2007 will not allow references to DAO 3.6 because of this reference was already reference : "Microsoft 12.0 Access Database Object Library" which is why I asked my question, I believe it...

Good day Ungle Gizmo, Thanks very much for that information. I'll check the references accordingly. Regards John

Hi Minty, Thanks for the clarification. Regards John

Hi Uncle Gizmom, Thanks for your response so do I keep the reference "Microsoft 12.0 Access Database Object Library" or change it to this reference "Microsoft DAO 3.6 Object Library" or can I keep the first reference and it will not complain where I have references to the DAO 3.6 object...

Good afternoon Folks, Can Access 2007 reference action Access 2000 reference objects, i.e. Microsoft 12.0 Access Database Object Library read and action microsoft DAO 3.6 Object Library. So for instance I have code written that references the "DAO.Recordset" and also has declarations such...

Hi I have some code which was written in version 2000 that will not run in 2007. Our IT is forcing us down the route of moving to 2007 and I've been encountering loads of problems, for now I'm looking to find out why the code below will not run in 2007. Any assistance would be most...

Hi I would suggest that you write some code that checks to see if there is any data in the source tables and if there isn't then don't execute the rest of the code, have it pop up a message to let you know that which ever table it is that has no data in it and that this is where you need to...

Hi, This may be just semantics but your error states that the table does not exist not your query, so perhaps a query is missing the appropriate table, queries can exist and can have a table as it's origin, but if that table has no data in it, then the query can not run, hence table does not...

Thanks JHB and Forthingslosh for your response, JHB None of the end users have new PC's or have been upgraded to new software [one of the first things I checked] As I keep backups of my database I deployed one from August and got the user to access it and it appeared to resolve but...

Good afternoon Folks, I'm hopeing someone can help me here. I have the following code written in one of my forms and all of a sudden when ever an end users gets to a certain point when entering data, the code trips out with the message "Can't find Project or Library" DataType =...

Hi vbaInet, Thanks for that most helpful. Regards