12,425 Topics

Member Avatar for
Member Avatar for Bashar_1

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")

Member Avatar for mridul.ahuja
0
892
Member Avatar for lyca

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%"

Member Avatar for lyca
0
282
Member Avatar for Liwons

SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME What is the missing operator here? In sql statement, pls I need help

Member Avatar for Liwons
0
134
Member Avatar for Liwons
Member Avatar for djjeavons
0
119
Member Avatar for Liwons

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 …

Member Avatar for djjeavons
0
292
Member Avatar for genie_ps

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 …

Member Avatar for borge438
0
3K
Member Avatar for Nicolei

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)

Member Avatar for ddanbe
0
240
Member Avatar for MAILENE

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 …

Member Avatar for Reverend Jim
0
207
Member Avatar for bdaunno

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 …

Member Avatar for cgeier
0
339
Member Avatar for billybob2022

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 …

Member Avatar for djjeavons
0
423
Member Avatar for Samir@ymail

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, …

Member Avatar for Minimalist
0
168
Member Avatar for Alessandrorenzi

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?

Member Avatar for Santanu.Das
0
77
Member Avatar for jeffcogswell

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 …

Member Avatar for Jerry_10
0
640
Member Avatar for Papa_Don

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 …

Member Avatar for Reverend Jim
0
327
Member Avatar for SaRa Ahmad

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 …

Member Avatar for Goutami_1
0
1K
Member Avatar for ClaireBear82

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 …

Member Avatar for Reverend Jim
0
137
Member Avatar for Spark_2

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 …

Member Avatar for Spark_2
0
4K
Member Avatar for benghoi

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 …

Member Avatar for Santanu.Das
0
245
Member Avatar for pravinkumar1

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 …

Member Avatar for pravinkumar1
0
434
Member Avatar for Centorpe

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 …

Member Avatar for AleMonteiro
0
1K
Member Avatar for KennieA

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 …

Member Avatar for Reverend Jim
0
516
Member Avatar for Lacrecen

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 …

Member Avatar for slavica.k
0
206
Member Avatar for wezhas

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 …

Member Avatar for Minimalist
0
121
Member Avatar for M.I.Sahil

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 …

Member Avatar for M.I.Sahil
0
2K
Member Avatar for jhaiyz

Hi to all daniwebians! I want to make application that starts automatically when windows starts! Anyone can help me? Thanks!!!

Member Avatar for jhaiyz
0
110
Member Avatar for realgerra

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 …

Member Avatar for happygeek
0
80
Member Avatar for diazv2

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

Member Avatar for diazv2
0
115
Member Avatar for Michelle_5

Is there any difference between visual basic 6 and 2010? SAP not working in vb 2010, help! :(

Member Avatar for jhaiyz
0
86
Member Avatar for jhaiyz
Member Avatar for jhaiyz
0
109
Member Avatar for wegdan

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 …

Member Avatar for jhaiyz
0
4K
Member Avatar for Shanu_1

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.

Member Avatar for jhaiyz
0
93
Member Avatar for Papa_Don

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, …

Member Avatar for |-|x
0
448
Member Avatar for Nova6112

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

Member Avatar for JerryFJustic
0
133
Member Avatar for M.I.Sahil

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 …

Member Avatar for M.I.Sahil
0
454
Member Avatar for edzel joh

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

Member Avatar for Reverend Jim
0
339
Member Avatar for M.I.Sahil

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 …

Member Avatar for M.I.Sahil
0
376
Member Avatar for PinoyDev

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 …

Member Avatar for PinoyDev
0
145
Member Avatar for Hari om
Member Avatar for Pompy

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 …

Member Avatar for Santanu.Das
0
184
Member Avatar for bonzo2008

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 …

Member Avatar for bonzo2008
0
259
Member Avatar for preciousjame
Member Avatar for TrustyTony
0
100
Member Avatar for PinoyDev

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 …

Member Avatar for PinoyDev
0
144
Member Avatar for PinoyDev

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 …

0
127
Member Avatar for bonzo2008

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 …

Member Avatar for bonzo2008
0
159
Member Avatar for Ash77

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 …

Member Avatar for rubberman
0
92
Member Avatar for Alessandro _1

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 …

0
88
Member Avatar for GGGraham

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 …

0
291
Member Avatar for Papa_Don

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 …

Member Avatar for Papa_Don
0
289
Member Avatar for krishom.ray

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 …

Member Avatar for Santanu.Das
0
116
Member Avatar for tbzserge

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 …

Member Avatar for clairestreb
0
141

The End.