10,992 Topics
![]() | |
[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. | |
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 … | |
i know some about vb.net programming and i'm interested in developing some software which is able to Get Data From Serial Port /parallel Port to my working form. can somebody advice me ,how to start such kind of developing and what should i refere (web sites /e books) for this … | |
Helo all, Can anyone help me .I want to put dilimiter in the substring of a whole string. Here is the string Amitav 12/3/2009,234,201,210,222 I want to put dilimiter in the left most substring like this Amitav,12/3/2009,234,201,210,222 ______________ How can i do that. Thanks | |
I know how to change the master volume control level, but I also need to know how to get the current level so I can change it back to what is was when exiting the application. Does someone know the vb code for this? | |
Hi, I'm trying to do a paste special (values) of Excel data into an Excel sheet but coding it from word VBA. I can get a normal past to work however with the paste special the 'Paste' argument is not recognised. I have tried the following (only the paste special … | |
Cashier 1.0 is a C++ program that displays on the screen item codes with corresponding item description and price (at least 10 items). It asks the user to enter the code of the item purchased by a customer. Then, its description and price are displayed on the screen too. Also, … | |
so basicly what i want to do is get a list of the open windows, like all of the tabs in the taskbar. thanks for your time! | |
help please... i'm into vb6 developing and it's my first time to incorporate a barcode reader into my system.. can someone give me a hint on how to do it.. the codes would be much greater... i'm going to use a handheld scanner... | |
Hello everyone, i want use EnterKey in my Project ,i write some code in from load,but still TAB key use in my project. Here is a code, [B]If KeyAscii = 13 Then SendKeys vbEnter End If[/B] | |
can anybody explain me.the use of redim statement and preserve keyword over here.kindly let me know the idea .any help would be Highly appreciated. [code=vb] Public Function LoadData() As Boolean Dim codeString As String On Error GoTo LoadData_Error Dim Obj As IProducts '// The classinterface Dim rs As ADODB.Recordset '// … | |
hello everyone, can u plz. specify steps how to convert s/w into exe thankyou | |
hi i am making point of sale system.. i want to make empty grid and i want to add list box in first cell of each row, that list box contain items name so that when user select item all other cell of that row is filled by the respective … | |
Hi! i'm a newbie in VB6, and I'm creating a program that reads arabic numerals and converts the specified Arabic numerals to Roman numerals. Is there a function in Visual Basic 6 that converts Arabic numerals to Roman numerals or vice-versa?:-/ ..,,If none,..would someone , post some code snippets about … | |
hi,all Just like the title,i want to programme a update software for my softeware,but i don't know how to start. Is there a function that can download in VB6?And how to check the version? Please help me.... | |
Hi, By clicking the button first time - it opens the form. if i try the same thing(in second time) .....In my form only [B]one textbox(using as a lostfocus[/B] and also using recordset[sql]) [B] Runtime Error '3367' : Object is already in collection.Cannot Append.[/B] Please ,help me out..........thanks in advance............ | |
i am usng key ascii 13(Enter key) to move between text fields... but the problem is that it produce some sound i dont want that it produce that sound, can any one know how to avoid the beep in vb6????? Private Sub Text1_KeyPress(KeyAscii As Integer) On Error Resume Next If … | |
a msflexgrid show my data. I write code in msflexgrid_click():[QUOTE]txt1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, 0) txt2.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, 1)[/QUOTE] for show data in textbox. but one error msg show: "run time error 381 subscript out of range" what I do now? | |
When I open a project in vb6 then show a msg: and tell me to see a log file. and the description of log file is below: Line 29: Class b8Controls4.b8Line of control b8LLogoB was not a loaded control class. Line 116: Class b8Controls4.b8ClientWin of control b8CW was not a … | |
Hello everyone, I am new to vb6 though i have done java and abap before. I gotta design an application which is a quiz with a countdown timer. I have created the countdown timer stuff but how do i create questions and answers? say if i have 20 odd questions … | |
Hi Friends, I need a help, I am making a project where I have to update the class database all at once, I made a function where some values are passing to update, It is updating the Database as well, But the problem is all the database is updated with … | |
i want to save a text file (eg:ABC.txt) in RES file and load it into a combo box or a list box using following code.. Open App.path & "\ABC.txt" For Input As #1 Do While Not EOF(1) Line Input #1, s Combo4.AddItem s Loop Close #1 how do i give … | |
Hi guys.. I need help with selecting an item in a listbox which gets its items from a database table using While-Wend Loop. The listbox lists the table's contents properly. My problem is how will I add the item I selected in the listbox (e.g. John, Erick) in another table … | |
Hi, i have a group box with 2 radio buttons; failure and success. I need to have the text (either failure or success) saved in the access 2007 database instead of values (1 or 2). The same is also happening with the combo boxes. Here's the code am using: (i … | |
At the moment I am currently working on a program (for school) that saves and reads CD album information from a file (pre-made). The information that can be saved (and read) is the album title, the artist, the recording group, the genre, the date purchased (in the DD/MM/YYYY format) and … | |
I am changing a VB6 program from DAO to ADO and bump into some problems. Before I go into the multi table problems I will start with a single table :-/ I have an Access 97 database with some tables. The tables have no relations among each other. I want … | |
Hi, please guide me how to use crystal reports in vb6.0.anyone can explain with small example.say for example select the db and tables and fiels and links between tables ,sorting fields..how to call that report using vb.. Thanks in advance, vanathi | |
Hi all, I am getting exceptions while downloading Excel template. i think the problem is in one sheet if i remove that sheet i am able to download with some vb error messages like cannot read file etc., As per my knowledge in vb code for downloading i have changed … | |
Hi All, If i protect a sheet then I am getting this runtime error stating Run time error '1004' Application-defined or object-defined error Its not highlighting where is the error .. can anybody help me please i have deadline by today evening.. thanks | |
in my database I enter three item in 'Item' field. paper, pen, pencil. in my vb project i have three text box. here I want these three item show in this three text box. how it possible. | |
Hi, i need source code on how to check whether a new picture has upload in the folder. the source code have to be in VB. Thanks | |
Please help me a piece of code loading data from recordset into combo box. Thanks! | |
How can I create group report in Data Report by writing code without using Data Environment. I'm using VB 6 and SQL server 2000. | |
Who has VB.Net notes for a beginner. Send them to [email]jyumbya@yahoo.com[/email] | |
hi, How do you make a exe open and run in a different directory in vb6? so my exe is in the directory D:\test.exe and want it to run in the directory C:\ without copying the file there | |
I have posted this before and have not resceived a response. My problem is that when I create a simple data report and then run it, it takes about 2 min to display. I thought it was something i did but i deleted my project and started again. for some … | |
Hi Guys, I got a problem with my report when I'm started previewing it. Just see this link for the details and my screen caps. [url]http://i206.photobucket.com/albums/bb243/jumbo08/REPORT.jpg[/url] Thanks and advance...:) |
The End.