12,425 Topics

Member Avatar for
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
287
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
183
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
489
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
153
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
147
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
102
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
175
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
664
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
91
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
197
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
76
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
226
Member Avatar for seeking_help

so i am using visual basic express edition 2010 i am now able to select an image and displaying it in the picture box. now i need to run a c code (its exe file) by clicking a button in the vb form. i was able to this too by …

Member Avatar for Pgmer
0
107
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
139
Member Avatar for McLaren

Yesterday I accidentally found game creator for html5. https://www.scirra.com/ I follower beggingers tutorial and in more than 2 hours I created a game where player walks in the terrain, and zombies are attacking him. Player shooot them, then those zombies explode. I cannot imagine how much time it would have …

Member Avatar for pritaeas
0
181
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
5K
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
158
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
270
Member Avatar for timon.bijl

Hello , I'm making tetris in vb.net and i'm working with an image in a picture box that falls and with classes , my whole program works but hen my image falls it actually copies itself , does anyone know an eraser function or something or a method how to …

Member Avatar for faroukmuhammad
0
256
Member Avatar for Matigo

Hello everyone I'm creating an application in visual basic 2010, "I'm very new to this" What i want to do now is to make a monitor to check the status of the website server (If it's up or down) I know that i can just ping it using CMD"command" But …

Member Avatar for Matigo
0
129
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
276
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
467
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
184
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
349
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
189
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
132
Member Avatar for ponnu
Member Avatar for ponnu
Member Avatar for michael opoku
Member Avatar for honnysingh

I using following codes to add images in my project & its working properly in winxp but not working properly in win7 platform. please help me to find the problem. If you any other better codes to add images to MS-Access databae then please suggest. thanks Public Sub FillFields() If …

Member Avatar for jhai_salvador
0
92
Member Avatar for lorens5
Member Avatar for deleted1234

[COLOR="Green"][CODE]Private Sub Text1_Change() Text1 = Format(Text1, "#,###") Text1.SelStart = Len(Text1.Text) End Sub[/CODE] This code formats the textbox value to include a comma for every 3 digits to the left. Problem is, it doesn't allow to type decimals like 3,000,000.50 What can I do?[/COLOR]

Member Avatar for AndreRet
0
6K
Member Avatar for mahela

Im using listbox with style = 1-checkbox. "project.mdb" is the database name "goods" is the table name. "tabno" and "tabid" are fields in the table. dim d as database dim table as recordset dim b as integer dim c as integer Private Sub Form_Load() Set d = OpenDatabase(App.Path & "\" …

Member Avatar for AndreRet
0
162
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to programmatically import a dll containing a form. Example: When i press a button it will open the form from the dll. NOTE: I need to programmatically import the dll. Please help

Member Avatar for Begginnerdev
0
294
Member Avatar for mbrown1

I am a huge rookie when it comes to VB, I have written a small macro to open a report in excel, set the column widths, and extract data to a spread sheet. The main issue I have is that I have to manually open each file as the macro …

Member Avatar for mbrown1
0
321
Member Avatar for bprosic

Please, I need help. I have an aplication in Visual Basic 2010 and database created in Access 2003. It's very simple database, it has two tables named 'doctors' and 'patients'. I want to itegrate databse into VB. I used Wizzard to integrate. Now I have Binding Navigator (with buttons Next, …

Member Avatar for Icone
0
316
Member Avatar for jeanray

I have a small player built on a frame. At form_load, I set the form width/height equal to the size of the design (two fixed size images on top of each other. The form has no border, no control (dock, min, max, exit). When running, the user wants to move …

Member Avatar for Darkpiss
0
3K
Member Avatar for spunkywacko

Hey guys just joined.. So I'm learning C#, and kinda having trouble with finding the command prompt? Installed Vistual Studio 2008 Express with C# and visual basic. After that I installed XNA 3.1. It's supposedly in a folder in the start menu under 'Microsoft Visual Studio Tools', but I have …

Member Avatar for abhinavgoyal02
0
330
Member Avatar for tet3828

I have two forms that share data between eachother. 1. In Designer view of Form2 I establish a public variable. public bool isMyFormValid 2. When I attempt to access the variable in Form1 like this... if (Form2.isMyFormValid = true) { //do this} C Sharp no likey... I get this message: …

Member Avatar for tet3828
0
186
Member Avatar for honeybee2090

i want to filter items from list view , i want to remove every kind of items from it but these 202.38.95.66:1080 67.191.234.52:1158 125.88.125.201:1080 65.30.204.106:1188 83.183.96.123:45712 72.74.41.97:46331 69.42.126.106:46486 69.42.126.106:46486 60.241.65.32:47501 60.241.65.32:47501 173.16.5.49:47708 173.16.5.49:47708 93.176.11.69:48293 93.176.11.69:48293 71.114.46.27:48505 i just want to show these items in list

Member Avatar for AndreRet
0
989
Member Avatar for Doogledude123

Hello everyone! Quick survey, are you guys liking Visual Studio 2012? Comment below and say why you are, or aren't enjoying it!

Member Avatar for deceptikon
1
266
Member Avatar for mahela

In my project I have a datagrid with 2 columns namely "codes" and "description".there are details under code and description columns.I wanted to print the datagrid.please help me.

Member Avatar for mahela
0
91
Member Avatar for udaraps

i hv the same problem with [B]VB 6.0[/B] & im using [B]MS ACCESS[/B] for the database. Pls help me to code my program as im unable to pass the values display in the text boxes to the data grid in the same form thnx in advance regards uda

Member Avatar for akgs
0
923
Member Avatar for locsin

Greetings! Is anybody know how to set textboxes in visual basic 6 in multi-languages. I want my textbox accept both english and arabic. Thank you in advance!

Member Avatar for akgs
0
707

The End.