Visual Basic

FirstPrevNext

pivot table tamar yona27-Jun-01 20:07 tamar yona 27-Jun-01 20:07  hi! I want someone who'll help me with a pivot table and pivot chart in vb when i'll press double click on the chart i'll get then next level from the coulmn in the pivot. thanks! Events with an MTS COM object. Jamie Nordmeyer27-Jun-01 6:01 Jamie Nordmeyer 27-Jun-01 6:01  I have an MTS COM component that is used for updating a SQLServer database. The component sits on the SQLServer computer, whereas the client of the component sits on various user machines (the typical 3 tier setup). I have written 3 events in the component. In the client app, all works fine until I add 'WithEvents' to the variable declaration for the object. When I run the client application, I get a 'Permission Denied' error. What's up? The SQLServer PC is running Windows 2000 Advanced Server, and the client app and COM component were compiled with VB6, SR4. Dim U As tldll.Update 'This works fine, but... Dim WithEvents U As tldll.Update 'fails with the Permission Denied error Thanks in advance for any ideas. Jamie Nordmeyer Portland, Oregon, USA Re: Events with an MTS COM object. Klaus Probst7-Aug-01 15:49 Klaus Probst 7-Aug-01 15:49  I don't know what the problem might be, but one thing I can tell you is that your design is simply disastrous for n-tier applications. "WithEvents" is just not meant to be used that way. Look at the COM+ event system or redesign your app using interface callbacks or something like that. ___________ Klaus [www.vbbox.com] How can i use the UDP in the Web ?? khamis22-Jun-01 7:49 khamis 22-Jun-01 7:49  Why I need the UDP ? i want to create something (Like OCX or DLL) to let the server send a message to the client(s) inform them to refresh ,redirect ,there is new email, XXX is logged on. how i'm thinking to solve this problem? create client OCX (without using the WinSock.OCX) to wait and manage the server message. and create an DLL on the server that will send the message to the Client OCX. (i think this is a good solution ?! do you think that ????!! ) What i want ? i do not know how to write a code deal with UDP ?! if you have another idea ?? i'll be pleased to you if you send it to me Note : I’m talking about intranet. Can any one there help me ? or give and any article(s) that could help ?! web programmer. Re: How can i use the UDP in the Web ?? Klaus Probst7-Aug-01 15:51 Klaus Probst 7-Aug-01 15:51  What you're describing here is basically an NT service, and has nothing to do with UDP. You can do all this using TCP, named pipes or even mailslots. However, I would discourage anyone from trying to write a service in VB as it's probably more pain than not. ___________ Klaus [www.vbbox.com] Showing modeless form in VB DLLs called from MFC 22-Jun-01 1:18 22-Jun-01 1:18  (Sorry, I'm cross posting this to both the VB and C++ forums as it covers both). I have a common problem - I need to show the modeless forms which reside in a VB ActiveX Dll, called from an MFC client app. I know that it isn't possible to show a modeless form in a VB ActiveX DLL (unless VB itself is also the client), because the modeless form needs to hook into a message loop to receive windows messages. The MSDN docs state that VB looks for something called the 'component manager' on the client to hook into which MFC doesn't provide. Has anyone worked out how to get around this? Is is possible to mimic the functionality of the component manager in the client app, or at least the parts the modeless form is looking for? What is the myterious interace the VB is looking for? Am I on a hiding to nothing here? Thanks Formatting duplicates in excel Ian21-Jun-01 23:16 Ian 21-Jun-01 23:16  Does anyone know how I might extract sets of duplicates from an excel spreadsheet and then insert extra rows around them? I have an excel spreadhsheet with sets of rows with one cell that may be the same account no as another cell. When I sort them I have say sets of three or four or five rows all with one cell the same. Eg cell d is a unique account no ref. So I might have a number of the same account no in the sheet and on sorting they are all together. Next I would like to put a blank row above and below the duplicate group , then I would like to auto sum one of their columns for each set of duplicates. In this way I can get a net balance for lots of sets of the same ref no. Anyone any ideas? thanks String 20-Jun-01 4:46 20-Jun-01 4:46  Hi All. I´ve create a dual interface in VC++ with this method "void SegundoError([out] BSTR my_string)" in the events interface and with its corresponding Fire in the CProxi class. In VB I´ve capture this event: "MiInterface.SegundoError(ByVal string_from_VC As String" and the problem is that "string_from_VC" arrives empty. Cuold tell me someone what I´m doing wrong? Thanks Re: String 20-Jun-01 16:00 20-Jun-01 16:00  Why did you define your string as [out]? Who is providing the string VB or VC? * if your string is defined in VB and you want to view it in VC, use [in] * if your string is returned to VB, then you should use [out] BSTR * pbstrOut Can you give me more details, please! Did you create your VC++ object using ATL? How do you create an instance inside VB? What is the code that you have in your VC++ function? You should realize that BSTRs are not like LPTSTR or TCHAR * so, inside your SegundoError: SegundoError(BSTR my_string) { USESCONVERSION; LPCTSTR psz = W2T(my_string); printf("String is : %s", psz); } Mh2! Re: String Michael P Butler20-Jun-01 22:35 Michael P Butler 20-Jun-01 22:35  If you are trying to pass a string out from VC to VB using a connection point, the IDL should be [in]BSTR my_string Michael Re: String 19-Jul-01 10:07 19-Jul-01 10:07  Your method is "void SegundoError([out] BSTR my_string)" [out] parameters must always be pointers, so your method should be method: "void SegundoError([out] BSTR *my_string)" Hope it helps! comunication 19-Jun-01 6:28 19-Jun-01 6:28  Hi: I´ve define a dual interface with connection points in VC++, and I want to send data to VB, but I don´t know what have to put in VB to finish the connection. Cuold someone help me? I would grateful if you would send me an example code. Thanks. Plus! Settings, large icons, et al. 18-Jun-01 10:34 18-Jun-01 10:34  I am writing a program to customize your desktop using the Windows Plus! Settings. The only way I could find to do so is to change the registry settings manually and then do a ChangeDisplaySettings with CDS_UPDATEREGISTRY as a flag. This 'tricks' the settings into being active. There's got to be a better way to do this! Anyone know how to change these settings more efficiently? Does there exist an API that allows you to refresh your display without making a "ChangeDisplaySettings" type change? OS: Windows NT Thanks! MDI and Bitmap mr200318-Jun-01 8:17 mr2003 18-Jun-01 8:17  I have a MDI application, I like to know if I have to use DIB to display bitmaps..?? or is there another way? Thank you Ehsan Ehsan Behboudi Re: MDI and Bitmap 20-Jun-01 17:04 20-Jun-01 17:04  If you mean you're trying to place a bitmap on the MDI parent, then you need to place a picture box first and then load the bitmap into it! Multiple lines in input boxes Ian17-Jun-01 22:36 Ian 17-Jun-01 22:36  Does anyone know how to enable multiple lines in an inputbox please? I'd like to ask the user to input an address and then put it into everal lines of an excel worksheet as you'd expect to see an address on an address label. eg Street Town COunty PostCode CHeers Ian Re: Multiple lines in input boxes Erik Thompson18-Jun-01 7:52 Erik Thompson 18-Jun-01 7:52  Create your input box on the form. select the input box, go to the properties window for the control and scroll down the alphabetical list until you find MultiLine and set the value to True. Cheers, -Erik ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ My thoughts are my own and reflect on no other. Re: Multiple lines in input boxes Ian18-Jun-01 21:02 Ian 18-Jun-01 21:02  Trouble is I am using pop up boxes for user input that appear in a defined sequence. This is the code I am using accno = Application.InputBox(Prompt:="Enter account number", Default:="1234567", Type:=1) Is it possible to do the same in another way and still guide the user through the form? thanks Re: Multiple lines in input boxes Klaus Probst7-Aug-01 15:54 Klaus Probst 7-Aug-01 15:54  Use the same form (or instances of the same form). Forms are classes and can be created just like anything else. You can have an array of VB.Form object instances if you want. ___________ Klaus [www.vbbox.com] Capture the key hit An16-Jun-01 8:21 An 16-Jun-01 8:21  I want to write a progam by Visual basic that can run behide another active program (such as Word 97)and can capture the keycode each time the user hit it. I don't know the technique for that and I wish to receive any suggestion. Thank you very much. Tran Duy An Re: Capture the key hit 17-Jun-01 22:19 17-Jun-01 22:19  Ban co the doc trong MSDN phan cua VB, no giai kha ro ve viec nay ! Chuc may man, bye Re: Capture the key hit 19-Jun-01 15:07 19-Jun-01 15:07  You need to install a system wide hook. See SetWindowsHookEx API in MSDN Mh2! Re: Capture the key hit 7-Jul-01 20:41 7-Jul-01 20:41  Try searching for vb sample projects called KeyLogger. The works are pretty much the same. Outlook VB script: Print Method 15-Jun-01 5:21 15-Jun-01 5:21  The purpose is to make a form in outlook containing a command button to print the form to a pre-defined printer. Is there a function or method in VB scripting or VBA which can be triggered by a command button and causes the form to be printed to a predefined printer (cause its a fax-printer) without letting the user be aware of this choise? Thank you for taking the time. Regards, Dominic Steur. dsteur@sax-sanitair.be ActiveX control for the web 15-Jun-01 4:45 15-Jun-01 4:45  Iam trying to create a simple activeX control for the web using Vb. It connects to a backend access database. I have the following code segment that is giving me an error ConString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=STV250.mdb" & _ "DefaultDir=D:\Inetpub\wwwroot\MastersProject\Inventory;" objConn.Open ConString The error being: [ADO Error # -2147467259 Description [Microsoft][ODBC Microsoft Access 97 Driver] '(unknown)' isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Source Microsoft OLE DB Provider for ODBC Drivers] However if I use, ConString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=D:\Inetpub\wwwroot\MastersProject\Inventory\STV250.mdb" objConn.Open ConString it works fine. That is after I create the .CAB file and embed it in an asp page. But it works only on the computer that houses the webserver and the .OCX/.CAB files. If I try accessing it from another machine, I get the ADO Error # -2147467259 again. I have used the same code for numerous ASP pages and had no problems. But it just refuses to work for the ActiveX control. Could someone please help?

Last Visit: 31-Dec-99 18:00     Last Update: 25-May-24 6:37 Refresh ᐊ Prev1...4800480148024803480448054806480748084809 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.