12,155 Topics
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 …
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 …
When you press a button I want to turn labels(with their current value) into textboxes.
Hi, I've developed and using one application in my System now i need to change some corrections in my application which is developed by VB6.0 and MS-Access, but unfortunately i lost my project file.Now i've only Package with setup only, How can i decompile my Application to get My code, …
hey guys ! good day! guys i have a thesis project,enrollment system in high school den i have confuse with how to process in sectioning. sample guys if one student will enroll in one section (section galatia)den if the staff will click save button den if its done. then another …
when i click the btn assign the error come out where go worng? Private Sub btnAssign_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAssign.Click ListBoxall.Items.Add(ListBoxassign.SelectedItem) End Sub (**ArgumentNullExceotion was unhandld** *Value cannot be null. Parameter name: item)* the admin the listbox done not show up which part go wong …
Hello I trying to get the email address from the database and input it to the asp code or html. I was able to read the email address from the database but not able to store the value. How can I store the value? Response.Write bs("email_addr") its reading from the …
In my visual basic code, I have an object **(objXmlCaseDoc)** containing xml document. I want to add a variable **(strPoNumber)** into this object at the beginning of the xml document. I would like to add the code for the variable where I have a comment in vb code which says …
Hi, I'm developing application in vb6.0 with MS-Access. When i try to fetch data between two dates using DTPicker for Ex. i select 15-Jan-15 , 16-Jan-15 in DTPickers it selects only datas from 16-Jan-15 it's not select data from 15-Jan-15.I'm using the following Query : sql = "select * from …
By means of Mates8, graph coding becomes a bit easier. The web page has four textboxes so the figure gets bounded to the left, right, top and bottom; and a draw button. Additionally, a panel control will contain the image generated by the code after the button is pressed.
I start programming in Vb6 a few weeks ago, and I have a big problem now… When I like to insert Date in .dbf table from my VB6 Application, I get the error: [COLOR="Red"][B]Malformed GUID. In query expression[/B][/COLOR] My SQL string: [COLOR="Green"]strSQL = "[B]INSERT INTO stok_sme (Date_time) VALUES ({^" & …
I've developed a simple banking system containing Deposite and Withdraw. I am using deposite,withdraw and balance are my database fields when i try to deposite the last balance fetched and then added with new deposite value i'm using (select last(deposite) from bank) this query to fetch last balance value . …
Hi, I had a little problem dealing with this error. It's raised when i run the application on another pc.But the program works entirely perfect except at two places when closing the forms. Before getting this error I had another error that says: An error occured creating the form. Something …
hi, I've developed a VB6.0 Application and i created Package. now i need to set Productkey or some systems which are allowed by me only can install my application... is there any techniques to do like this.. some of my friend told that we can do this using MAC address …
hi, I've developed VB6.0 Application i tried to Packege and deployment.. Package folder is created and if i try to install Setup.exe file installs the application but my Database file is not attatched i've to copy and paste it into the path(C:\Program files\Project1)... Can i do it in automatically...
Write a Program to assist a teacher in calculating student grade. Range Grade 90 - above A 80 - 89 B 70 - 79 C 60 - 69 D Below 60 E Help me Please Using Visual Basic 2008.
Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need to read Do Until textRowNo = 8 'discard these first 7 rows... Line Input #1, LineFromFile 'this is the row …
Good day! Is there a way to identify if a given date is hijri/arabic? Thank you!
Good day! I have a combo box which is readonly. It is loaded with data from the database. However, there is a point that I need to set text on it, and those text is equal to one which is in its list aleady. The below code produces runtime error …
Is any can give me a sample of a restaurant billing system using visual basic 6.0 ?Email me at garchitorenarommel@ymail.com . Thanks ! :*
in vb6, round off value with 0 precision for the numbers 325756.50, 327336.50 & 318646.50 shows as 325756,327336 & 318646. Other languages shows as 325757, 327337 & 318647. any one can explain? why?
hello. For i=1 To 40 Response.Write("<td height='30' align='center'>x") Else Response.Write("<td height='30' align='center'><input type=radio name=asd value="i"><br></td>") // PROBLEM HERE End If next the code makes value of radiobuttons "i" as string, it should print i as variable like 1,2,3,4,5,6,7
is there a way to search database viwable in datagrid view by selecting rows through a combo box, values trough a text box and display resoult in label? here is the code that doesnt work: Private Sub Command1_Click() 'populate datagrid trough textboxes DBGrid1.Columns(0).Text = Text1.Text Text1 = "" DBGrid1.Columns(1).Text = …
hello guys and happy new year!~ let me be the first to ask a question this 2015.. huehue is it possible to start with the same recordset when going to the next form? i have a textbox for name in form1 when i go to form2 i want to display …
in trying to clear all the input boxes on my form.. i have a textbox and combobox.. and i have found the code for clearing all textboxes which is: For Each Control In Me.Controls If TypeName(Control) = "TextBox" Then Control.text = "" End If Next the only thing to do …
I have a datagrid on the form bind with recordsets. I need to know if is it possible to assign that datagrid object into a variable? I have created a preliminary code but its not working dim dbgridvar as DataGrid Private Sub Assign_Click() set dbgridvar=Form1.Datagrid1 End Sub Thank you for …
I have the following query that list all chemicals(chemical tbl) and its consumption(receipt tbl). However if the chemical codes are not in receipt tbl, it does not show the chemical name. It should display the name and put the consumption as zero. My codes below: SELECT Chemical.ChemicalCode, Chemical.ChemicalName, GroupDetails.GroupName, Chemical.LastRate, …
I put my vb6 exe program on flash drives of my students. Some of them say that it does not open. (Others have no problem and can left click). I told them to right click and "Run As Administrator". My program then opens. They are using school computers in a …
Hi I have manage to install vb5 and trheed32.ocx Trying to install vb6 okej. when I go to components and mark sheridan then it comes up that threed32.ocx is not a valid ocx. Confused how can vb5 run with threed32 and vb6 **NOT** Any help it will help me lot. …
hello guys~ i need your opinion on the following code: Private Sub Form_Load() cmbUser.AddItem "Faculty" cmbUser.AddItem "Applicant" End Sub Private Sub cmbUser_DropDown() cmbUser.Clear cmbUser.AddItem "Faculty" cmbUser.AddItem "Applicant" End Sub i always use the combo box dropdown event when adding list to my combo box then i see some code adding …
Hello Group! I am in need of converting a "text" file created by a UNIX based program (it is only semi-formatted) and put it into a more-formatted text (.txt) file. Put a different way, this needs to be converted such that it can be opened in Notepad and it be …
Hi all My old old vb5 app does everything I want as far as mpg video goes. Random video and play a random segment. Fast forward and reverse. random groupings of large font, video segments and or pictures and audio I need the code to provide me with the file …
Good day! I have a listview loaded in a form in a **lvwIcon** view with checkboxes enabled.. I have checked some items from it, let say 5 items. Now when I switch the view to **lvwReport**, the checked items are gone. How to make it selected again? Thank you for …
Hello to all! I'm creating a database and I'm using Visual Basic in Excel. I have a problem with showing the data in the text boxes. For example, I have a Text box and a search button. What I want to happen is that when I type an ID in …
Group, In a post in VB 4/5/6, I question how to open a file with a wildcard as the file extension ([https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/488809/accessing-a-file-with-a-ever-changing-name](null). That worked fine for VBA. However I'm trying to do the same thing using VB.net. I'm having trouble finding the correct syntax. I hope you can help. Specifically, …
Hello everyone, I am new to the website! I've looked over the different forums and I think I'm in a dilemma. In my past (1996) I went to college to learn "Computer Service Technology", and in those classes I was taught Qbasic, Visual Basic, and a little bit of C …
Hello everyone, I am new to the website! I've looked over the different forums and I think I'm in a dilemma. In my past (1996) I went to college to learn "Computer Service Technology", and in those classes I was taught Qbasic, Visual Basic, and a little bit of C …
I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing …
I have her 2 combobox.. this combobox are coursecombobox & yearcombox.. example courses are IT,BSBA,&HRA IT-2 years BSBA & HRA- 4 years.. if im going to choose IT at coursecombobox the yearcombobox must show only 1st year and 2 year but if going to choose BSBA/HRA the year combox must …
hello, plz assist in this: Assuming i have a sourcecode for example for developing a stock management system, how do i edit it to suite my problem?
please help me with my project titled,"STUDENT GRADING SYSTEM" where by the system should capture data using forms, you should be able to edit, compute total marks, total points, grade and position. The system should also show the top 5 students in each class, and also SHOULD PRODUCE REPORT FORMS …
Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was …
if corrct this code it will come of the list in the datagridview in VB from access this my code: Private Sub ComboBoxadm_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBoxadm.SelectedIndexChanged Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql …
The End.