Recent content by HansGermany

Hallo, I'm back! I know now the english name for the german word 'kürzen'. It is 'TRUNC'. This to the earlier answer a few minutes befor (see above!) Hans Porzel from Steinwiesen / Bavaria / Germany

Hallo, there are two ways for looking to a week-number: a.) by VBA (VisualBasic for Application) and b.) Normal with the standard-functions I'm from Germany and I use following standard-functions: =KÜRZEN((A1-WOCHENTAG(A1;2)+11-("1/"&JAHR(A1+4-WOCHENTAG(A1;2))))/7) Now I try to...

Hallo, I'm a German and sit here in Germany. My language-skills are not so good. But when I right understand your question, then is the solution for you in this case the function 'VLOOKUP'. Carry out following steps: 1.) List in a new sheet all your data. May be so: wage...

Hello, may I help you with a competent adress, where you can find a good answer. Look at www.spotlight.de This is my favorite for office-solutions. Bye! Hans Porzel from Germany

Hallo friend, first of all, MANY THANKS! But I can't believe this, I looked in the 'Microsoft Press Book' again. There I saw a picture, where it was possible. So it must be go!! Now I try it again. And I have found the solution!!! Microsoft-Access-(XP) can have a DYNAMIC ACCESS to the...

Hallo, MANY THANKS for your information! I'll try it! Bye! Hans Porzel from Germany

Hallo my friend, this was NOT the problem. If I do so as you described, so I have only static, no dynamic, access to my project-file. I mean if I do follwing steps: 1.) I have on my harddisc a file, may be, test.mpp 2.) I start MS-Access XP 3.) In MS-Access XP I choose FILE / OPEN -> All files...

Hi friends, I send this question from Germany and my writing is not so good. But I hope you understand the following text. Is it possible, if I click on a task in the GANTT-view, so it shows me the actual task in the diagram on the right hand side. I know I can do this with a extra click in...

Hi friends, I'm from Germany and my writing is not so good, but I think you could understand. I use MS-Project 2000 and MS-Office XP. When I will have direct-access with MS-Access XP to my MS-Project2000-file, then it is not possible. Why?! Thanks for every answer! Hans Porzel from Bavaria...