10,989 Topics

Member Avatar for
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
282
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
179
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
485
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
150
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
99
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 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 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
87
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
193
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
74
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
222
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
136
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
154
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
249
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
267
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
456
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
179
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
344
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
130
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
88
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
160
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
291

The End.