Search results

Hi, I can't answer your question about the Ribbon, but with regards to the close button within your form properties you can disable/turn off the Close "X" button. In the Form "All Properties" locate the property Control Box set this to "No" [without quotes], locate the property Min Max...

Hi pr2_eugin, Thanks for the pointer, problem resolved. regards John

Hi, I didn't think of that, I'll give that a go thanks Regards John

Hi, I want to send an email to different individuals and the body content is different for each individual, I'm getting a problem with the second part of my code: Dim olApp As Outlook.Application 'Declare the outlook application variable Dim olMail As MailItem...

Hi, Check that you have the references set see below: '============================================= 'References: 'Visual Basic For Applications 'Microsoft Access 9.0 Object Library 'Microsoft DAO 3.6 Object Library 'Microsoft Scripting Runtime...

Hi, I have another slice of code that you might also find of use particularly if you are only targetting one file which will always have the same name. Again you will need to edit in the appropriate places to change the code to meet your needs. The following code checks to see if the text...

Hi, I'm no expert but with the help of the experts on this site I was able to come up with the code below, which you might find of some use. This is my code for copying files to a new location and adding the date to the end of it. You will of course have to edit in the appropriate places...

Hi, No it won't work if the date is written as you have stated, perhaps you can encourage the senders to write the dates in your desired format, I know that wouldn't happen overnight, but if you don't ask you don't get. Sorry I couldn't be of more help. Regards John

Hi, I've just did a little bit of testing, I'm using Access 2000 but I've just imported an excel file that has dates in the format you specified for example: 21 August 2012 02 September 2012 11 October 2012 when I imported the excel file as a new table I then went into the design view and...

Hi, I assume that your report is based on a query, therefore in your query using a new blank columns enter the following: Field Row: Month([dtmDateStamp]) Criteria Row: Month(Now()) Show Row: uncheck the box so that this column doesn't display in your table unless you want it to in which...

Hi, Thanks very much for your help, I've followed your information and got it working now, I had declared it too many times, which was why the value wasn't coming through, it was taking the value from the latest declared variable. Removed all those not needed and it's working. Thanks once...

Hi, Does it have to have it's own module to be declared for global use i.e. Option Compare Database Dim StartTime As Date I tried declaring it before my code in my Process_01 module and ran my code for both Process_01 and Process_04 but the value did not come through! is there...

Hi, Thanks for your response, this may sound like I'm being a bit dense, but I've never done anything to do with Global variables, how do you declare a Global variable, how do you put the value into it and get it out of it? regards John

Hi, I have a number of Modules in my database and I want to reference some code in my first module from my last module and I'm having a problem identifying how I can reference the code I need in my first module. I want to obtain the value of the this code to carryout a calculation in my last...

Hi 555rage, I assume that your report is based on a query that pulls all the information that you want. Below is some code I have which I was able to produce with help from the experts on this site, that might be of some assistance in formatting the contents of your report into excel, it...

Hi Jdraw, Thanks for the tip, I pay that link a visit. Cheers John

Hi Yes, your right it does hide any errors like this one that might accur, I'll need to come up with a better way of dealing with that aspect. I have now got to the bottom of the problem and that slice of code actually doesn't do anything even in my other code blocks and because I had poor...

Hi, Yes your right it doesn't I even checked my code blocks that work and they don't return any values yet they fine the tif files, copy and rename them to the desired location, which is strange indeed. I commented out that line of code and tried it, it just goes in a forever loop. very...

Hi Thanks for your response, That's just it, in my first code block I have quotes around the File.Name and it works fine, in my second code block I did the same and I also removed the quotes GetAttr (File.Name) and when it runs the same problem occurs it's complaining that it can't find the...

Good day, I'm hoping someone can help me here, I two sets of code which are almost identicle, one works fine but I can't work out why the other one doesn't. The code structure for both sets of code are the same with some differences with regards to where they get their information from and...