[visual-basic] Forum Topics

hi i have report in visaul basic 2015 in it the salary and i want to make a tetxbox and but the total in it i tried this Sum(Fields!salary.Value) but i get error

Hi! I do have my own VB6 mp3-player, which uses "Un4seen BASS.DLL" audiolibrary to play mp3 files. It works fine, but it doesn't support reading album cover (picture) from ID3V2 tags. For reading tags in text format, I use imported vb6 class module, that I found few years ago. But …

Dear everyone, I have got a excelsheet with some vba code. The sheet contains a row with columns with specific information. When the user clicks a button, the code will look for the last row which contains data, copy the whole row, paste it beneath the row and the number …

I have a question,,Its all about homework Question score/item*50+50= Average,,How do I make the program of this situtation,

please check this code and tell me what is the problem with this ..... i get error*"operation is not allowed when the object is open"* dim conn as new adodb.connection private sub commandbutton1_click() conn.connectionstring="dsn=localhost;uid=root;pwd=root;" conn.open dim cmd as new adodb.command cmd.commandtext="select sname from stu" cmd.commandtype=adcmdtext cmd.activeconnection= conn end sub

I am new to all this VB coding so kindly assist. Here is the question: Given that an employee earns an arbitrary basic salary, write a program to calculate the employees net salary given that the deductions are specified as follows: NSSA contribution is calculated at 7% of the gross …

I wish to print invoice using printer.print method ( using USB dot matrix printer in continous paper) Some invoice contain 6 lines, some 15 lines. Now afer printing 5 lines printer ejectng paper. so paper waster ( paper width 5 inches, continous paper). I wish to top printing after printing …

I have a problem that my crystal report shows the decimal values as 00 every thing is fine but it does not display proper value e.g. If i have 0.235 it shows 0.000 If i have 2.356 it shows 2.000 Whats the matter behind it the database field is text …

I have a form with only 1 object on it , a progress bar. when the form loads it runs the progress bar, which is working fine. when the progress bar hits the max vaule i want the form to close but no matter where i put the me.close the …

Delete checked item (one or more) from listview I write this code. Dim x As Long For x = LVEmp.ListItems.Count To 1 Step -1 If LVEmp.ListItems(x).Checked Then con.Execute "DELETE FROM stock WHERE [SrNo] = '" & LVEmp.ListItems(x).SubItems(1) & "'" LVEmp.ListItems.Remove x End If Next con.Close Set con = Nothing but …

I have a BIG PDF file created by as a report. The file have 1.6M lines of data. No images at all. each page have a title with a page number a header for the columns and 28 data lines after it. Each line have 12 fields. Some data fields …

I am trying to design a calculator. I want to use the Kryptonbutton from the Krypton Component Suite. This is the code I have so far to display 0-9 in the calculator display. Private Sub KryptonButton_Click(sender As Object, e As EventArgs) Handles KryptonButton1.Click, KryptonButton2.Click Dim b As Button = sender …

i have 2 combobox 1 is that to check if the status of the room is available or occupied. i want to show my records into my combobox of what is the room type that is available. for example: cmbroom has two item the "delux" and the "ordinary" in my …

Hi everyone,i'm currently making a random name picker .I got a csv excel file saved with 3 columns of data...one is the first name ,last name and tutor group. I want to be able to search through the database and read just the first column of data and be able …

Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With …

I want to have a random picture to be displayed in a picturebox from a list of jpeg files in my debug folder in visual basics. At the moment i've been using this code to display a specific image but I want the image to be random... If Label1.Text = …

hello guys I created an app in visual basic abd i want it to be requsting for a password when installing it or transfering it from one computer to the other. I want to put security to it. Any help will be appreciated

Hi all, I am trying to schedule a Task that will run a vb script to open a browser, send some keys, and finally close the browser. The task starts, but seems to hang. The task is created as follows: `schtasks.exe /Create /RU "SYSTEM" /SC "DAILY" /MO "1" /ST "23:00" …

Hi... does someone know how to CONVERT NUMBERS INTO WORDS IN VISUAL BASIC 2008 until millions by using recursion??? if yes... can you please share to me the code??? thanks a lot!!!

i never used VBScript. how can i use win32 functions?

Hi I have an excel macro question in VBA. I have this code. I want it to go down each cell in row C and run the same if statement instead of just depending on cell C2. I want it to continue to C3, C4, C5, all the way till …

Hi guys i need help to read block data from binary.. The format is Byte position, Content, Format 1 - 4, Block Length, I * 4 5 - 12, Sensor Name, C * 8 13 - 20, Satellite Name, C * 8 21 - 24, Latitude, R * 4 Im …

I want to find the MAC address of network adopter, I have a working code too but my problem is it only works if IP addres is enabled otherwise it won't get the address is there any solution to find MAC address even if IP Enabled is false if its …

Good day, I have created a WPF (visual basic) application. On the main-page, I have "tab control" inside a "grid". On "tab one" the user selects an "ID" and below the "datagrid control" populates with information (this works). On "tab two" more data (from a different table (linked – using …

HOW TO CREATE TIME IN TIME OUT in visual basic?

Hello! I've been debugging this VBA program that computes the root of an equation using Newton Raphson method and with the use of the UserForm. The user will type the equation, the initial guess and the number of iterations. I was able to search on automatically differentiating the equation unlike …

Hi all, I'm trying to make super simple essay-writing-helper program, I have created 4 forms (intro,paragraph1,paragraph2,result) and in each form contains a textbox where the essay will be typed in. The first form is for the introduction, and next is the first paragraph and so on. The last form the …

Hi I have an existing Visual Basic 6 program which prints to an attached (LPT1) Dot Matrix Printer. Printing is done by first sending the output to a file and from there sending it to the printer. There are a set of Escape Sequences like Print #1 chr(15); chr(3); strVarName …

Hello. Im new to this coding stuff, so I want to know how to make controls moveable when the program is actually running. My aim is to make a panel with a label and button moveable. Its kinda like a widgit :) Im using Visual Basic 2010 Express. Thanks! (PS: …

I want to create a program using vb 6.0 that is connected to a wamp server database.is it possible?can you help me with step by step instructions for it?thanks alot i badly need it for my school project..

Hi group, I'm trying to insert both a copied range (from and Excel file) AND a message (text) into the body of an Outlook email. I've perfected the code to insert the range, but I've not figured out how to get the message to go along with it. I hope …

i am using VB 6.0 and MSAccess in my project.. in one of the forms i use a flexgrid to store data into and load data from database. and also to edit each cell i use a textbox. alll these are working perfect, bt i have a problem with saving …

hi i having trouble with saving and checking duplicate with my coding..i can't save my data and when i save a new data , it's always say duplicate..i want to save my new data and if it record is already have it, want to show a msgbox saying duplicate..here my …

I create a project add some item (C_Number,E Number, Model, Type, Color, Key No, Price(numeric field)) in MSFlexGrid1. then add a button when click on this add the record in data1, but only 1(one) data add in the data1 database. I use access database. How can I add all (minimum …

Hi i got a sheet in a work book that i am working on now with form control (dropdown). The code i made changes the color for the text in the entire row, or highlights it, works fine. But i would like to add code to change the cell value …

I am trying to make it to where it will read the registry and report back if ProxyEnable is set to the value of 1. If it is, it replies back that the privacy is in risk, if not it says privacy is safe. Here is my code. Any help …

i want to show the duplicate record with a msgbox,but i dont know what to do next, please help for some advice and coding ...ty Private Sub cmdadd_Click() On Error Resume Next If (txtempid.Text = "" Or txtempid.Text = Null) Or (txtempname.Text = "" Or txtempname.Text = Null) Or (cbodep.Text …

Hi I need help I have some XML files which have more children and grandchildren, than I am used to playing with. (Link to xml file below) https://intecprinters.iweb-storage.com/s/IjU2OTNlNjVkNmExODkyMDlmNjU5N2MyNiI.jaEay6nxR-v-gaiJwcVNiP113QI I need to be able to read the xml, determine the name Root node ,<JOBS_Jan_2016> and obtain the list of names of …

Hello Friends I am facing a little problem that I want to sort my records according to date I mean to say I want to show the upcoming records based on dates on the top in ascending order I have a complete working code to fetch from the database but …

Dim arr1 As String If Left(arr1(i), Len(n) + 2) = n& ": " Then titleBar = String$(100, Convert.ToChar(0)) valid1 = Right(arr1(1), Len(arr1(1)) - 13) how to convert vb6 to vb.net ? Left String$ Right Private Declare Function ObjectFromLresult Lib "oleacc" (ByVal lResult As Long, ByVal riid As Guid, ByVal wParam …

i need help in adding a new record to the database using adodc in vb6.. i've a command button named add in my form...

I am facing a problem that I have to show database results from 3 different tables on a single report these three tables have are used for different purposes and want to show their headings details separately. I am using VB6 and designing this report in **DataReport** a common feature …

I am developing a sample project in Visual basic 6 and MS Access 2003. 1. I wish to print Invoice in Continuous statonery (Roll Paper ) width of paper 5.5 inches I am using printer.print Code using (x,y) co-ordinates My problem , after printing one bill printer skips and giving …

How do I query a database with unique id to display records in list item

Can I get assistant here.. I want to query a database with I Unique id and and display report on list item control with vb6

I have a new command in my connection 1 of my dataenvironment, but, when i drag the "Command1" to my form, i cant see the labels and textboxes , why? Please help me, its my homework

Aslam o alikum, I create a report in Crystal report 9 with add command using Oracle 11g as Database with OLE DB (ADO) (Microsoft OLE DB provider for Oracle). It works fine in crystal report. I want to call this report from vb6 form. I m not using any server …

Hi Dw. Firstly I would like to ask if there is anyone know a good download link to download VB6.0 I'm in need of this IDE. Now coming to my actual question of how to detect USB insertion and removal and get a drive letter for it in VB5.0? Thank …

A sub procedure in Visual Basic that sets the vertical and horizontal sizes of a form named DemoForm to half the vertical size of the screen and to three-quarters the horizontal size of the screen respectively. ******************************* A program that can be used to generate and display the following multiplication …