10,992 Topics
 | |
| | Hello everyone. I am trying to build a inventory and pos software with vb 6.0 and MS-Access as database. In one of my form I have the following code to call my inventory of a certain invoice number to print tag for my products. I am using a MSHFlexgrid with … |
 | 'the code is working properly only problem with this code is when the first line ends in excel and data is inserted in next Row "instead of inserting another row it copies the same content which is inseted last time in form "  |
 | Please show me what is the correct code to compare the DateAdded (2012-12-26 00:00:00 - its format inside MySQL) and DTPicker (01-01-2000 default format from user input) Sub FilteredQuery() cnDDR.Open "Driver={Mysql ODBC 3.51 Driver}; server=x; port=3307; database=x; user=x; password=x; OPTION= 1 + 2 + 8 + 32 + 2048 + …  |
| | *to copy the codes of this sample article: just go to facebook to type this in your facebook search browser to find & added me: **jm amaro**, or you can add me as one of your friends in fb for i enable to share this topic.*Emphasized Text Here** or else, … |
| | Hello experts i am using following code in order to truncate a ms access table Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" Dim query As String query = "truncate table tbl" rec.Open query, con, 2, 3 con.close but its producing … |
| | I'm working on a project that contains 3 different lists. 2 lists of 2 different controls, and 1 list of a custom class. I found that I needed each of these lists sorted. The problem with sorting a list of complex types is there's no default comparer for them. That … |
| | This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes something like this: [CODE] With WS.CharObjects(SelChart).Chart With .SeriesCollection(1) .XValues =DataWS.Range("A1:A101") '<-----ERROR! .Values = DataWS.Range("B1:B101") End With … |
 | I am trying to reference a cell with a date from one worksheet to the other. I am using ='Statistics MVP'!A16 but it doesn't give me the date format it just gives me the number 41125 or any other number. When I format as a date form I get 1/0/1900 … |
| | Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in …  |
| | hi. a blind programming student, and did ask my lecturer, but he could not answer. has not done the talker classes before. i have a hangman self voicing game. it uses the anna voice, but looking for some more human sounding voices, like aussie, british, united states. did downloa and … |
| | For instance , i need store a database of a student.i will get all the details through the respective fields like name , no , mark1 , mark2 , mark3 etc.. nw i need to save this information . how do i do it ?. thanks :) |
 | Hello, I was wondering if there is a way to display formatting in a richtextbox eg. If i put **test** the word "test" would be i bold (only the word "test" and the rest would stay the normal). or if i put `test` the word "test" would be i size …  |
 | I have a volunteer database and having trouble with genuine password protections. I have a "delete" button with this current code under Build Event: Private Sub delete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Delete this VounteerRecord. Are you sure?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand …  |
| | I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly. Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013. In all above sheet : Part numbers mentioned in column "C2:C60000" Quantity in column "D2:D60000" … |
 | Has anyone used a card reader with vb6 and can you recommend one to get? I want to issue cards with names for players so they clock in to start the poker game and during poker slide to clock out where the program will determine their position and any points … |
| | |
| | To open a new window in vb by clicking a button replacing the previus windw |
| | I have a function that reads a text file that contains information about the sql database it connects to. It has to be invoked across multiple forms. How could I make it to where it is invoked once and then stores into variables that the program can continue to use … |
| | i just want to dowmload the application. |
| | hello experts . . . there is one textbox , one label and one command button i have written following to print textbox content to label `label1.caption=text1.text` and when & is inputted in textbox then underscore(_) is placed in the place of &. and i know that we use & … |
| | Hello there Good Day Guys! I need your expertise for vb6 guys i made a small program with command search button. Its working. My problem now when i search again with different category it shown this error [COLOR="Red"]Run-time error '3001' Argument are of the wrong type, or out of acceptable … |
| | hi i m new to vb with sql.i made login form.but after that on main form some feature will be disbleed for ordinary user and that feature will be only enabled to admanistrater.so on main form a button will be enabled with specific password that is in backend so i … |
 | Please can someone know how to trim this code. Any help will be appreciated If Range("D8") = "EBU 2" Then If ComboBox1.Text = "Level 4" Then Sheets("Main").Range("C9") = Sheets("Main").Range("C9") + 1 Sheets("Main").Range("D9") = Sheets("Main").Range("D9") + Range("K8") ElseIf ComboBox1.Text = "Level 5" Then Sheets("Main").Range("E9") = Sheets("Main").Range("E9") + 1 Sheets("Main").Range("F9") = Sheets("Main").Range("F9") …  |
| | Im using VBA build inside excel is there a way to find if ComboBox has a value? for example i have 80 ComboBox and i want to check if they have a value like "A", "B", "C" and "D" and if the value is blank like "" then stop the … |
| | I'm using the Visual Basic that comes with Visual Studio 2012 Utlimate, and everything I find online doesnt ever work. I am simply trying to make it to when a button is clicked the rows that are checked get deleted. Do While TodaysTrans.SelectedItems.Count > 0 TodaysTrans.Items.Remove(TodaysTrans->CheckBox.Equals(true)) Loop |
| | Guys I want to get my iput from a barcode reader. Apparently I don have a barcode reader but, I just want to make a code ready to operate in a shopmif a barcode reader is going to be foun later but th software or program already made. Please help … |
 | I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the …  |
| | I was wondering if it was possible to bound 2 combo boxes to each other. the first combo box with a set of information. Based on what the user selects, the second combo box changes. this involves 2 tables. table 1 ProductID Descritption table 2 Id FK_ProductID Category example: the … |
| | First i don't know if this will be right forum but i know its related somehow? I'm using excel developer visual basic and i have a combobox Dim x As String Dim y As String x = "O15" ' range With ComboBox1 If .Text = "" Then Range(x) = "" … |
| | Am new to the world of networking on LAN, i need help to get me in the right direction in creating a LAN Chat that has the capability to send file across the network. i want this chat to be able to handle more than 50 connections. how to connect …  |
 | i get this error message when i try to connect from clinets pcs to login with the crystal repor but the forms is correctly connect to the DB srver but the server not this is the error : Crystal report viewer login failed detail : ADO error code: 0x80040e4d Source: … |
| | |
| | Hello, I would like my Excel program to print the daily report on a remote printer connnected to Internet through a remote PC. Please help me with a solution. I'm thinking of using Google Print but any other solution is welcome. My best wishes for this New Year ! Cheers, …  |
| | WHERE Category = '" + CategorySorter.Text + "' AND DateAdded = '" + DateValue("DateEnd.Text") + "' " thats my query and its not working, if the user input a date(like this 12/25/12) in DateEnd.Text, i want to confirm if it is existing on a database |
| | I'm new on programming this VB 6, Advance thanks for those who'll reply. All opinions are open :3 (Sorry for poor English) === The program runs like this: I input the Student ID, then it searched using DAO now the student's info was shown up, what should I fill up …  |
| | I want to first off say, I don't know Visual Basic. I have a XML script that for a program that can only accept VB Scripts. I want a simple script to check whether, on it's own or if it can, from the XML file to see if a USB … |
| | hi all , when i install my vb project on clients machine and runing it its show this error : Cant generate SSPI Context , what should i do ???? |
| | when i need to install the vb6 project to network pcs this error is show : The program cant start because ActiveX Tools.dll is missing from your computer. Try to install the program to fix this problem. i search on internet for the dll required but i am not find …  |
| | Hello everyone. I am making a form to backup my Ms-Access database in vb 6.0. I have a textbox (txtdestination) a progress bar (progstat) a command button (cmdbackup) and a few labels to show different info. I have the following code in my backup form : Dim mintCount As Integer, … |
| | there is a picture file ( 40*100 ) and i wanna show this image in the background and so , this picture file should be repeated both horizontally and vertically as we do in Html and css |
 | hello i'm doing a project i use visual basic 2010 i have an issue with the select case it suppose to be when you press the 2 and the 3 it gives you all the names start with (a&d) (a&e) (a&f) or (b&d) (b&e)...etc. it works fine just the error … |
| | Hi DaniWeb Forums, The I'm making a simple timer. The label flashes every time the caption changes (this is the problem). See code below. If you run this, ensure to that timer interval property is 1000 for the timer and Label1 caption property is set to "". TY. Dim sec … |
| | Hi, How can I do to get motherboard and processor serial number in VB6? I am able to get HD serial number with this code: Option Explicit Private Type DRIVEINFO HDDSerialNum As String End Type Private Sub Form_Load() Dim info As DRIVEINFO Dim objs As Object Dim obj As Object … |
| | Run-time error '-2147217887 (80040e21)' Multiple-step operation errors. Check each status value. === The one highlighted was: **Adodc2.Recordset.Update** Private Sub Command1_Click() Adodc2.Recordset.AddNew Text13.Text = Label19.Caption Text14.Text = Label15.Caption Label5.Caption = Text6.Text + "-" + Text7.Text Label3.Caption = Text1.Text Label21.Caption = Text10.Text Text11.Text = Text6.Text Label17.Caption = Text3.Text + ", " + … |
 | hi all, i'm very - very newbie here, i need a help, i try to connect arduino with vb6, i want to display data from arduino to vb6, lets say the data is : "the distance : XX m", the problem is when i want to put data via mscomm.input … |
| | As the title suggest, I don't know how to add item to a multiple column list box. When I do the usual ListBox1.AddItem "haha" it only adds to the first column. How do I populate the others? Columns property has been set to, say, 3. I googled out this issue … |
| | I'm really new in ADO for just a substitution on Data Control (I cannot dl any access 2003 D:) --- Whenever I enter command3, it says: *Compile Error: Method or data member not found* and the highlighted one was **.EOF** Code: Private Sub Command3_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.Find "SID = '" & … |
| | I have been using Qbasic 1.1 in MS DOS 6.22 PCs upto P4. In view of the changing hardware scenerio, I wish to migrate to VB inside Windows 7 32 bit machines. Should i rewrite all code in VB or can I import .bas files created in Qbasic 1.1 into … |
| | When the button is clicked, I want the file (it's a XPS document) to be opened in windows. The file will be in the same directory as the visual basic project. Therefore, I need the code to open the file using "app.Path". Any solutions? |
| | When the button is clicked, I want the file to be opened. The file will be in the same directory as the visual basic project. Therefore, I need the code to open the file using "app.Path". Any solutions? |
The End.