Visual Basic

FirstPrevNext

How can i create timeline Mustafai15-Jul-02 0:25 Mustafai 15-Jul-02 0:25  hi any1 have idea how too create Timeline on the basisc of date using VB.Net...or creating Graphs in Vb.net Transfering Files/Folder over a network (LAN) Birdy14-Jul-02 19:57 Birdy 14-Jul-02 19:57  i am having prb in Transfering Files/Folder over a network (LAN). i have to transfer my files from my server on the workstations of the lan . FTP should be the choice / Winsock. pls tell me abt it Work Hard and Test your Luck Re: Transfering Files/Folder over a network (LAN) devil66614-Jul-02 23:44 devil666 14-Jul-02 23:44  check out these three links .. i hope ya get wat ya want.. http://www.15seconds.com/issue/981203.htm http://www.acky.net/vb/vbtcp/index2.sht http://www.vb2themax.com/HtmlDoc.asp?Table=Articles&ID=520 VB code problem - string Member 4167514-Jul-02 18:27 Member 41675 14-Jul-02 18:27  Having a problem with the following code: DoCmd.OpenReport "Print - IncompleteMemosbyTeamLeader", acViewPreview,, _ "RequestTo = 'Tod O'Dell'" Only recognises the String as Tod O instead of Tod O'Dell. Can someone please suggest a way to overcome this. I'm not a VB coder. I'm unfamiliar with VB. I assume you could declare Tod O'Dell as a string as would in C++ and use the VariableName. e.g. C++ Example String VariableName = "Tod O'Dell"; Your help would be greatly appreciated Nathan Browne Re: VB code problem - string Ravi_Shankar14-Jul-02 21:27 Ravi_Shankar 14-Jul-02 21:27  Hi, In the criteria, put it in a variable and use Replace function to replace the single quote found with 2 single quotes. Please find an example below to use the same with SQL Server. Dim sSql As String Dim sName As String sName = "O'Leary" sName = Replace(sName, "'", "''") sSql = "Select * from authors where au_lname = '" & sName & "'" Debug.Print sSql Try executing the output of the above SQL statement in Query Analyser under Pubs database... Ravi Shankar S Programmer Analyst iSOFT R&D Pvt Ltd Chennai, INDIA Ph: 91-44-4414980 Extn 1103 Re: VB code problem - string Ravi_Shankar14-Jul-02 21:31 Ravi_Shankar 14-Jul-02 21:31  Hi, You can use the Replace function to replace a single quote with 2 single quotes... Consider the following example: sName = "Tod O'Dell" sName = Replace(sName, "'", "''") DoCmd.OpenReport "Print - IncompleteMemosbyTeamLeader", acViewPreview,, _ "RequestTo = '" & sName & "'" Hope this helps you... Ravi Shankar S Programmer Analyst iSOFT R&D Pvt Ltd Chennai, INDIA Ph: 91-44-4414980 Extn 1103 Re: VB code problem - string James T. Johnson14-Jul-02 22:07 James T. Johnson 14-Jul-02 22:07  As Ravi_Shankar pointed out (but not so clearly) the problem is that databases use single quotes (or apostrophes; your pick) to delmit the boundries of a string. In order to support the use of single quotes/apostrophes in a string the SQL specification says that a double-single quote/apostrophe '' is used (not "). So rather than the last line being "RequestTo = 'Tod O'Dell'" you need to make it "RequestTo = 'Tod O''Dell'" (note the use of the dobule-apostrophe) Hope that is a bit clearer for you James "Java is free - and worth every penny." - Christian Graus getting the user information devil66613-Jul-02 10:24 devil666 13-Jul-02 10:24  hi!! i want to retirieve the user information currently logged on to the system... the inforamtion whihc i want to reitrieve is group to which the user belongs comlete name this inforamtin is in actie directory so i have to get this from active directory.. would any1 guide me how to do this in vb.net regards Re: getting the user information Ravi_Shankar14-Jul-02 19:31 Ravi_Shankar 14-Jul-02 19:31  Hi, You can use the Environment Class to get the details... Please find the sample as follows: MessageBox.Show("Machine Name: " & Environment.MachineName()) MessageBox.Show("Domain Name: " & Environment.UserDomainName()) MessageBox.Show("Logged on User Name: " & Environment.UserName()) Ravi Shankar S Programmer Analyst iSOFT R&D Pvt Ltd Chennai, INDIA Ph: 91-44-4414980 Extn 1103 Re: getting the user information devil66614-Jul-02 23:42 devil666 14-Jul-02 23:42  thx for the reply but this environment class doesnot provide me the facility to know the group of currently logged on user.. which is the most important information about the user as far as i am concerned.. so plz hep me out.. Using MSHTML Advanced Hosting Interfaces Gene Sivorot13-Jul-02 9:00 Gene Sivorot 13-Jul-02 9:00  Can anyboday port the code in the Using MSHTML Advanced Hosting Interfaces example to VB.Net? The example is under Home >> C# Programming >> COM Interop or http://www.codeproject.com/csharp/advhost.asp. I can't get it to work in VB.Net. Thanks VB 6.0 and excel 2k interaction. patty13-Jul-02 2:03 patty 13-Jul-02 2:03  I have written 1 app which creates new excel workbook and writes into it.But ,I was not able to do so with existing excel workbook. How should I open existing excel sheet in vb6.0 ? I want to write data into workbook having macros. should I use MS excel driver ? Thanks, Amit Re: VB 6.0 and excel 2k interaction. Toni Monte OLD13-Jul-02 2:58 Toni Monte OLD 13-Jul-02 2:58  Hello, Try the next code: ' Variables... Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet ' Excel, Book and Sheet instantiation... Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open(App.Path & "\Book1.xls") Set xlSheet = xlBook.Worksheets(1) With that code you can access to a existing sheet in a XLS file. The DLL you have to use is 'Microsoft Excel XX Library' (in the references section of VB6). Bye. Re: VB 6.0 and excel 2k interaction. patty13-Jul-02 4:01 patty 13-Jul-02 4:01  hey ...thanks for ur quick help !!!! Getting the path of the current dll Anonymous Programmer11-Jul-02 5:25 Anonymous Programmer 11-Jul-02 5:25  How do I get the path of the currently executing dll? Sample code, please. Thanks. Re: Getting the path of the current dll Kastro22-Jul-02 19:09 Kastro 22-Jul-02 19:09  In .NET: Assembly.GetAssembly().Location string access Unplugged11-Jul-02 4:48 Unplugged 11-Jul-02 4:48  this is really stupid, but how do I access one character from a string. in C++ it looks like: stringvar[5] when I try it in VB stringvar(5) it says that it expects and array. but I can't declare an array of characters which is what I need. ICXC NIKA Re: string access Roger Wright11-Jul-02 5:00 Roger Wright 11-Jul-02 5:00  Try: onechar = Mid(stringvar,startpos,numchars) Instead of marrying again, I think I'll just find a woman I don't like very much and give her a house... drag drop Hesham Amin11-Jul-02 4:34 Hesham Amin 11-Jul-02 4:34  Hi.. I want to drag an image control and drop it outside my form.. and I want ot be notified when the drop occures .. how can I do it ? Intellisense Balachandar Ganesan10-Jul-02 13:22 Balachandar Ganesan 10-Jul-02 13:22  Hi All, I would like to know how Intellisense editors are developed. I am currently trying to build one for SQL. I have a placed a text box control in VB form. When ever user types characters inside the text box, I am populating keywords in a combo box depending on the characters entered. How ever I have a difficulty in follwoing the cursor inside the text box. Let me know how I can get the x and Y co-ordinates of a cursor inside a text box Thanks bala Re: Intellisense Jeremy Falcon11-Jul-02 4:45 Jeremy Falcon 11-Jul-02 4:45  gbala wrote: How ever I have a difficulty in follwoing the cursor inside the text box. Let me know how I can get the x and Y co-ordinates of a cursor inside a text box Do you mean cursor or caret? The caret is the blinking beam you get when typing into the textbox. You'll have to use raw API for this, and here are the functions... GetCursorPos()<br /> GetCaretPos() Jeremy Falcon Imputek Running Code in a Different Page. Pradhip10-Jul-02 12:39 Pradhip 10-Jul-02 12:39  Hi Folks.. Im having a web form that has 2 select boxes.Now when one select box has a value chosen it must generate values for other select box.This can be accomplished by querying the dbase.Now to do this querying im using an ASP page. 1). My question is how do i run the ASP Page without it affecting the current window displaying my form?? 2). Now my 2nd select box has to be refreshed for it to be populated with the values that the ASP Page generates.How can i refresh that control alone without touching the other contorls or rather refreshing the entire page.. Can someone give me links to articles regd this sort of stuff.I know im using a round about method.. Regards Pradhip.S Why Need Parking lots in Bars when Drunken Driving is Prohibited Re: Running Code in a Different Page. Ravi_Shankar10-Jul-02 20:59 Ravi_Shankar 10-Jul-02 20:59  Hi You can use HTTPREQUEST Object to call the page which can return the data for the other Select box. Use this data to fill in the same. Ravi Shankar S Programmer Analyst iSOFT R&D Pvt Ltd Chennai, INDIA Ph: 91-44-4414980 Extn 1103 Dependency Information at P&D Wizard Like2Byte10-Jul-02 4:45 Like2Byte 10-Jul-02 4:45  Hi all, I wrote a wrapper around an OCX (making it a dll) to make the interface simpler for others to program around the OCX. The problem is that when I try to use the Package & Deployment Wizard to package it, I get this message: "Below is a list of files for which dependency information could not be found. To proceed without the dependency information for the file(s) listed, click OK. To permanently mark a file as having no dependencies, select its checkbox." 3 Questions: 1) Is it unwise to wrap a DLL around an OCX? 2) How do I create a dependency file for the DLL? 3) If I don't need a dependency file, how can I be sure before actually building the project and installing it on some bare bones PC? Thanks Guys and Gals, Oh, yeah. I also get the dependency information message for: dao360.dll. How can I fix this, too? Re: Dependency Information at P&D Wizard Like2Byte12-Jul-02 3:43 Like2Byte 12-Jul-02 3:43  Here are the answers to the questions I provided (If anyone cares.) Let me just say that everyone has a purpose in life and sometimes that purpose is to set an example. This is a case of an example of something to NOT do. <<1) Is it unwise to wrap a DLL around an OCX?>> This could be argued for or against, i guess; but, be forwarned - It's a bitch to get the thing working in a distributable package. That being said, I killed the dll project. So, for a newbie VB Programmer, Yes. Without a doubt - don't try it. I'm sure someone knows how to do this, though it ain't me. <<2) How do I create a dependency file for the DLL?>> The package and deployment wizard has a dependency file wizard that works pretty well. It detected all the dependency information for another dll we wrote. However, the one I was working needed much more information than it could generate automatically. Since sometimes "less is more,' I'm going to end with that. <<3) If I don't need a dependency file, how can I be sure before actually building the project and installing it on some bare bones PC? >> Now that I know a little bit more about dependency files, I'm no expert therefore I shall not even try to submit information to someone else on this as I may 'bum-dope' someone. I have my theories; but, they are largely untested. In closing, it was a foolish idea to wrap an ocx in a dll and think that the interface I was writing would be 'easier.' But, hey, I learned something for it which is better than nothing. Later.

Last Visit: 31-Dec-99 18:00     Last Update: 23-Sep-24 6:21 Refresh ᐊ Prev1...4768476947704771477247734774477547764777 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.