20,899 Topics
 | |
 | I've been at this for a few days, not making any progress, so I'm asking for help. I have an application you log into based on an ID number (example 45) In the app, there is a label. By default is has "lblID" in it, when when you log in, …  |
| | Can I create 2 users and they have different function?? Database base using is MS Access. For example I have "staff" and "admin". Staff can insert,edit and delete data only. Admin can check the total sales of the day. Can I do that in VB.Net and can somebody give me … |
| | Hey people hope you are well Could You please help me. I am designing a system which when users login i want the system recoginse who is a admin and a user ( option of deleting only to admin) Using mysql and vb.net Thank you in advance  |
| | myqry = "UPDATE tblReceive SET " myqry = myqry + " ProductName = '" & txtProd.Text & "'," myqry = myqry + "' Quantity= " & txtQuan.Text & "'," myqry = myqry + " Quantity Unit= '" & ComboBox3.SelectedItem & "'," myqry = myqry + " Category = '" & … |
| | hi everyone.. can anyone help me please.. i have a datagridview with 4 columns (id, name, ticket_number, destination), i just want that datagridview on column "ticket_number" to display ticket_number from mysql database and another 3 columns for user input. thanks in advance.. |
| | Hi I am trying to pass the datatable of a search query to another page and bind it to a listbox. The problem is the the listbox just displays system.data.datarowview and no results. I have listed the code below. Thanks First page SQL and session store: [CODE]Protected Sub btnSearch_Click(sender As … |
| | This is my first time to do visual basic program Please help me about this problem... When I run the program with maximum attempt of 3 with correct username and password, Illegal user will pop up,,,i really dont know what to do..illegal user must be pop up when i already … |
| | How can I detect the click event of the close (X) button at the top right corner of the control box of a form/window? Please note, I don't want to know about CloseReason, FormClosing, FormClosed or stuffs like these, unless they are inevitable. I exactly want to detect if the … |
| | Hello, currently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already. The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column … |
| | I would like to retrieve the ID number for that row that was just inserted into the database. [CODE]Dim Enrollment As New Enrollments With Enrollment .Student_ID = CInt(lvwStudents.FocusedItem.Text) .Enrollment_Date = CDate(dtpDate.Text) End With EnrollmentBAL.Save(Enrollment) [/CODE] I have this code to save it from the database, what I want to do … |
| | My problem is after I created 5 rows of text boxes, I want to add random numbers to all of the text boxes in one time when I click the button. Does anybody know how to solve this problem?? Here are my coding to create text box dynamically: [CODE] Private … |
| | Hi. I'm using Visual Studio 2005 so I didn't know where to put this topic. This is my problem. I made a qucik search program so when I browse for a text file, it adds that text file to a listbox1. And then when you search result will be placed … |
| | How to get HARDWARE properties in VB Express 2010 like video card name and memory type? Hi, need some help with the above problem, i'm a noob with programming so any help will be ultra cool. |
| | Hi! this is my first thread here. Please help me. I have no clue how to start monitoring "another computer" in vb.net. I want to make a program just like a "cafe client" that monitors and manipulate another computer. Should i use Winsock? because I had red that winsock is … |
| | Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …  |
| | Hi all, first post here, please excuse the newbieness!! I am a complete and total beginner to web development in all forms other than mediocre HTML and CSS. Please be gentle and use small words!! :-) I have recently installed Microsoft's Visual Web Developer 2010 Express in order to have … |
| | [B]2. Write a statement or a set of statements to accomplish each of the following:[/B] a. Sum the odd integer between 1 and 99 using a while statement. Assume that variables sum and count have been declared as Integers. b. Sum the squares of the even integers between 1 and …  |
 | I have created a project for clinic in vb.net... So I have one exe file for it.... But I want VBnet installer and Crystalreport runtime installer to be packaged along with it... As to when the user will click the exe file the VB.Net installer shud first install then the …  |
| | How can I obtain the first row value. ex. Table ID NAME AGE 1 peter 14 2 Jogn 13 3 Luke 6 If i click peter I will get 1. I can get the clicked value but I do not know how to get the first item in the selected … |
| | I have a simple vb.net app and I'm trying to update a one row Access table with data from some textboxes. This is a learning exercise for me as I am coming back from not programming for almost 10 years, and know there are lots of other ways to manage … |
| | Hey guys! I need a little help with Crystal Reports!The Report keeps repeating the details.I tried to group it by the reference number but it keeps displaying it four times!Also how can I order the report by reference number?Please help me its the last thing for me to finish my … |
| | The problem is that it will show 2 the same result but with different employee fname. How to have something like this . "Employee.employee_id has employee.fname " It will show also lots of result if I will not use distinct. Select distinct TRANSACTION.TRANSACTION_ID ,CUSTOMER.FNAME ,CUSTOMER.LNAME,PET.PNAME,Employee.Emp_ID,Employee.fname,TRANSACTION.DATESTART,TRANSACTION.DATEEND from(TRANSACTION) INNER JOIN CUSTOMER ON … |
| | hi every one i just need some general ideas about a booking system. I have already done login and registration processes. And i am gna have customer registration and booking aswel which i can add,delete or update. its a vb.net application with sql server 2008. Can you give me any … |
 | I want to Have a Fix File path for my Flash Animation Flash Screen.. Is this possible ?coz VB doesnt allow you to upload a Flash File In resources... This is my path: AxShockwaveFlash1.Movie = "C:\Users\Nat\Desktop\Sudoku tactics(Pencil)\finished products\SPLASHscreen.swf" It's not fixed...If you switch PC it wont work anymore... |
| | Hello Friends, I am messed up with the below query [CODE] Try Dim myCommand As OleDbCommand myCommand = New OleDbCommand("select sum(tmt.total) as Total from Appointment appt, TreatmentMaster tmt where appt.patientid='" + txtPatIDBill.Text + "' and [tmt].[treatid]=[appt].[treatmentid] and (Format([appt.ApptDate], 'Short Date')) between '" + dtpFromBill.Value.Date + "' and '" + dtpToBill.Value.Date … |
| | Is it possible to reload a form of the running application from one computer when I executed a function from my other computer with the same application? co'z I want to see the changes of data on my datagrid view |
| | Hi, Can anyone help me in showing multiple items from listview to my crystal report. Or something like after searching some items, the results are the one to be displayed in crystal report. I don't have any codes yet. I'm using OLE DB Connection. Any help would be appreciated. Thank … |
| | by the way. this is now my problem. THIS IS FOR TIME IN... [CODE]Private Sub cmdIN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdIN.Click lblempno.Text = txtempno.Text lblIN.Text = lbltime.Text & lbldate.Text MsgBox("Log in successful!", vbInformation) lv = ListView1.Items.Add(lbltime.Text) txtempno.Text = "" txtempno.Focus() End Sub[/CODE] THIS IS FOR TIME … |
| | I've been putzing around with this for awhile but I need to delete column B (minus the header) when ever it is empty. Does anyone have any idea on how to do this. If xlWorkSheet.Range("B2:B65565").Value = "" Then Dim rg As Excel.Range = xlWorkSheet.Columns("B") rg.Select() rg.Delete() End If |
| | I have this vbs script that works great for adding a printer, what do i have to do to create this in vb 2010? I would just like to add a nice user interface, please help [CODE]PrnName = "Toshiba2830" PrnLocation = "Toshiba" PrnComment = "Toshiba2830 PCL6" PrnDrv = "TOSHIBA e-STUDIO … |
| | Hey guys! I have managed to fix a previous problem but now I have a new one!The "Details" fields keeps repeating itself for example its showing it 4 times instead of one!this is my code [CODE]Dim crptdoc As New CrystalReport1 Dim mystr As String Dim myDS As New DataSet1 crptdoc.Load("C:\Users\ACP\Documents\Visual … |
| | Hi, I'm writing a routine to import salesorders from an Excel sheet into Sage. The Sheet is broken down by product rather than by order so I want to use OLEDB to connect and run a query against it sorting by Order Number to get the items back per order. … |
| | hello to all. I have a problem. I want to alter a table to add three columns whenever i click a button.But i want the name of the table taken from a drop down list, and the name of the three columns are also taken from either a drop down … |
| | i've a problem with deleting record from datagrid. i have few columns in my datatable and all publish on to a grid and under "ID" column there are id nos and they are "NOT" unique. user able to search using this "ID" no. problem comes in deleting records since the … |
| | Hi, I have this fileupload control which saves excel file on my server, but somehow, if the excel file is larger than 4 mb it does not save the file, i used this code fileupload1.SaveAs can you please help me on why does this happen? Thanks |
| | Hello everyone. I have the following issue: I have a Windows XP computer with excel 2003 installed. we use several automation robots using excel. everything works fine, files area created and all that. but we have a problem. for some reason the document recovery pane of excel is getting filled … |
| | I want to set up an array and have 100+ items in the array anyone know how to split the line Dim row() As Integer = {1, 2, 3, 4, 5, 6} like this Dim row() As Integer = {1, 2, 3, 4, 5, 6}  |
| | hello everyone i just wanna ask some help regarding on how to delete all datas in the data grid view from search result. i have a form which search data in specific date and show result in the datagridview, what i want is that when delete button is clicked all … |
| | here's my code access webpage [CODE]WebBrowser1.Navigate("http://" + TextBox1.Text + ":8080/TopAccess/Administrator/Login/Login.htm")[/CODE] create folder [CODE]My.Computer.FileSystem.CreateDirectory("C:\" + TextBox2.Text) System.Threading.Thread.Sleep(2000)[/CODE] access general page [CODE]WebBrowser1.Navigate("http://" + TextBox1.Text + ":8080/TopAccess/Administrator/Setup/General/List.htm") While WebBrowser1.ReadyState <> WebBrowserReadyState.Complete Application.DoEvents() End While[/CODE] save page as*************this is not working [CODE] Dim myWebClient As New System.Net.WebClient myWebClient.DownloadFile("http://" + TextBox1.Text + ":8080/TopAccess/Administrator/Setup/General/List.htm", _ "C:\" … |
| | I have a website which has a section under maintenance with a button called create a new file - when you click on this button it does a backup and generate a filename on the same page called *.tbf - the filename changes each time you click on create a … |
 | this is my query for displaying monthly business [CODE]select convert(varchar,dateadd(month,datediff(month,0,inv_date),0),101) as 'months with date format', sum(inv_amount) as 'business' from invoices inner join customers on customers.cust_id =invoices.cust_id where fname+' '+lname='lala fazlani' group by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) order by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) [/CODE] So when I execute this command, It gives me this result [url]http://img821.imageshack.us/img821/6492/sqle.jpg[/url] [url]http://img341.imageshack.us/img341/538/chartv.jpg[/url] … |
| | Hi I've got a 2 col drop down list that gets its values from an SQL Server DB Table called List. The field that the drop down list uses is called SurName this would only display the surname for each record in ascending order. I have now extended the drop … |
| | Hey everyone, my issue is a little strange, I have a form that has checkboxes, and depending on the selection, a textbox might appear for further info. I want to loop through the controls that have been selected, if it's only a checkbox than just add the Value of the … |
| | So i am currently working on a project about enrollment system and I am having a problem with transferring items from one listview to another. I've been stuck on this problem for a while now. And I'm wonder if you guys and help me out. Here's a photo: [ATTACH]23978[/ATTACH] I … |
| | Hi, I am trying to split a single line of data into three separate parts so that they can be displayed in different textboxes. The data looks like this: item1_item2_item3 The code that I tried is: [CODE]Dim arrayLines() As String Dim record As String record = Subs.Text arrayLines = record.Split("_") … |
| | I know how to set the tab order on the forms on VB.net. but i want to set such that when i press enter while on the form, the cursor will go to the next textbox based on the tab order set. |
| | hi I have MS Access Data Base with tow tables table 1 has relashiship with Table 2 when I try edite tabe 1 error message shown tell me I can't edit table 1 do you have examble for this ? |
| | can anyone help me please.. i'm stuck with this thing for 2 days.. i have try to find answer from one forum to another, and it is give me heavy headache. what i want is that my panel size in my form has a function as print area, in my … |
| | The title says it all; I want to make a simple, not all-over-the-place HTML code. I'm asking for help since I'm still in middle school. I understand a lot of code, but if you give me a from college class explanation, it's not going to help until I get to … |
| | This is my first post. I am a novice in VB.NET. I am able to hide form1 from from2. But I am not able to close the form1 or exit the application from form2. Is there any way in which I can exit the application except from the startup form … |
The End.