12,425 Topics
![]() | |
hi all this code give me input box i want to make the Characters like this ******* Dim x As String x = InputBox("inter password") If x = Label1.Text Then Me.Hide() frm_chose.Show() Exit Sub End If MsgBox("try again") | |
im a complete newbie in visual basic and im currently working on my first project which is the book borrowing system. the project is almost done except with this error. Syntax error(missing operator) in query expression 'Title like %Mathew Henry's Commentary:GEnesis to Revelation%" | |
SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME What is the missing operator here? In sql statement, pls I need help | |
How to delete record with msgbox? Pls i need this for my project | |
Dim searchvar As String Dim sbookmark As String searchvar = Text1 searchvar = Trim$(searchvar) If searchvar <> " " Then With Data1.Recordset sbookmark = .Bookmark .FindFirst "ACCOUNT NO like'" + searchvar + "*'" If .NoMatch Then MsgBox " No Record Found " .Bookmark = sbookmark End If End With End … | |
Hi, I am a new member in this site. I am also just learning VB6. I made some progress in programming a report generator for my farm. However, after having designed a report using Data Report designer, I keep getting the same result or reports repeatedly although I have changed … | |
I Dont Know How To Add The Login Code And The Poll Code This Is My Layout Created In Visual Studio 2013 Login [Click Here](http://i300.photobucket.com/albums/nn4/Nicolei_Esperida/Screenshot%2016_zpscdvryyx0.png?t=1425394848) Poll/Voting [Click Here](http://i300.photobucket.com/albums/nn4/Nicolei_Esperida/Screenshot%2018_zpsqjyvn3pk.png?t=1425394868) | |
Hi to all! I am having a 69 fields in datagrid, i can add data into it but as i have selected certain row, not all data displays on the corrsponding textbox. there are 5 fields didn't display "runtime error subscript out of range"... here is the code: Private Sub … | |
Hey everyone, Great forum. Glad there is so much help out there. I am currently working in VS2010, Visual Basic. I am working with a fairly large array: RawData(0 To 3799, 0 To 1259, 0 To 4). I am importing the data from an XML file, so this takes several … | |
I need help when i try to save the value of my buttons it says that it cannot convert 1 dimensional array to system.collections.arraylist which is the option i am using for my saving. I have seventeen buttons in total that i would like to save the text from. Any … | |
Dear sir, I am getting some port input in ASCII form, and wanted to convert it in HEX form, I have used following code '\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////// For A = 1 To Len(sText) HexIt = HexIt & Hex$(Asc(Mid(sText, A, 1))) & Space$(1) On Error Resume Next DoEvents Next A HexIt = Mid$(HexIt, … | |
I have to call a Sub in "parametric" way, for instance instead of: call MySubCompute( par1, par2, par3) in a way like this: dim MyString as string MyString="MySubCompute" call MyString....... can you help me? | |
Every year or so for the past couple of decades I've seen new products appear that claim to let you create software without having to know how to code. And every time the next one comes out, I roll my eyes, because they always fail to deliver as promised. Usually … | |
Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How … | |
Set rs2 = New ADODB.Recordset rs2.Open "select * from company_name", db, adOpenKeyset, adLockBatchOptimistic rs2.AddNew If pdfpath <> "" Then Set pdffile = New ADODB.Stream pdffile.Type = adTypeBinary pdffile.Open pdffile.LoadFromFile pdfpath rs2.Fields("pdf") = pdffile.Read rs2!co_no = Val(co_no.Text) rs2!co_name = co_name.Text ''' pdffile.Close Set pdffile = Nothing rs2.Update Set rs2 = Nothing … | |
Hi, I need to write a program which counts the frequencies of heads and tails when a coin is tossed 15 times. The user enters H or h for heads, T or t for tails. to record the outcome of each toss. It does 15 tosses then you have to … | |
I'm trying to take some basic form data (item and quantity), from a form where this sort of information is filled out by a user, and after the user clicks "ADD", the entered info is moved to a DataGridView on a different page. The following code: Me.DataGridView1.Rows.Add(...) ...does not work … | |
Hi Im new with this and tryng to learn thru reading any sources in internet, but i have no idea where to find a solution to my problem. Every time i save or update a new entry to my database it working find but when im trying to search the … | |
Is any one know about Quick Basic is a popular DOS programming language developed in 1980’s and it was widely used by many of the US companies for games, software for small businesses. As the programming technique had easy steps, it derived the name. It is an updated version of … | |
I've managed (over a very long time) to write a program in VB using Visual Studio 2008. This program is now published to my website and works well. Probably because people shy away from downloading and running .exe files or due to lack of my understanding of search engines, I … | |
Please I am a beginner to Visual Basic can anyone you help with this coding: Write a program that plays “guess the number” as follows: Your program chooses the number to be guessed by selecting an Integer at random in the range 1–1000. The program then displays the following text … | |
hello!~ i have a search button on my form and i need to search all the information inside the "information" table. i have 10 fields. what i've code is: adoInfo.RecordSource = "select * from information where name+age+score+birthdate+gender+civilstatus+citizenship+contactnumber+address+email like '%" & txtSearch.Text & "%'" adoInfo.Refresh If adoInfo.Recordset.RecordCount = 0 Then MsgBox … | |
im studing my a'level may please help me to solve this problem **scenareo** the hk university's mathematics dpt is looking for a way to automate the determination of the roots of a quadratic equation. The equation is of the form ax2+bx+c=0 where a,b and c are abitrary constants. The solution … | |
AOA, I m using vb6 with Access 2010 (DAO recordset) and Crystal Reports 9.22 I have developed a projet in vb6 it works fine at desing time but when i Install it (i mean after Package and deployment) and run the projet everything works fine but when i run reports … | |
Hi to all daniwebians! I want to make application that starts automatically when windows starts! Anyone can help me? Thanks!!! | |
Input and store the temperature recorded for a month. you must store the temperature in two dimensional arrays, one for the midday temperature and one for the midnight temperature. All the temperature must be validated on entry and any invalid temperature rejected. you must decide your own validation rules. you … | |
I want to create a login form by taking the text written on the notepad file in the same folder . is there anything that can help me | |
Is there any difference between visual basic 6 and 2010? SAP not working in vb 2010, help! :( | |
Anyone can help me out on how to code an updateable program? Any help would great!.. | |
i need to connect the data grid to access db using ado code and vb6 (without using adodc control)and diplay the result of a select statemet on it and here is the code that i am using (it give me a run time errorr 3705 : the operation is not … | |
i am in need of coding for retrieving data from access database using combo box, which means retrieing the stored particular details that for eg, retrieving particular students details using the students id that is retrievied by combo box. | |
I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why: On Monday's, I'm having to combine text files created over the weekend that will eventually be read and pulled into an Excel spreadsheet (generally there are three files). Using VB.net, … | |
Hi, I'm developing VB6.0 Project using SqlServer2008. After completing the project if i'm using MsAccess the .mdb file will be stored in Package but when i'm using SqlServer Which file shouli use or how can i use sqlserver for using in other system which are not installed SQLServer2008 | |
AOA, I m using VB6 as front end and MS ACCESS 2010 as Database (DAO recordset) , I have created some Parametric queries in Access and also created some Crystal reports based on those queries, all this work find in designe mode, but when i compile the project and make … | |
i am a student college ,we have a project that covers the inventory and pos i need help for giving me some advise to create this project using vb.net and ms acces | |
Can anybody let me know, why i receive a (Runtime error 3319: Syntax Error in union Query), when I run the following union Query : sSQL = "SELECT 0 AS VoucherNo, #" & Format((txtFromDt), "dd/MMM/yy") & "# AS VoucherDate, " _ & "Vendors.VendorName, ""[Balance Brought Forward]"" AS Narration, 0 AS … | |
I am creating a table dynamically of which fields are date. I have a running code below but I want to remove those doble quotes in both sides.. If I remove the chr(34) on both ends, I get this error saving "invalid field defination". My code and table screen shots … | |
Hi i am trying to do this project for class and i have been stuck on it for a couple of days Here is the assignment **Array Assignment Write a program that allows the user to enter up to 20 Pro team names and then displays them. The user doesn’t … | |
Can I save the information from common dialog Save as Jpg or Bmp format to an INI file and retrive it when the program starts. Now I have this line Image4.Picture = LoadPicture(App.Path & "\test.bmp") to load the picture. and it's not good. I would prefer to have that the … | |
am trying 2 wirte a program about crime record in visual basic6.0,i need your help please | |
Good day! I just need a little help on how to get the last months date (dd/mm/yyyy) between two dates? I have two date pickers(fromdate & todate). Ex. If fromdate is 24/01/2015 and todate is 24/12/2015, it should enumerate the end of the months starting fromdate to todate. So the … | |
Good day! I just need a little help regarding my query..I need to get the opening balance by subtructing debit and credit column where date is less than fromdate(datepicker). But sometimes if the fromdate is a date without transaction, it still displays opening balance? I cant figure out whats the … | |
I will not that the code below shall count up or down '********************************* Sumtax For lngIndex2 = 1 To ListView1.ListItems.Count lngTot2 = lngTot2 + ListView1.ListItems(lngIndex2).SubItems(5) Next Text10.Text = Format(lngTot2, "###0.00") if I have say 83.67 in a listview then in the text10.text shall be the same amount no differens text10.text … | |
Hi all, Hopefully this is a simple question to you guys. I am trying to do the following: I have created a userform, in which I can select balance sheet items. The commandbutton of the userform copies the selected balance sheet items to Sheet2. Based on the number of years … | |
I have Farpoint Spread 3.0 with VB6 and I succesfully populate the grid binding the control to an ODBC Oracle table and also the formatting works well. I need to change the data in the grid and save them automatically in the database. I activated the property DAutoSave = True … | |
This tutorial is meant to be a helpful guide in order to successfully **create a tripwire application in C# which can be used for security purposes.** At the beginning you can find the background information to be fully familiar of the subject of this implementation. After this, we will put … | |
Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a … | |
Dear Senior, I want to make a small application for inventory Management for my store keeper into he will enter stockout/Expiry/Return detail and through which he can find detail of present available stock and can cross check their all report with actual available stock. i can use VB through VS2013 … | |
Hi there, I have an excel sheet which contains CustomerPartNumber, MPN, CustomerPO,TotalReel,Company,Location,....as header. I need to print all the records which contain CustomerPartNumber, MPN, CustomerPO,TotalReel,Company data using barcode printer. I have succeessfully done this part. The problem is the header excel sheets that i receiving is not in a fix … |
The End.