11,868 Topics
 | |
 | I want to update an excel sheet using form and not directly by entering into sheet. Could anyone please help with ideas, as this is a big excel designing a userform would be critical. thanks regards |
 | Im very new to programming and I need to make a looping flexgrid with the specific code of grid1.additem 3guc+1 vbtab 3guc+2 vbtab 3guc+3 in the middle of my loop the flexgrid only needs to look like this 1 2 3 4 5 6 7 8 9 can someone help …  |
 | Why am I getting an error "Operation is not allowed when the object is open"....Here is my code Option Explicit Public Report As New CrystalReport1 Public mvCn As New ADODB.Connection Public Function printReport() Dim strConnectionString As String Dim rs As ADODB.Recordset Dim strScript As String strConnectionString = "Provider=SQLOLEDB............" mvCn.ConnectionString = … |
| | Can Somebody help me? i have an error whenever i want to save the data i have retrieved from different table in mysql. my system is doorlock system. im going to choose an item in the combobox and when i click the button, the data i'd chose from the combo …  |
 | I am using Excel with VBA 7.1. I am starting another application from VBA using the shell command. The application comes up OK. But now I need to click a button in that application to proceed. My current (and limited) understanding of the procedure I must follow is to first … |
 | I want multiply three numbers in VB many private sub cmdmult_click() multiplication=Val(text1.text) * Val(text2.text) please assist me  |
 | I want to open .txt file in my simple notepad. when i dobble click on .txt file, my simple notepad will show that file text. please kindly code it by TextBox control. not RichTextBox control. please somebody help me.... |
| | Hi,i have a code like this : using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ClassLibraryMoq { public class Class1 { public interface ISendr { string send(); } public class smsSender : ISendr { public string send() { return "SMS send"; } } public class emailSender : … |
 | Hallo to all, can anyone help me how to display data from the database based on the date from the [COLOR="red"]dtpicker[/COLOR]? In my database I have a column [COLOR="Green"]date [/COLOR]and a column [COLOR="Green"]event[/COLOR], if I click a particular date in the [COLOR="Red"]dtpicker[/COLOR] it should display in the MSFlexGrid the [COLOR="Green"]date …  |
 | Hi, I need to write a macro that has one row of dates. Row D. I need the macro to go down row and depending on the date I need to input a number to the cell to the right of that date. Example. If date < 12/22/16 insert value … |
| | I create DTS Package and assign variables on it in VB6.0...I need to check if my connection to my database is successful using DTS package that I created..I got an error message "Argument not optional"...Please help me Module 1 Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 …  |
| | Hi i am new in VB6 trying to built a simple application : 1 userform with 15 combobox, 46 Textbox and 3 command button. (ComboBox1~15)Each combobox is populated with items, TextBox1~15 are user input, Textbox17~46 are automatically filled by excel application to be executed by command button, then if my …  |
| | I have 2 forms namely "form1" and "form2" and checkbox "chkbox1"...The checkbox is created in "form1"..how will I assign variable in my checkbox using boolean and call it to my "form2" using VB6.0? |
 | hello, im newbie in VB 6, i have a question : i have text.file in text box like: 1 2 3 4 5 from that file, how to get average?? any help me,please??? |
| | Hello , How can i run a php script using vba macro ? |
 | Private Sub cmdPrint_Click() Dim cnview As New ADODB.connection Dim rsview As New ADODB.Recordset Call connection(cnview, App.Path & "\Seeyou.mdb", "endromida") 'Call connection(cnview, "\\SEEYOU-PC\shared\Seeyou.mdb", "endromida") Call Recordset(rsview, cnview, "SELECT * FROM [order] where Edate = #" & txtEdate.Text & "#") If rsview.RecordCount = 0 Then MsgBox "No Record Found On Query.", vbCritical, …  |
| | Hi, im using vb2010 with MS Access 2013. I have this form that displays ID values from database into a listbox And when an ID is clicked the details that correspond with that ID are displyed into textboxes. Screenshots : Forms : http://imgur.com/a/NrTTD Display details : http://imgur.com/a/twF7P The delete button …  |
| | After you open files (like 7 or 8) on email and download to visual studio, how come it won't let you debug right there? Do I have to save all those files, one at a time and then will it let me debug?  |
 | I've asked this on SO *AND* Reddit without so much as a peep...was hoping DW would turn up the answer! I have an ascx user control that has a custom event added to it. I can get the event to work without problem, but the event doesn't show up in … |
 | I want to convert this VB 6 code If Len(Text1.text) <> 0 Then Text1.text = Left(Text1.text, Len(Text1.text) - 1) To visual basic.net 2010 pro This code is used for making textbox delete only one number when you click on button . |
| | i'm trying to use the elif statement but every time i try to use it it gives a syntax error. here's the code: [code] n = input() while n != 2: n = n - 2 print "number is even" elif: n < 2: print "number is odd" [/code]  |
| | Visual Basic 2010 and Microsoft Access 2013 I have a product table in MS with fields : fld_id,fld_name,fld_img,fld_price,fld_type fld_img i set it as attachment and of course attached the corresponding image to it - is this wrong? this is my code to get the data into the datagridview. my form … |
| | hi every one. i have a vb6 application and i am using xampp as my database. it works fine when i access my database locally using the following code: Driver={MySQL ODBC 3.51 Driver};Database=NAME_OF_MY_DATABASE;Server=localhost; Port=3306;Option=13; but how will access xampp database stored in a remote pc in a network? thankz. |
 | Hi all! I need help with Visual Basic..  Write a program that reads 3 integers numbers, then the program prints the square and cube of each. i want a one button and one label in form and the result i want in label . and thank you all |
 | Hi I have 60 picture boxes on a form, I want to update these images using a for loop. I have tried Dim PCB as Image For i = 1 to 60 PCB(i).Image = mySampleProject.My.Resources.TestPCB1 next but get an error "Class 'System.Drawing.Image' cannot be indexed because it has no default …  |
 | Hi, I have installed Specflow in VS 2015 but I cannot see feature file when I add a new item. This worked up until Friday when my company changed domains. I have also created a completely new project and installed specflow but still no feature files are available. Can anyone … |
 | Hi, I want to create a Alternate Coloring in MsFlexGrid that using the Visual Basic Programming. Here I attach a source code : MsFlexGrid I give name : Flex If Wt <= RsParts.Fields!Lowerlimit Then '*********************************************************** '2. Section for create Color at 1 Column under REMARK Dim lngRow As Long Dim … |
 | I have database table created in sql server visual studio.I have one dashboard kind ,so whenever i want to change the value automatically balance amount should caluclate and display the changed value. Su Si Sa Sd Balance 10 12 13 14 ( Balance=Su+Si+Sa+Sd) 14 15 13 17 ( Balance=Su+Si+Sa+Sd) 17 … |
 | The algorithm for formatting code has has never treated vb.net comments properly. I've discovered a nifty work around that will format the code properly. Close the comment with another comment character(') and the algorithm will treat the rest as code. I've never tried it, but this should also work for …  |
 | How to send sms from a GSM Mobile phone using VB Code. Kindly tell me what are the prerequisite for this. Kinldy tell me the steps. Kindly tell me about gateway. |
The End.