Recent content by boein

Hi Andy, indeed all I want to do is to collect, store and evaluate data. But I would prefer outlook, because the data must be accessible for everybody (multi-user access). Also, everybody uses outlook but not everybody uses access. And a lot of data in the database comes from...

That looks very complicated. Maybe it's better to this application in access. Are you sure there's no way to get data from the form. It must be stored in some way right, so it must be possible te read it back. Kind regards Boein

Ok thanks for clearing that out for me, nevertheless I still have a question. Is it possible to get data from your outlook form by means of vba code that is put in your outlook form and how do you that. In other words I want to use the outlook form to put in data and retrieving it by vba-code...

Hi Gerry, You're right if you press ALT+F11 it's the same as in Excel, Word. But if you work with outlook forms you also have the vb-controls. When you look at the properties of each object 'view code' is missing. I guess this is something different? My goal is to create an outlook...

Hi, How do you assign vba-code to visual basic control-objects (commandbuttons, text-boxes, labels...etc) in Outlook 2003. In Word, Excel access it's quite easy but in outlook I don't see how I can do this, or is it not possible? regards, Boein

Hi, I have a vb6 program that calls a vbs-script. This program is run under a different user with admin rights in a shell executed by psexec. I choose to do this so the code in the vbs can be executed with admin rights while the main program itself is run with normal user-rights. Problem is...

Thanks, I found a way to do it, but I still have another problem. Is there a way to pass exit codes coming from vbs to vb6. My main program (vb6) calls a vbs-script executed by Psexec this script should give an exit code to the main program. Is this possible? ShellandWait "psexec \\" &...

Hi, I need a script to check the status of this parameter in AD, anybody idea's? It should fit in this code Dim objconnection, objcommand, objrecordset, objuser, objproperty Set objconnection = CreateObject("ADODB.Connection") Set objcommand = CreateObject("ADODB.Command")...

No, each user has 1 primarysmtp-address and several other adresses (aliases). Problem is the lastname of a user. For ex. given name: Pieter lastname: De Prutser e-mail made by Exchange: Pieter.DePruster@domain.com e-mail should be: pieter.de.prutser@domain.com mark the extra "." before the @...

Hi, I want to be able to use e-mail addresses in exchange 2007 looking like these ones: firstname.lastname@domain.com firstname.part_of_lastname.lastname@domain.com firstname.part_of_lastname.part_of_lastname@domain.com But exchange e-mail policy is preventing me to use these formats and sets...

Thanks alot guys, it works! Kind regards Boein

Thanks for your efforts Remou but still no fieldnames. When I run this code row 1 and 2 are the same, filled with data (probably the first record from the database). However still no fieldnames in row1. Regards Boein

Still doesn't work, program crashes at rs.Open strSQL, cnt I removed those lines and replaces it with Set rs = cnt.Execute(stSQL) this works, but still gives the data from the record not the fields. Any ideas?

No i'm not quite familiar with vba and ADO so I could need some help here. This is my code, in this code yo'll also find a piece of your code I changed to make it work in my application. It does work but colums are mixed. What am I doing wrong here? Private Sub CommandButton1_Click() Dim...

Thanks Remou, your code works. But still one problem, the fieldnames returned by your code do not correspond with the records returned by my sql query select * from table. I changed your code so it only returns the table I need, by something got mixed up with the order in wich they are...