Visual Basic

I hope this helps, I have run into some 'similar' errors using Crystal Reports 8.5. I ended up writing a program to check the version of particular files that are included in the bootstrap section of the .lst file that is created using Microsoft's package and deployment wizard against those on the client PC that the program would go on. If you find any files on the clients PC that are older in version number than what was included with the bootstrap file, you should recreate the package in the wizard and use a copy of the older version. There is some, but little documentation on MSDN that points to Windows 2000 having a problem(i.e. - security) updating certain files when installing a new application. Hope this helps somewhat, Crystal Reports can be a pain sometimes, I guess we all just have to find our little ways around it. Nick Parker

Public Declare Function ExitWindowsEx Lib "User32" Alias "ExitWindowsEx"(ByVal uFlags as Long,ByVal dwReserved as Long) as Long Inside your form where you want to log off the user include: Call ExitWindowsEx(EWX_LOGOFF,0) The first arguement has several options: EWX_FORCE = 4 Force any applications to quit instead of prompting the user to close them. EWX_LOGOFF = 0 Log off the network. EWX_POWEROFF = 8 Shut down the system and, if possible, turn the computer off. EWX_REBOOT = 2 Perform a full reboot of the system. EWX_SHUTDOWN = 1 Shut down the system. Hope this helps Nick Parker

1. This can be done using the OpenSchema method of ADODB.Connection. Set rs = myADOConnection.OpenSchema(adSchemaTables) While Not rs.EOF debug.print rs!TABLE_NAME rs.MoveNext Wend 2. Don't know, but check out the OpenSchema method. Øyvind

Try using a Variant. Hope this helps, Bill

I'm not sure what you found in the article, there are two popular techniques. 1. Use FindNextWindow, looking for a window with the same name as yours. If found then exit. This is the most common method. It fails (or is at least difficult) if the window title is variable or there are many different windows that might or might not be open. 2. Check the list of running processes looking for your .exe name. There should be only one. If two found then exit. Thanks for the help, Bill

I don't believe that information is retained. :( Good luck though. Thanks for the help, Bill

Lucky for me I work every day in VC++ but sometimes I work in something called VB.:-O Cheers!!!:-D :bob: and :beer: for ever in CP Carlos Antollini. Sonork ID 100.10529 cantollini

You can do it within the database, in which you may wish to include in your Select statement the same values but put together in another order(i.e. left(some_field, 1) + right(some_field, 1) + substring(some_field, 2, 2)). You would not populate that field, however when the user select the "some_field" column to sort by, you can sort your other column instead. Hope this helps some. Nick Parker

There are several ways to do this, here is one. Private Sub Text1_Change() 'Check position of character If len(Text1) = 3 then If right(Text1,1) = "A" Or IsNumeric(Text1) = True Then MsgBox "There's an A or an numeric in Text1 ", 64, "Error Message" Exit Sub End If End If End Sub Nick Parker

Following order of operations you should get 130: 1. V = 50 2. (2 * V) = 100 3. 100 + 30 = 130 There is nothing wrong with that statement, it should evaluate to 130. Hope this helps, let me know. Nick Parker

Try this: "I said ""Yes""" Or this: "I said " & Chr(34) & "Yes" & Chr(34) Andy Gaskell, MCSD

Without any specifics, your question is difficult to answer... Did you use an installation package to deploy your app to the NT/2000 machines? If not, those machines probably don't have the VB runtime dll's installed... Do not go where the path may lead, go instead where there is no path and leave a trail. - Ralph Waldo Emerson Paul Lyons

The error message is a VB generated error message and the dll im using is a C++ dll (using _stdcall and its NOT a COM dll). The strange thing is that the error message don't appear every time and it never appear if i make a EXE file of the vb project. My source cod: Vb: Public Declare Function Data Lib "E:\C++ Program\Test\Debug\Test.dll" _ Alias "_CreateData@4" (ByVal pDb As Long) As Long Dim Temp As Long Temp = Data(10) C++: .h extern "C" { __declspec(dllexport) long PASCAL CreateData (long iDatabaseId); } .cpp #include "Test.h" long PASCAL CreateData(long iDatabaseId) { return iDatabaseId*10; } I would bee so happy if you could help me :) /Z

Thanks Andy, Worked great. latter ;) Confusios say "Man who run in front of car get tired, Man who run behind car get exhausted."