Recent content by Di0genes

Windows NT Server 4.00.1381 or Windows 2000 Server SP3 MS SQL Server Standard 2000 (SP3) What could be the reason for the following behavior: We use 4 SQL servers in 4 different locations. Each of them could be administered by using the Enterprise Manager. I'm able to create tables or...

Hello, I replicate per merge replication a database on 2 MS-SQL Server 2000. Without changing anything on both servers the replication fails since 2 days. The error message is: Error: Der Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen. Translation: The...

replace + CHAR(69*@isUpCase) by + CHAR(69+32*@isUpCase) -- Char(69+0)="E"; Char(69+32)="e"

Hello, i need for an export to querry names without german umlauts. I may not use VBA in this case. Therefore I wrote a user-defined function. I would optimize these gladly - if that is possible: <pre> CREATE function fn_Umlaute (@strFeld nvarchar(120)) returns nvarchar(120) as begin...

Hello, the only possible solution is a timer event whitch check a entry in a special table on your backend. A other solution is, to check who is logged in to your backend and send a Msg per "net send". thats it Regards

Yes, its possible: CurrentProject.OpenConnection str_Connection, User, PW is the thing you are looking for. Regards Diogenes

Hello, if you want to have a simple solution, just copy the part with the different connectionstring to a onclick of a button: str_Connection = "PROVIDER=SQLOLEDB.1;" & _ "PERSIST SECURITY INFO=FALSE;" & _ "INITIAL CATALOG=NameOfYourfirstDB;" & _ "DATA SOURCE=NameOfYourServer"...

>Hello, > >lock at my former post to this question: > >http://www.tek-tips.com/viewthread.cfm?SQID=556609&SPID=958&page=1 >Regards >Daniel

Hello, http://www.tek-tips.com/viewthread.cfm?SQID=556609&SPID=958&page=5 maybe that this can be a solution for your Problem. Regards Daniel

http://www.vb2themax.com/FileBank.asp?PageID=FileBank Maybe that helps ...

Hello, use a commandbutton (transparency = true) after your last field in the main form. Your code should be placed in the GotFocus event of that new commandbutton. So you can be sure thant the coude runs if you made no changes in the last field. Regards Daniel S.

Hello, &quot;My car is broken! Whats the reason?&quot; SCNR ;-) What is in the sub? Are there VBA modules you run on form_current or other events? ... Are there ActiveX Controls you are using in this subform? Do you use a newer version of Access? ... Regards Daniel Scholdei

Hello, take all the subs in your mainform and hide the 7 unneedet subforms per vba! Regards Daniel Scholdei

Hello, each control have a controltiptext ... look for this option in properties of the control where your tip-text should be shown ... The value of any tip-text also could be changed by using vba. Regards Daniel Scholdei

Hello, is your function a public function in a global module? If not ... thats the reason. Regards D. Scholdei