12,425 Topics
 | |
 | Clearing Controls & Forms in Access (VBA) |
| | |
 | |
| | 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 … |
| | Hello World I need a career advice and I am very much confused. Currently I have good skill set of the following stuff • Html/Xhtml/CSS/ • Content Management Systems Word press, Joomla, drupal, template customization, installation ,configuration • Os Commerce Applications as like os-commerce, magneto • Bulletin Boards • Real … |
| | 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? |
 | [TEXT] I have in Visual Basic 8.0 a MaskedTextBox1 with the mask "00/00/0000" (short date) I have in my MYSQL table a fields : "name" datetype CHAR(15) [COLOR="Red"]"birth-date" datetype DATE[/COLOR] "birth-place" datetype CHAR(15) I have one record: Name birth-date birth-place Andre [COLOR="red"]01-01-1974 [/COLOR]Amsterdam [/TEXT] [CODE] Me.TextBox1.DataBindings.Add("text", myData1, "name") Me.MaskedTextBox1.DataBindings.Add("Text", myData1, … |
| | Yeah... the semester is on! lol but anyway, i'm trying to find a solution manual for my text and wonder where you guys get 'em? i'm a decent googler and haven't came up on anything yet. my text: Microsoft Visual Basic 2005 RELOADED: Advanced by: Richard A. Johnson/Diane Zak any … |
| | A few friends and I have been working on an isometric MMORPG called Pirate Story Online. It's basically just a simple 2D MMO with a very heavy emphasis on humor and eye candy. We're currently developing the client in Python, the server in C, and we're using a MySQL database … |
| | 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 … |
| | my data report is portrait. how I change it in landscape. |
| | Hi Professionals, I found these tutorials and codes regarding 'Retrieve E-Mail Through POP3' on an e-book entitled 'Microsoft Visual Basic .NET Programmer's Cookbook'. I understand what each functions/codes are but how do i design the GUI/interface to fit the codes? Please advise. Thank you in advance. Best Regards, Md Azmil … |
| | Can anyone Explain and Demonstrate the Difference between Modal and modeless form.Kindly let me know the idea.Any help would be Highly appreciated. |
| | I have suddenly began getting 'out of memory' messages while editing an Acess2003 module VB code. It deletes the entered text that caused the message. There is no error number - that's the exact text. Restarting Access and rebooting have no effect. XP SP3, Access 2003, VB 6.5, 1.5GB memory, … |
| | I am able to create .xlw files that will open with Microsoft Excel, but is there a way to turn that into a .csv file? The code I use to create the .xlw file is as follows: [code]Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Add Set oSheet = oBook.Worksheets(1) oSheet.Range("A1").Value … |
| | pls someone give me a puiz project using visual basic 6 and ms access with adodc connection...plssssssssss... i am under pressure....pls upload file and send me immmediately |
| | Here's what I'm trying to compile: [url]http://pastebin.com/f7f6bceab[/url] Getting an error at: Public Declare Sub RtlMoveMemory Lib "kernel32" (Dest As Any, Src As Any, ByVal L As Long) Could someone else try and see what the problem is? I really want to get this compiled into a .dll |
| | Open a word document by a chapter/mark I would like a VB script to execute from Start - Execute for open a word document by a chapter, mark or any other symbol. Thanksss This is my first post. Best Regard to all forumers. |
| | I made data report with condition. I want to input a student id number in a text box and press a button to show all data of this student, but a problem when i input a number in the text box (and press the button) for show the report a …  |
| | hi VB Master, I'm building an application using VB6, MS Access 2003 as database, and crystal report ocx for printing and report. Right now I'm using ms dao (database files) to connect crystal with access. But it is very slow, when I want to show 1 record out of 1000, … |
| | in msflexgrid I have one fixed row. and 5 or more data show in 5 row. If I write code like:`txt1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 1)` then when I click on a row then only one text box show that data. but I want I click a button then all data of … |
| | I'm having this error: type mismatch.. i dont actually get/understand the error.. i think the error is in the WHERE clause [tblUserAccount].[UserID].. the field [UserID] is set to a data type Autonumber, and the roleUserID is set as integer.. [CODE] Global rolesDbs as new adodb.connection Global rolesRs as new adodb.recordset … |
| | Ive searched and downloaded somethings..But Im not sure what I do need to download, can someone post me a link to where I can get VB6? Or how exactly is VB used..I am a python user, but wanted to try VB for a change.. I am very un certain of … |
The End.