12,425 Topics
![]() | |
**I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil** | |
Dim Dbl1 As Double Dim Dbl2 As Double Dim Aux1 As String Dim qtyadd As String Dim subtotaladd As String Dim itm As MSComctlLib.ListItem Dim i As Integer Set itm = ListView1.FindItem(txtCode.Text) If itm Is Nothing Then ListView1.ListItems.Add , , txtCode.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add , , txtproductname.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add , , txtqty.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add … | |
just want to know the correct synthax for creating a table in access database using vb myqry = "CREATE TABLE HoldInvoide'" & k & "'(Barcode varchar(20) not null Primary Key, ItemName varchar(40) not null, Quantity int , Price double, Total double)" k is a variable i want to create a … | |
experts please help on querying and counting the frequency of data, i want to count the number of data appearance then put it on like this: Name----Lastname----Relationship----Freq Egie----Tayag-------Brother---------2 i will place the result on a report counting the number of a person's visit on the theme park. TIA ^_^ SELECT … | |
Hello I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so … | |
Hi Experts, my sql query below returns 0 value, though I have entries in my data base. Please help me check my codes below; Private Sub cmdSearch_Click() Dim sTrID As String sTrID = txtSearch.Text Dim Total As Integer Set rs = New ADODB.Recordset rs.Open "Select Count(DateIn) as Total from Time_In … | |
I'm new with VB6 and i'm a self learner.. I need help with coding for generating data report by filtering between 2 dates using 2 dtpickers. i'm using data environment and the dates are in 1 field | |
Hello Guys Help Me To Count The Item in Listview and Update it. Scenario.. Customer Buy 3 Milk and 2 Nescafe then the Cashier Punch it Item-----------------Qty Milk-------------------2 Nescafe---------------2 The Cashier Forget to Punch the 1 Milk. the Cashier should Punch Another One Milk..But My Code This is What Happen … | |
Hi Group! I need to write the data from multiple TextBoxes (which I've moved to individual string names) into one text file (miscflds.txt). These individual strings will need to be written one on top of the other. To be clear, it will need to look like this: Item A Item … | |
Private Sub Command1_Click() Dim a, b, cc As Integer Dim p(3), d(3), e(3), t(3), h(3), w(3), c(3), f(6) As Integer If Text4.Text <> "" Then strfile = Text4.Text Open strfile For Input As #1 For i = 1 To 3 Input #1, p(i), d(i), h(i), w(i) Next i Close #i … | |
Hi All, I'm trying to save an incoming email as a .txt document but I'm having some trouble with the VBA. My procedure is as follows: Sub ConvertToPlainAndSaveAs(Mymail As MailItem) Dim strID As String Dim objMail As Outlook.MailItem strID = Mymail.EntryID Set objMail = Application.Session.GetItemFromID(strID) objMail.BodyFormat = olFormatPlain objMail.SaveAs "C:\Users\Me\Documents\path\to\Test.txt", … | |
Group, The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected … | |
I'm making a calculator, and I want the question(text) to shift the left when the textbox is full. So as you type, it shifts to the left(only when the textbox is full) to make the newly typed question visible. In a normal textbox the text shifts to the right making … | |
I've been battling with this for the pass few days. I have an access03 database that is used to track training that we give to employees. i had a form that has, the training info and then a subform that lists all the attendees and their scores. Now I was … | |
Hello, its been a while since I have been here but I am in need of assistance. First off I haven done this in a while so to say that I am rusty is an understatement. What I am trying to do is create a form that allows for input … | |
Hi, I've never really created a login screen in VB and connected it to a table in MS Access before. So I'm supposed to create a login screen and after gaining access to it, a main menu form needs to show up which would be connected to the rest of … | |
Hi experts, I have a Daily Records form of an employee. my fields are; search box search button datefrom (datepicker) dateto(datepicker) datagridview (fields are Employees_IdNo, DateIn, TimeIn and TimeOut) totaldays totalhours The scenario is this, first search for an employee using Employee number, set the datefrom and dateto to two … | |
Hello, I am curious about starting to use XML concepts within my visual basic.NET applications. I have seen a few things on the internet, but I'm still a little confused on how to start using XML. I would really appreciate if someone could explain to me how to use XML. … | |
how to add scroll bars to mdi form when the height of child form is greater than the actual height of mdi parent form . . . | |
hello guys, can help me out? My assignment need to do a registration system. Student register use identification card(put in mycard reader) and the existing database(already have student data) will recognize and mark the student attendance and the system also can check how many people are coming for the event. … | |
Hello, Here is the scenario : I have the follwoing sales return from in my software:  In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As … | |
If .SubItems(19) = "Y" Then chkTax.Value = 1 txtTaxRate.Text = .SubItems(16) Else chkTax.Value = 0 txtTaxRate.Text = "" End If having problem Compilation error : method or data member not found with this code chktax is a check box. | |
How do you go about pausing your code from operating. I want to make an animation by making a picture box visable then another then another but I need a period of time between transitions? How would I go about doing this? boredPic(1, 1).Visible = True boredPic(1, 1).Image = My.Resources.Red … | |
I would really like to be able to compare two cells in visual basic from a database access database in two different tables and the idea is to take one paragraph from one cell and a paragraph from another cell and compare how closely related they are. How would you … | |
what code can i use in my game when i'm upgrading or i will evolve or build ong picture to another picture ? please help me thanks ! | |
When I create data report use VB6 Enterprise, when I add Data Source to that form, I'm get error message "UNHANDLED EXCEPTION AT 0X89067542 IN VB6.EXE : 0XC0000005 : ACCESS VIOLATION READING LOCATION 0X89067542" and VB6.EXE close What happen ??? any body can help me, thanks for advanced Regards, FX … | |
Is there a way to open a form in vb6 when they clicked on one of the field in crystal report? Ex. If I want to update certain deposit, when clicking on crystal report, it will open the vb6 form to display for editing.. Ive found 1 in vb.net from … | |
I'm having trouble with this: Option Explicit Dim hold1, hold2 As String Public LoginSucceeded As Boolean Private Sub cmdCancel_Click() LoginSucceeded = False Me.Hide Welcome_Scrn.Show End Sub Private Sub cmdOK_Click() With Adodc1.Recordset hold1 = "[Username] like'" + txtUserName.Text + "'" hold2 = "[Password] like'" + txtPassword.Text + "'" If .EOF <> … | |
Hi, I am (still) converting an old asp web app / vb6 dll to aspx / vb.net I am now biting on a fairly simple function in vbscript: the execute() function What the vbscript does is the following: It reads in a variable name and its (string) value from a … | |
Its all in the title, i want to get 2 dates from user then view them in a data report text labels so we have idea what the report is displaying | |
hello. i'm only 15 year old and so i dont know much about vb6.0 . i m using a code for a search button that would display the fields in a database(ms access) in textboxes when i select a date from the combobox i used the code: Adodc1.Recordset.Filter = "infodate='" … | |
[coding virus using vb script .vbs](http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/294413/coding-virus-using-vb-script-.vbs) Granted it is pretty pathetic, but some fool is looking for help to run the code shown. | |
Hello, I suck at programming, so I'd like some help on createing a .vbs script to disable right mouse clicking on the entirely Is this even possible? Google searching yeilded me nothing usefull... javanoob101 | |
Hi experts, I have an update form, even without changes made in fields the form will still be updated. How can I code that the form will not update without changes made. Pls help me. Thanks alot. below is my code. Private Sub cmdUpdate_Click() If Trim(txtLastname.Text) = "" Or Trim(txtFirstname.Text) … | |
hello everyone, i have just finished developing my first program that includes a database. i have used instalsheild to make it a file so i can instal it on other PC's. but when i run the program on another computer i get an error, i cant remember what it said … | |
Hi all, Looking to extract all HTML tags from a dump of HTML data and put them all in a listbox. I currently have the following code. It displays to me things like HTML HEAD TITLE BODY. But i want things like the IMG and ALT tags. ' Obtain the … | |
I'm trying to create a form with multiple labels, textboxes and buttons within a panel. The user will fill in their data and click a button that will create a new identical panel with the same labels, textboxes and buttons. I read through the following thread in an effort to … | |
i am tyring to create new project nemmed as car parking system please help to get the password and check the name in database and display the already gathered displays ........please help me ...........<snip> | |
Hi, I'm doing a software analysis assignemnt which requires me to deal with visual basic. I've never used the language before. I have a loop which I would like to calucate the time taken to complete the loop. Any heads up guys? I want something very simple. | |
Good day to everyone. I am new to Visual basic and I am having a hard time at school because they dont teach all the codes in visual basic 6.0 and they want us to have self study and all. What a bummer. For our midterm exams, our professor wanted … | |
Hi Experts, good day! I have hard time coding the click event when I click cmdTime on the second time a message box will say, "Your first time in for 2/16/13 at 9:00:33 am, Are you sure you want to record this time in, Yes Cancel?" The time 1:22:33 is … | |
i am making an inquiry kiosk for a certain company and it required to be on a network, with sql server as backend database. is there any way that i can connect to the database which is on the server and fetch data? | |
-->>Hope all is well,I've Managed to write code to Open Folders/Browse Folders using Common Dialog... -->>The name of Common Dialog is Folder... -->>But now as I've the Open Button when the Browse Windows Show up,I was wondering how can I... -->>Open the Selected File when User Click the Open Button … | |
So I've FINALLY gotten my code to work but unfortunately my code's sooo messed up that its displaying something else! As you can see in the picture below, the Flex Grid is displaying the data of "Service" http://i213.photobucket.com/albums/cc228/rose_408/receiptform_zps1a66f838.png http://i213.photobucket.com/albums/cc228/rose_408/service_zps5e886a12.png When its actually supposed to show the data of "Receipt Service"! … | |
Hi Expert, my Option1.value is not save to databse while Option2.value is saving. Pls help me check my code. Thanks Private Sub cmdSave_Click() Set rs = New ADODB.Recordset rs.Open "select*from Employees", cn, adOpenKeyset, adLockOptimistic On Error GoTo err rs.AddNew rs!Employees_IdNo = txtSearch1.Text rs!Lastname = txtLastname1.Text rs!Firstname = txtFirstname1.Text rs!Middle_Initial = … | |
MY code doesnt saves the data entered through dropdown box into access database | |
I have the following code that hyperlinks the file to a cell in excel when you type in the file name. I need to alter this code and not sure how. I need for the code that when you type in file name it also finds the filename path and … | |
I have vb form tht accepts user data.I need to check whether user enters emailid in the correct format ?Please provide suggestion .Thanks in advance | |
-->>Now I have managed to go through some codes that creates a System Tray Icon... -->>I've managed to create it but something is wrong here that disturbs Me... -->>When I Click on the Tray Icon of My Software it wont Load My Application... -->>That is Say if it was Minimized … |
The End.