10,989 Topics

Member Avatar for
Member Avatar for firoz.raj

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]

Member Avatar for firoz.raj
0
117
Member Avatar for rajeevppm
Member Avatar for Comatose
0
87
Member Avatar for Mark Whitt

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, …

0
53
Member Avatar for vb6sux

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", "") …

0
45
Member Avatar for firoz.raj

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 …

Member Avatar for firoz.raj
0
201
Member Avatar for kirimaru

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 …

Member Avatar for Comatose
0
73
Member Avatar for sal21

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 …

Member Avatar for QVeen72
0
292
Member Avatar for rajeshkhanna_in

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 …

Member Avatar for rajeshkhanna_in
0
76
Member Avatar for yara.008

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 …

Member Avatar for yara.008
0
93
Member Avatar for berillio

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 …

Member Avatar for berillio
0
134
Member Avatar for yara.008

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 …

Member Avatar for yara.008
0
290
Member Avatar for badbloodyeyez

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 …

Member Avatar for badbloodyeyez
0
155
Member Avatar for gaurisweet2

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 …

Member Avatar for Comatose
0
70
Member Avatar for Kennylee

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 …

0
54
Member Avatar for gaurisweet2

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

Member Avatar for gaurisweet2
0
82
Member Avatar for mmmark

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.

Member Avatar for jbennet
0
118
Member Avatar for Emerogork

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 …

Member Avatar for Emerogork
0
101
Member Avatar for stephen lowry

:'( 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 …

Member Avatar for stephen lowry
0
100
Member Avatar for markx_018

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?...

Member Avatar for debasisdas
0
194
Member Avatar for k88joshi

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 …

0
53
Member Avatar for zawpai

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 …

Member Avatar for Jx_Man
0
265
Member Avatar for chopin2256

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 …

0
61
Member Avatar for lostandfound

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.

Member Avatar for lostandfound
0
79
Member Avatar for selicon.valley

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 …

0
77
Member Avatar for RahulV

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!!!

Member Avatar for RahulV
0
479
Member Avatar for sackymatt

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 …

Member Avatar for sackymatt
0
314
Member Avatar for JohnKelly

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 …

Member Avatar for JohnKelly
0
94
Member Avatar for regberds

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 …

Member Avatar for regberds
0
92
Member Avatar for nor_d83

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 …

Member Avatar for nor_d83
0
169
Member Avatar for dinilkarun

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 …

Member Avatar for Comatose
0
133

The End.