16,916 Topics
 | |
 | Please help, i do not know whats causing the problem... Dim miqty As Double Dim mitc As Double Dim siqty As Double Dim sitc As Double Dim diffqty As Double Dim difftc As Double Dim dvqty As Double Dim dvtc As Double dvqty = dynavqty.Text dvtc = dynavtc.Text Set editSIrs … |
| | !! i was trying to create a simple grading system but my project doesnt work it always shows the last if statement and ignore the other statement...please help here's my code...can someone please tell me what's wrong coz i dont know how to use if/elseif/else statement... newbie here...please help Private …  |
| | hi everyone... my problem is i got 2 command button named command1 and command2..what i want to happen is when command2 is click the function of command1 will work... can someone please help me... |
 | hi, im using vb6 and i dont know how to work on a commandbutton that will trigger to another form. For example, i have a commandbutton in form1 and when i click it, there will be an effect in form2. Example, form1 1+1 and the answer will go to form2. …  |
 | Hello Guys .. I want to understant how to share my Database to the other Computer USing IP address.. Anyone can show me the code for connection.. This is my Code, acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\POS.mdb;Persist Security Info=False" acd.CursorLocation = adUseClient where can i put the ip in … |
| | I'm coding a contact manager using a doubly linked list that is manipulated by functions using pointers that reads in a contactList.txt file.But when I coded the first function to do a search I got the following error list: Error 8 error C2059: syntax error : ')' C:\Users\Brian\Documents\Visual Studio 2010\Projects\G00290342Manager.c\G00290342Manager.c\ContactManager.cpp … |
| | i would like to know hot to put a limited input in a textbox.. situation is like this i put a textbox in a form then what i would like to happen is to accept only 2 number and will not accept the following number that is being pressed...please help... … |
| | Hello Guys I Have A Question.. I have a Table for My Daily Reports.. But I dont know to Show the Daily, Weekly, Monthly and Annual Reports. What Should I do? |
 | hello guys, i have an sql statement that is supposed to be returning data from two tables that i have joined. Here is the code below: sql = "SELECT rooms.roomID, rooms.roomNumber, rooms.roomStatus, " & _ "roomType.roomType, roomType.adultRate, roomType.childrenRate, roomType.roomTypeID FROM rooms " & _ "JOIN roomType on rooms.roomType = roomType.roomTypeID" … |
 | Hi experts, I have listview table but when I click or double click the row the data could be changed or edited? How could I disable it but still able to select every row? Many thanks! Kimangel |
 | Here we go again. I've installed SQL Server 2008. I can't seem to find my database I've created (and there are two tables so far) that were created through Visual Studio 2010 Express (I'm coding in VB). If it helps, I've determined that the database is a ".Net Framework Data … |
| | Hello Guys, I hav a Code For My Report in Daily .I don't know why there is nothing show the records. even though the Error not Popup. This is My code guys. Help Me Guys Dim rsReport1 As New ADODB.Recordset rsReport1.Open "Select purchase_date, BarCode, Price, ProductName, Quantity, TotalPrice From Dailyrecord … |
 | Hi there everyone, my laptop began behaving strangely last week or so, and I've exhausted my limited knowledge of computers but to no avail. Im hoping someone on here my be able to provide some assistance, as I see you've managed to help a lot of other people. Right, I'll …  |
| | hi, I have two sql strings being executed at the same time one of which is an update statement and the other a save statement. The save statement works but the update statement does not. Here is the error i am receiving System.NullReferenceException: Object reference not set to an instance … |
| | A script I have that checks if an external HDD is connected, which has a prompt to mount the drive, with the option 'retry' and 'cancel'. If I click 'retry' it says it has found the drive, even though it's not connected, how can I fix this ?  |
| | Hi Everybody, Could somebody let me know the search code in a database (mdb database : with 1 table only) to write for a search command. I am using ADODC1 connection. Please also let me know for the above table if i want to add a new contact to the … |
| | Hi experts, I have a type mismatch error in getting time difference from database. Below are my codes. Private Sub cmdSearch_Click() Dim sTrID As String Dim Total As Integer Dim xhours As String Dim Intime As String Dim Outtime As String sTrID = txtSearch.Text Set rs = New ADODB.Recordset rs.Open …  |
| | Hi, I have a problem compiling the "pjproject.sln", and I have the following error appearing: "fatal error LNK1104: cannot open file 'dsound.lib'" Build log was saved at "file://c:\Users\SLF101\Desktop\PJ Project\pjproject-2.0.1\pjmedia\build\output\pjmedia_test-i386-Win32-vc8-Debug\BuildLog.htm". Could anyone help me solve that problem? It seems like it does not want to open the "dsound.lib" file everywhere. That …  |
| | Greetings As the titles says I wanna know what are versions of C++ other than Standard C++ and what are the differents between those version if any! Second question what is contained in the .exe file I'm using Microsoft compiler "Visual Studio 2010 IDE"? Is it contains the assembly instructions? …  |
| | Here's a simple wrapper for printing text. Built as a class library, this can be used in any .net application. This has automatic word wrapping. I figured that using the new constructor to accept different parameters would easily allow for printing different documents with different settings. I included Name, Font, … |
| | This code creates XML File Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As SqlConnection Dim adapter As SqlDataAdapter Dim ds As New DataSet Dim sql As String connetionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" connection = New … |
| | Group, I may have messed up bad. I need help. I was having trouble loading a database I had created with data. So I downloaded SQL Server 2008 Express that included the management tools. I tried to find and open the created database and never could find it using the … |
 | I'm trying to populate a dataset from an excel sheet but I keep getting a "could not find installable ISAM" error. (In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.) on the adapter.Fill line. Already tried changing …  |
 | Good morning DaniWeb community, I've been coding a while in Classic ASP with MS SQL, but now it's neccesary for me to take the plunge into ASP.NET, C# in particular. I have a lot of data in SQL, and I would like to know where to start, I know how … |
| | I am developing a VB6 application which connects with an Access 2010 database. I want the application to execute queries stored in the database. Some of the queries include Access functions in field names. For example- FieldName: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])" Is there a way in VB6 to execute the queries natively in … |
 | In a previous thread I was trying to get some code to work as a search function and after messing with it for a while I finally got it to work-sort of. What I have is a search function and when I run the code it does find the part … |
| | Hi everyone, please i am writing a program in C# for connecting to a microsoft access database using visual studio 2005 and ADO.NET. i want to be able to use Dataset to update,delete,insert and edit records in the database.please how do i go about this.I already have aform with a … |
| | **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** |
| | Group, Via Visual Studio 2010, I've created a SQL Server database with the appropriate fields, data types, etc. I'm now ready to begin some testing, however I need to put some information in those datafields. I'm having trouble doing this. I DID NOT set the tables to display in the … |
 | I am working an a simple project that required a vb.net login form. I added a login form that was preinstalled in visual studio, ex. Menu>Add existing item>login form. I am using visual studio desktop 2012 and I made the project for .NET 4.5. I then realized that my target … |
| | 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 |
| | Just wondering if anyone knows how to not save a document after creation when using Microsoft.Office.Interop.Word. Basically i am using mail merge to print off a report from c#, the document get made, values are passed to it no problem and i can then print it without any issues, however, … |
| | 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 … |
| | CODE: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") Dim adaptor As New SqlDataAdapter Dim dataset As New DataSet con.Open() con.Close() con.Open() cmd = New SqlCommand(str, con) cmd.Connection = con cmd.CommandText = "SELECT Firstname FROM … |
| | Dim conn As New OleDb.OleDbConnection Dim ds As New DataSet Dim dt As New OleDb.OleDbDataAdapter conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\admin\Documents\Visual Studio 2010\Projects\office software\office software\bin\Debug\Office1.accdb;Persist Security Info=False; " Try cmd.Connection = conn conn.Open() cmd.CommandText = "insert into Office Values('" & CInt(TBID.Text) & "','" & TBSupplierName.Text & "', " & TBProductName.Text & "," …  |
| | 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 … |
 | Hi every one, I need to use System.Windows.Documents & System.Web.UI.WebControls namespace in my visual studio Windows Form c# project, they do not found in my refrance. i serched for long time on internet no more satisfactory in results. can any one helpe me Best Regards, IT_Techno |
| | 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 … |
The End.