vba x 200

12,155 Topics

Member Avatar for
Member Avatar for amitshowry

I had written a script to login to some terminals and do some basic commands remotely. It fails at password entry. ******************************************************************* Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run "cygwin" ' Give Cygwin time to load WScript.Sleep 2000 a=Array(112) For Each i In a WshShell.SendKeys "`ssh user@XX.XX.XX.XX" & i & " 'hostname;ps …

0
303
Member Avatar for dnk

Hi, I'm manage how to find word in textbox. In textbox : "How i can be a good programer? How i achieve that?" If i want to search "How" then it should return 2 How words in text. Please Help. Thank You.

Member Avatar for Basavaraj16291
0
404
Member Avatar for Bile

-->>Hello I hope all is well. -->>I'm trying to join or select some data from 5 tables by using the following join statement: SQL ="SELECT RegistrationTB.Christian_Name,RegistrationTB.Father_Name,RegistrationTB.Birth_Date," "BaptismTB.Date_Baptised,BaptismTB.Parish_Name,BaptismTB.Minister_Name," & _ "CommunionTB.Date_Communised,CommunionTB.Parish_Name," & _ "ConfirmationTB.LC_No,ConfirmationTB.Date_Confirmation,ConfirmationTB.Parish_Name,ConfirmationTB.Minister_Name," & _ "MarriageTB.LM_No,MarriageTB.Date_Married,MarriageTB.Parish_Name,MarriageTB.Mr_Name,MarriageTB.Mrs_Name,MarriageTB.Certificate_No,MarriageTB.Minister_Name " & _ "FROM RegistrationTB " & _ "INNER JOIN BaptismTB ON RegistrationTB.LB_No=BaptismTB.LB_No " …

Member Avatar for Bile
0
509
Member Avatar for Bile

-->>I hope all is well... -->>I have tried to use the package and Deployment wizard to create a setup for My application... -->>But the way My setup Icon Is (The default one) makes me feel uncomfortable,as I have an Icon alredy for my application and used it in all of …

Member Avatar for Bile
0
127
Member Avatar for Bile

-->>Hi all... -->>Here is what makes me be unconfortable here... -->>I was trying to develop a Progam that will help me creat a folder and make a copy of my passports -->>I managed to creat a folder but when I try to Copy the files is where I get an …

Member Avatar for Bile
0
203
Member Avatar for srkv03

Hi, I have been working with some legacy code at work. There seems to be a common logic in storing an entire table in the database as an array. I have got no clue at all as to why this needs to be done. The recordet is open the entire …

Member Avatar for srkv03
0
107
Member Avatar for zalen17

Can you give me some codes of how to make a Online Grading Enquiry System using visual basic. i need your help sir beacause this is uour project. hope can you help me

Member Avatar for zalen17
0
128
Member Avatar for boher

In my project, I have two seperate forms and in one of them I can add various panels using a button. After adding let's say 5 panels I click on one of them and I need the code to tell me which panelI clicked on. The reason I need this …

Member Avatar for Pgmer
0
722
Member Avatar for xaves

Is there a way to create a VB6 e-mail program fearturing attachments that bypasses attachment size limitations? Thanks in advance!

0
49
Member Avatar for stillmarooned

Hi all I would like to search a Excel List of names(voters Registration list) by typing a name to see if that person is registered. Can anyone advice me how to do it or provide me with a sample program Many thanks

Member Avatar for stillmarooned
0
112
Member Avatar for joshl_1995

Hello Community, I would like to know if there is a way to use augmentations on a visual basic.net program? Eg. "ProgramName.exe Command" And i mean on my vb program so i could use a commandline using cmd to do something on my program. Please Help.

Member Avatar for joshl_1995
0
517
Member Avatar for locsin

Post Thread: Searching Database file if existing or not. How to Add the Microsoft scripting runtime dll in my Project reference menu. I saw Microsoft Script in the components. Is this the file? Anybody can help me or give me step by step procedure to add this Microsoft Scripting runtime …

Member Avatar for ritesh9nair
0
379
Member Avatar for albert.staszak

So I have a main form and 5 other forms. When I press a button on the main form, I want it to open Form2 and disable a certain button in form2 so that it cannot be used. I produced this code but the button is still active and there …

Member Avatar for Jx_Man
0
121
Member Avatar for Matigo

Hello guys I have got a little programme that been written in Python, I did connect it to an application been created in Visual Basic 2010, But to run the Python file, Of course you will need to install the Python software/Format to be able to run the python file, …

Member Avatar for Matigo
0
298
Member Avatar for yuvjeeth

I wanted to know how to separate contents of a tab from another tab. I tried Deleting It but it was deleted even in tab 1 I used Microsoft Tabbed Dialog Control SP6 Any help would be Appreciated Yuvjeeth

Member Avatar for Jx_Man
0
116
Member Avatar for PinoyDev

Good day! I have a variable string that will hold numbers...I need a function that will check if the number meets the below criteria: **( Acceptable format )** -accept positive numbers -accept negative numbers -accept single decimal place (ex. 567.89) -will not accept double demical place (ex. 567.89.678) -will not …

Member Avatar for RonalBertogi
0
385
Member Avatar for meLiel

**how can i delete a record on a database? im using this codes: Private Sub cmdDelete_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rsDelete As ADODB.Recordset Set rsDelete = New ADODB.Recordset MsgBox "Are you sure you want to delete?", vbYesNo, "Santo Niño Census Info System" ' i …

Member Avatar for RonalBertogi
0
579
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to replace a cell value from one excel spreadsheet and save it as another spreadsheet but with the replaced cell value. Please Help

Member Avatar for joshl_1995
0
1K
Member Avatar for magord86

I'm trying to switch "M" to "Mr." and "F" to "Ms." when the last name is selected in the listbox. When I clicked on the first name it worked, but when I clicked on anyother name, I got this error message: --Additional information: Index was outside the bounds of the …

Member Avatar for magord86
0
293
Member Avatar for Behseini

using MS Excel 2007, and VBA I have two combobox.The first combobox has three items as:{One, Tow, Three} now I would like to load the second combobox based on what user select in combobox1. For example if user select One in the from combobox1 then namebox1 will populate to combox2 …

Member Avatar for AndreRet
0
190
Member Avatar for themathprof
Member Avatar for krunal1986

Hello, I need a simple way to mail from OUTLOOK WEB APP not from OUTLOOK via a VB6 code. Anyone know how to do that? Any code/link avaliable? Thanks, Krunal

Member Avatar for samsylvestertty
0
517
Member Avatar for Divinedar

I'm still having a problem with this. Can someone help? Let me explain a little more of what I need. Range("G3:G" & Cells(65536, "A").End(xlUp).Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0)),35,VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0))" Sub Compare() Worksheets("SUMMARY2").Visible = True I'm still having a problem with this. Can someone help? Let me explain a little more of …

0
168
Member Avatar for tmohney

Hello, I am taking my first basic computer programming course. We are learning how to use C# in Visual Studio. Recently we started learning about classes and how they work in OOP. I get the idea of what they are and what they do. I am having a problem writing …

Member Avatar for Mike Askew
0
166
Member Avatar for fdkallday_1

Hi guys, im developing an inventory system. things are doing good until ms access starts to slow down my vb6 project. my records are already exceeding 13k rows. retrieving and recording are laggy. like 3-15sec waiting. now. im planning to migrate to mysql. i already have mysql and SQLyog as …

Member Avatar for pritaeas
0
111
Member Avatar for sarjithvk
Member Avatar for belber

hallo all.. i have question about connecting barcode scanner to vb6 how to connecting barcode scanner to vb6... i use usb barcode scanner... did i must set port or some code in vb6..??? or it works automatically..??? i need some code reference plsss...

Member Avatar for ChrisPadgham
0
1K
Member Avatar for nunntb473

I have written a very simple program inside of a standard .NET 4.0 windows form (well a form opened by another form to be more exact) in C# using Visual Studio 2010. The basic idea is I have a series of text boxes with numbers. I want to be able …

Member Avatar for nunntb473
0
191
Member Avatar for ponnu

GIVEN below is vbscript to connect to acess database and insert records into the table using forms Private Sub Command1_Click() Set rs = cn.Execute("insert into employee values('txtempname.text',txtempid.text,txtssn.text) ") rs.Close cn.Close End Sub Private Sub Form_Load() datafile = "C:\mas.accdb" With cn .Provider = "microsoft.ACE.OLEDB.12.0" .ConnectionString = datafile .Open End With End …

Member Avatar for pradipkar
0
2K
Member Avatar for Peter_Budapest

Hello! All those people who have a blanke page when clicking on the Microsoft Update page or nothing appears in the Yahoo Messenger if typing a message, try the following: 1. Reinstall the Visual Basic Script Support it can be found here: [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=c717d943-7e4b-4622-86eb-95a22b832caa&DisplayLang=en[/url] if your OS have a different language, …

Member Avatar for Krzy_Doug
0
708
Member Avatar for honnysingh

I want to change form background color permanently at run time. when i start my application next time then i want to see the changed color please help thanks in advance

Member Avatar for Jx_Man
0
105
Member Avatar for Matigo

Hello everyone Is there any way to kill the python.exe in Task Managaer "On Windows" using visual basic The Problem is that i do open more than 1 python file at the same, But on task manager it's hows me something like this Python.exe python.exe python.exe python.exe I have got …

Member Avatar for Lardmeister
0
1K
Member Avatar for LeNenne

Hello How to change the resolution in VB6 ??? If one have 1200x900 and other have 800x 600 how can VB6 change or know what resolution the user have. Thanks Lenny

Member Avatar for LeNenne
0
208
Member Avatar for tooGr8

Can someone please show me how to get the Odd number using the For..Next loops in VB I have declared the following; Dim intCounter As Interger Dim intStartValue As Interger Dim intEndValue As Interger Dim intSum As Interger intStartValue = 0 intEndValue = 50 intSum = 0 Iam trying to …

Member Avatar for khair.ullah
0
82
Member Avatar for mitch_oso

Hi everyone I'm new in VBA and I have a problem with my code, if someone can help my I will be grateful. I have this part of code in Excel VBA an work fine Dim NumeroArchivo As Integer Dim conta As Integer Dim ListArchivAbierto As String NumeroArchivo = Workbooks.Count …

Member Avatar for Nutster
0
236
Member Avatar for PM312

When working with loop some time the loop goes into infinity while testing and I have terminate with “Ctrl+Alt+Del" and lose all unsaved work. How to get out of infinity loop without losing unsaved work. thanks

Member Avatar for PM312
0
149
Member Avatar for Matigo

Hello everyone Anybody to help me with this please How can make an app that will check the server/URL if it's Online/offline using visual basic 2010 I know that i can just ping it using the CMD but i want something that will be in the app i'm aiming to …

Member Avatar for Matigo
0
6K
Member Avatar for fdkallday_1

hi. im developing an inventory system. my problem is i need to create a datareport with date range so i created a query in ms access and i got the result but to get the result i should run the query first then a dialog box will pop-up to get …

Member Avatar for AndreRet
0
170
Member Avatar for dinhunzvi

i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 …

Member Avatar for dinhunzvi
0
285
Member Avatar for cristian.capannini

Create a button in the context menu for each selected contact. Hi all I would like to create a button in the context menu (right click) for the selected contact. This button has the same functions as the call button. Is there a way to create this add-in for Outlook …

Member Avatar for sophiec016
0
239
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to make grid transition in visual studio using the language visual basic. Please help...

Member Avatar for joshl_1995
0
295
Member Avatar for emil.rubinic

My program consist of two classes: Form1 (windows form with textbox) and SerialCommunication (class for serial communication). When data occurs on COM port DateRecievedHandeler store the message to indata. public ref class SerialCommunication { private: static SerialPort^ mySerialPort; public: static String^ indata; static void OpenPort(); static void Close(); static void …

Member Avatar for emil.rubinic
0
100
Member Avatar for Matigo

Hello everyone I've been searching for help for a long time and still can't find somebody to solve it for me :(, The problem is im not good at explaining it , But here is the problem I'm creating an application in visual basic 2010, and i was aiming to …

Member Avatar for Reverend Jim
0
482
Member Avatar for deviatov

Hi Everyone, i have created a form and placed my CRLViewer control on it, and not a new form. Everytime a search button is pressed the report open. However, i only managing to open the report once in one session. When i click the search button 2nd time i get …

Member Avatar for faroukmuhammad
0
192
Member Avatar for joshl_1995

Hello Community, I was making my own custom window and i need help with making it in wpf, i am new to wpf so i don't know much XAML so i was wondering if you can help?, this is what i wan't. In the example i'm using the minimize button. …

Member Avatar for joshl_1995
0
360
Member Avatar for TeaYou

Hello! I'm very new to visual basic and I'm stuck at transfering the text from one label on a form to another via a button click event I have 2 forms which I will call A and B. On form A I have a menu which when clicked brings up …

Member Avatar for poojavb
0
200
Member Avatar for gelaisg18

hi there i just have a problem with my program i used the keycodes of vb wherein every time i enter a letter from A-Z it will display each letter together with a special character " | ". Im done with this but my problem is, the letters were displaying …

Member Avatar for gelaisg18
0
141
Member Avatar for ponnu
Member Avatar for ponnu
Member Avatar for michael opoku
Member Avatar for jhai_salvador
0
126

The End.