10,989 Topics
| |
Can anybody tell me where should i pass sql statement in crystal report . suppose i want to pass these codes in crystal report.this would be greately appereciated. [code] RECORDSQL = "SELECT * From MR WHERE (((MR.Req_no)=" & Text12.Text & "));" rs.Open RECORDSQL, con, adOpenDynamic, adLockOptimistic [/code] | |
pls help me to read the processor id or unique computer id using vb | |
I've been searching for a way to convert the Menu Bar item captions to Unicode -- or an ocx to replace the VB standard Menu Bar with a Unicode Enabled substitute. If there is a way to coerce the native control to display Unicode, then that would be preferable. Otherwise, … | |
I have the code [code=vb] Dim cApp As CRAXDDRT.Application Public cReport As CRAXDDRT.Report Public CurrentTemplate As String Dim ErrorMsg As String 'Dim ReportLayOut() As RptLayOut Dim ErrorNo As Long Dim ErrorModule As String Private Sub Form_Load() On Error GoTo PrintReportErr With frmFolderDisplay .txtPath = GetSingleLUMSTREntry("OMU", "CRIT MATL REPORTS", "PATH", "") … | |
Can anybody tell me how should i generate automatic sr no which match with mr no. i have written a code but it is not working properly. [code] Dim crystal As CRAXDDRT.Application Dim Report As CRAXDDRT.Report Dim cparam As CRAXDRT.ParameterFieldDefinition Dim cparams As CRAXDDRT.ParameterFieldDefinitions Dim con As ADODB.Connection Dim rs … | |
Dear all I wrote a small program to send-receive message simply base on Winsock/UDP. But a problem occured : When i test this program with my friend, she can receive all message i sent,but i can't receive any from her ??? ??? Any one can explain to me what wrong … | |
After the treeview is filled is possible to: count how may AG-xxxxx are in 8501-xxx, count how may items are in each AG-xxxxx, , count how may items are in each SETT. -xx, ....ecc and store the result in a var or count during the treeview is filling and return … | |
Hi all, I have developed a software that is basically a Question Paper Maker, I have stored all the questions in a MEMO field in an MSACCESS table. Now while I try to print the random questions on a report, it shows the question with all the rtf codes and … | |
hi i have program in clien and program in server the connected by winsock i want send more than one variable by winsock1.SendData how i can send it its from diffrent type x as integet s as string y as string i want send x , s and y and … | |
hello everybody, I am installing some (~10y old) research software which must have been using vb4, because when I started installing it failed because it was looking for vb40016.dll (got that) than oc25.dll (got that one too), and then PUSHHELP.VBX. This is where I got stuck, there a lot of … | |
hi i have vb program in client connect with vb program in the server by winsock clinet will send data to the server and server will add data to the data base access data base how i can work with access in vb 6 program ? how can i add … | |
Hi, I want to know how can I eject a removable device. The device is assumed to be a USB memory stick and comes on a E drive so therefore I would like to safely remove the E drive when the user log off! The code for log off is … | |
hi guys i m doing my final yr project in vb 6.0 and back end in ms access i want help about how can i send a vb form as an attachment to outlook express or else how can i convert it into a word document is there any code … | |
Hello! I will attempt to explain what I am trying to achieve here...I want develop a function that will accomplish the following: First of all the called function will look like this Balanced_Matrix(b,g,l,f) Where: b = base g = groupnumber l = number of lines f = frequency of occurrence … | |
hey guys can anyone juss gimme a hint about how can i make such a facility in my project that i a client can send a form as an attachment via email plz waiting for ur reply gauri | |
I need the source code from an EXE to customize a little. The programmer had died last year who developed it. He did not took backup the code on his PC. | |
I want to accumulate time into a variable (Time1) and have it count hours, minutes and seconds. It should not carry over to date when it passes 24:00:00 but should go to 25:00:00. For example, if I have 22:00:00 hours on a project and spend another 10:00:00 hours the total … | |
:'( hi guys hope you can help i have written a small project used to simulate a cash reg however i have 3 froms on it ,main,checkout and about my problem is that if i move my main form to say left had of screen when i click on checkout … | |
Hi..by the way i'm mark...a newbie in visual basic and my question is this... How or what is the codes used to connect from visual basic to "SQLyog"...just like visual basic to ms access?... | |
Hey Everyone , I am working on a project where i constatly need to update from one place to the other in word. Can anyone help me figure out how to get the Table from word and paste it in excel through VBA only. This help woulf be greatly appreciated … | |
Hi, Could anyone give me some suggestion? How can I detect the button is pressed continuously? Actually, I use [ICODE]Command1_MouseDown[/ICODE], but it is not succeed. I would like to do the application continuously if the button is pressed. If the user release (mouse up), I will stop the application. How … | |
I have a database of all 5000 cities to compare against. What I am trying to do is extract only the exact city names from a string. For example, let's say column A in Excel contains these phrases: [LIST] [*]bankruptcy new haven [*]personal injury new york [*]personal injury new york … | |
Hello, Please can someone enlighten me. What I need is to fetch data back from my access database using an SQL query in order to present the data entered into the database in the last hour. | |
i am developng system in vb6 and crystal report 10 in form i have opened recordset now i want that result will be shown in report text box i have created text box in crystal report 10 form in vb6 form i opened rs now i want this rs!table_name crystal … | |
Hai, Once again im here with a problem. Can u help me write a program to search a file in the project folder. I also want to use a progress bar to represent the search status. Can anyone help!!! Thank you!!! | |
hi there, i have a form in Vb6 and a msacess 2007 database connected using ADODC, on a form is a listbox that i want to populate with the table data from the database, the name of the database is Storenw and the table from which i want to access … | |
I posted a thread yesterday and got an excellent tip from vqueen71 (I think) but I am still having a problem. I need to find out the location of a user's desktop location. I have used the Environ("userprofile" and the SHGetFolderPath. The first returns the standard profile setting for windows … | |
Guys i have problem about fle handling.. i dont know howto update the text in the file.. or in the NOTEPAD this is my code.. Private Sub cmdUpdate_Click() Dim ndx As Byte Dim tmp As String Open App.Path & "\data.txt" For Output As #1 Write #1, txtname, txtaddress, txtphone.Text Close … | |
Hello there, I am doing my 'budget control system', and I want to make substraction from the value i entered in a textbox (budget for the year), with the sum of all the value in the 8th column of the MS Flex Grid data (which is the money used). Can … | |
Please help me in automatinng the following in my EXCEL sheet using VB. I want to make my first two rows as Repetitve in every page of print.In excel it can be done as PAGE SET UP->SHEET -> Print titles -> "Rows to repeat at top". here i can choose … |
The End.