10,987 Topics

Member Avatar for
Member Avatar for SleepDepD
Member Avatar for Smash919

Hello All. I'm trying to make a VBA Form, that fills a Excel Worksheet, but I would like to make possible that some of the textboxes autofill while user is inputing. I'll explain: Sheet 1: Num Name Telephone 1 AAA 0000124 2 BBB 0000323 3 ABC 0000311 I would like …

Member Avatar for jerty
0
80
Member Avatar for benjaminhan

Hi All, I had puted out my records from database and place them in Datagrid. Than I try to filter out unwanted records based on user inputed date (by using 2 DTPicker, a START DATE and END DATE). And I encounter this problem "Run-time error '3001'". Anyone has any idea …

Member Avatar for benjaminhan
0
113
Member Avatar for hery

This is my code after upgrade vb6 code: [code] Public ReadOnly Property TUJUHResult() As Object Get Dim vrn7Result As Object 'UPGRADE_WARNING: Couldn't resolve default property of object vrn7Result. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' 'UPGRADE_WARNING: Couldn't resolve default property of object TUJUHResult. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' TUJUHResult = vrn7Result End Get End …

Member Avatar for GeekByChoiCe
0
107
Member Avatar for veledrom

Hi, There is an error on [inlinecode]DataGrid1.DataSource = Adodc1.RecordSource[/inlinecode] method or data member not found. When i do below setting manuel in properties, there is no problem. Thanks [code] Adodc1.ConnectionString = "Provider=MSDAORA.1;Password=psw;User ID=iuu;Data Source=video;Persist Security Info=True" Adodc1.RecordSource = "Select * From movie" DataGrid1.DataSource = Adodc1.RecordSource [/code]

Member Avatar for jeng1111
0
77
Member Avatar for yanz

Hi everyOne..currently I m dOing my final yr project...I haf sOme cOdes attached..coz i realli don nOe how to continue...can anyone help mi... Thanks!! The one is bold is where i got stuck.. Thanks alot!!! [B][U]Codes[/U][/B] Private Sub cmdSendMesg_Click() ' Set up the communications port MSComm1.CommPort = 1 ' Com …

Member Avatar for roeyco81
0
220
Member Avatar for Richy321

Hi, I currently have a crystal report (verison 10) with a linked ole object linking to an excel spreadsheet. I need to be able to programmically change the link path at runtime using vb6. You can do it in crystal by going view -> links ->change source so surely there …

Member Avatar for Richy321
0
109
Member Avatar for nandy.cse

hi.. can u pls help me in setting header and footer for an existing document on a command buton click in VB6? im able to add header and footer for a new document on a command click event.. if i give the existing document name its getting overwritten and only …

0
38
Member Avatar for kehar

Hi, I am using Crystal Report 8.5 to prepare my Report and I want to convert the figures under currency to be converted automatically while printing the report. e.g If I enter 234 in my field kk than under text field hh it should be automatically written as two hundred …

Member Avatar for mustaf52
0
170
Member Avatar for Agent-of-Chaos

hi i am making pos system i am using msflexgrid.. and i have make combo box visible when user clicks on grid... i have data combo which contains all supplier company name.... now my problem is that i want to load the combo box with relevant products as user selects …

Member Avatar for vb5prgrmr
0
103
Member Avatar for Katkot

How can i add my Programme to firewall exception during Install.. Somefreind using delphi 2009 .. and he is doing it .. without any wrrning for user ,,during install his programme it will be add itslef at firewall exception .. Please help me how can i do it using VB …

Member Avatar for vb5prgrmr
0
66
Member Avatar for mi-ena

Hi, I am new to VB6 programming and have some difficulties... Here is my question: I have a For Loop running, wherein there should be some communicating with a serial port to get new data (will be implemented later), updating a data array and the corresponding graph. This works all …

Member Avatar for mi-ena
0
188
Member Avatar for quame

I'm working on a project. I have the options of developing a simple e - voting system for the department or a mobile application that can compute the GPA of students using preferably visual basic.

Member Avatar for vb5prgrmr
0
51
Member Avatar for sackymatt

Hi all, i would like to know how to access data in the database using vb6 and the database in ms access 2007. for example i have a table in the database called item, with data fields such as itemname, item-id ,etc, so if i want to access the data …

Member Avatar for vb5prgrmr
0
137
Member Avatar for ranga247

I am an training executive in a company , for the purpose of the training needs , i have designed a test for my subordinates using vb 6 about a product (cell phone) . In that test i had written the code so that after the test is taken by …

Member Avatar for vb5prgrmr
0
98
Member Avatar for abu taher

I type 2009 in mask edit box and select August from a combo box. then I press report button for report. then show this msg: "run time error 713 Application - defined or object defined error" another thing when I run the exe of this project in another pc then …

Member Avatar for vb5prgrmr
0
81
Member Avatar for a_kumar

Hi Team, In our Project We are using V6 and Microsoft office 12.0 object library to access the Ms Word into the Vb Application , every thing is working fine English , we have a requirement to Support the Chinese language also . kindly advice what are the step need …

Member Avatar for UniversalClicks
0
107
Member Avatar for Agent-of-Chaos

i takes the current date value and then save it to text1.text Text1.Text = Format(Now, "m/dd/yyyy") then i am passing Text1.Text which actually contains date to Sql String which Delets all record that matches the Expiry date.. if current date = expiry date then delete that record.. strSQL = "DELETE …

Member Avatar for Agent-of-Chaos
0
90
Member Avatar for wil66
Member Avatar for palavi

Hi all, i have applied 3 fromulas for the same cells so conditojnal formating is not working for 1 condition. formula i have given is [CODE]$C$12="test1" then format cells C10:C11 =$C$12="test2" then format cells C10:C11 =$C$26="NO" [/CODE] then format cells C10:C11 in these only 2 conditons are working 3rd condition …

0
62
Member Avatar for abu taher

I saw many project resize with change screen resulation. I mean I work with my project in 800 by 600 pixel resulation. when I run It 1024 by 768 pixels then its many control change. but I want it match with changing resulation. example: I have a image control with …

Member Avatar for vb5prgrmr
0
147
Member Avatar for NewVBguy

Hi VB6 Community, The whole idea is i want to import a txt file into access2003 using vb6 sql command. i want to use the insert into ado.command rather than using the ado.recordset because of speed. What i have in mind is to open 2 connections, one for the txt …

0
59
Member Avatar for Andrew de Beer

I use a treeview control to show a logical hieracy. But I cant get it to refresh when the values change. Running the code again just add more detail to the bottom of the previous nodes. I know it must be a simple requery or refresh but am stuck. Please …

Member Avatar for debasisdas
0
154
Member Avatar for lroyse

I'm trying to do what seems like a simple project, and find out who has an Access Database open. The basic code is below, and it works fine for me, (I'm a domain admin) but when a normal user tries to run it, they don't have the rights required. Is …

Member Avatar for lroyse
0
124
Member Avatar for Agent-of-Chaos

hi i have a simple problem i am creating purchase order form in vb.. i want to show incrementd value to user in text field every time user creates new order.....storing this in data base is not a problem for me but the problem is how i auto increment at …

Member Avatar for vb5prgrmr
0
127
Member Avatar for raavi.munaf

[CODE] Dim Friends(0 To 10) As String Private Sub Command1_Click() If Friends([COLOR="Red"]any[/COLOR]) = text1.text Then '[COLOR="Green"](what should I put here instead of [COLOR="Red"]any[/COLOR]?)[/COLOR] MsgBox "You already have " & text1.text " in the list else end if End Sub [/CODE] In above code I have an empty array of 10 …

Member Avatar for raavi.munaf
0
127
Member Avatar for abu taher

In my access file I write code in query [CODE]SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS TotalAmount FROM AccountInfo WHERE (((AccountInfo.Date)>=#1/1/2009# And (AccountInfo.Date)<=#12/31/2009#)) GROUP BY AccountInfo.incategory; [/CODE] It show the total amount between 01-01-09 to 31-12-09 and it show in report. but in vb6 I want I select this two date and the …

Member Avatar for vb5prgrmr
0
210
Member Avatar for burdigol

Hi there! Anyone who could help me in making a report with a picture for each record?could i do this without saving the pciture to the database? can i use the functions in crystal report to do this by just using the location of the picture? i hope someone could …

0
51
Member Avatar for abu taher
0
61
Member Avatar for firoz.raj

Can anyone Explain and Demonstrate the Difference between Modal and modeless form.Kindly let me know the idea.Any help would be Highly appreciated.

Member Avatar for vb5prgrmr
0
74

The End.