Search results

Good afternoon folks, I am using MS Access 2000 and I would like to learn/find out how to write some code that will do the following: I have two drive locations as follows: \\prdfs01\prodreg (B: Drive) and \\qwima400\prodreg (E: Drive) The file structure under both directories is a...

Hi, I Hoping someone can help me as I’m having problems understanding how to write VBA to extract data from “.msg” files and import that data into a table in my database. I have over 5000 .msg files of which I need to extract the following information: First name: Tim Surname: O'Rourke Street &...

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

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

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

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

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

Good afternoon, I was wondering if anyone knew where Access 2000 project/library files are normally stored on a PC. Any assistance would be most appreciated. Regards John

Good afternoon Folks, I'm having some trouble with Access 2000 tables on importing into Access 2007 in that once I have imported them from Access 2000 into Access 2007 I get the following error message: "Security Warning Certain content in the database has been disabled" and there's an...

Good afternoon Folks, I hopeing someone can help me here. I have a spreadsheet that records timings for individuals processing times and I have a totals column that totals up those times, but because the time format will only calculate up to a maximum of 24 hours and then it starts again...

Hi I would be grateful for some assistance I want to convert the decimal number of 25.75 hours to proper time i.e. 25:45:00 I want to display it as 25:45:00 Any assistance would be most appreciated. Regards John

Good afternoon, I'm not sure if this is the right place to put this but here goes: I currently have MS Access 2000 and it is quite a comprehensive database that has been built over a few years. The company I work for are now moving to Windows 7 and a statement made was that MS Access 2000...

Good day, I have a bit of a problem trying to create a running total in my report, I get so far and then when I view my report I noticed that some records were not actually producing a running total. I have two tables one that stores the history of text files that exist and the fields are as...

Good day, The company I'm working for are planning on moving to windows 7 and therefore upgrading our current MS Access software from 2000 to 2007. My question is, can I just simply import all my Access 2000 objects including code into the Access 2007 and continue using it as I am now or are...

Hi folks, I'm struggle to find information on how to find the first space on the left of a text string, for examlple: I have this string : FUJIFILM XM-1 16-50mm BLACK and I want to find the space between FJUJIFILE and XM and then get all the text from XM onwards. I have this...

Good morning I'm somewhat struggle to create/find code that will count the number of text files in a directory with one level of folders please see below: Directory path is : B:\ First and only level of sub folders: there are 100 of these and they all end in ".fof" These .fof folders...

Good day folks, This is one for the experts I think, I've just been informed that our company is moving to windows 7 and also moving to software that is compatible with windows 7 which means that in a very short space of time I'm gonna lose MS Access 2000 and will be working with MS Acess...

Good afternoon folks, I hoping someone can help me, I want to extract specific data from a text file and place it in my table. The following is an example of the data: Display Author="All Saints" Title="On & On" Genre="Pop" Color="7693971" Tag="2" I want to extract the following: Where...