10,989 Topics
| |
There are probably a few different version of this...here's the one I use which I find pretty simple: | |
Simple CLS for Resizing CTLs on a FRM | |
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 … | |
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 … | |
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 … | |
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] | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
Hi, how can I simply read the excel data using vb 6.0? | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
[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 … | |
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 … | |
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 … |
The End.