20,278 Topics
 | |
| | `Inline Code Example Here` con.Open() cmd.Connection = con cmd.CommandText = "SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By MONTH(SalesDate), Detail.ProductID" Dim da As New SqlDataAdapter("SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By …  |
 | Hi I am using vb.net with access database I am using sql How can i update database with the value 40'6"(Feet and inches values)  |
| | Right guys, I'm really new to this but I'm getting along ok, but I've hit a block. I need to be able to know how to search a text file in VB for a particular line and then display it. the files I'm trying to use are set up as: … |
| | I am not sure if this is possible, in VB is it possible to link to some piece of code in the current document?  |
| | Hello programmers!. i have here a form2 i want to view the data's by using a vscroll bars. but when i drag the tool vscrollbars. it cannot go up and down. can anyone help me. :( |
| | hey i m trying to access ip and mac of my pc in vb.net any help |
| | hye....i have a data in access 2007 which is: table1 ID DOCUMENTNAME PAGE 1 investment 2000 12 2 investment 1989 4 3 investment march 15 how to display the id and page when user typing the document name in combobox..using vb.net 2008 |
| | dear friends following is the code for export data from data grid to excel .. problem which i m facing that .. i could not export the last coloum values.. kindly give sulotion.. `Inline Code Example Here` Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim … |
 | Will you please add a button to quickly copy code inside code tags to clipboard? I find it really annoying and inconvenient to use the mouse to highlight all the code inside code tags, it was a lot easier in the vBulletin version.  |
| | I don't now how to validate date time picker controls....someone know? |
| | dear friends i want to filter data by date ... see the attach pictures, after using where clause i receicve 0 rows :( |
| | How to insert more than one rows of data to Access?? All my textboxes are created during runtime and I want to add the text in textboxes to database. some times i want 3 rows and some times maybe 10 rows This is the code to create textboxes. [CODE] For … |
| | The company needs a system to calculate the charges for each load that they deliver. The loads consist of up to 10 different types of goods. Each item has an associated delivery charge. The system will allow the user to select up to 10 lines of goods and a quantity …  |
| | Hi All, I need to show a map, plotting addresses that are held on a sql database. Has any one come across any software suitable for this task (i.e. can be built into vb.net). I have tried using MS MapPoint, which according to the write up says it will do … |
| | Hello friends. that's gr88 that you people help out alot. My senerio is .. i made data grid form ..where i want ... when i double click on a Invoice no ... or Row in datagrid .. invoice open in new form where i can edit delete, or other opraitons … |
| | Hi i was just wondering how i would do this task. It seems fairly simple but i dont no how to to do it. In my system i have a table where i have a total figure of the stock. what i am trying to do is when my saler …  |
 | Hello Friends, I want to calculate the instance of * in the text file.... but I am not able to do it.... can anyone tell me which file funtion to use for it... I first tried to read the file --- its just one line file then see if the …  |
| | HI everyone! Please help! HOw to make a loop wait until a button is click...?? |
| | hello vb elites please i need help!! i want to use the values inside my datagridview colume. what i want to do is this, i have a date column, and i time column. so i want to check if the date is today and if the time is now, then … |
| | hi i am having problem in deleting a single row from a gridview. i am using binding navigaator to delete the row. i have customer table and booking table. Cust_id is used as foreign key in booking table. when i try to delete a single row from booking table it …  |
| | Hi everyone! i try to make a regualr expression format to validate phone number at this format: (555) 555-5555 [CODE] Dim IsPhoneValid As New System.Text.RegularExpressions.Regex("^/([0-9]{3}/)*[0-9]{3}*[0-9]{4}$")[/CODE] but it doesn't not work....somebody helps me out..  |
| | Hi all, I'm trying to build a sales program in which by adding multiple items in a RichTextBox, with the click of a button, the program can sum the price of these items and put it in a TextBox as the total sum of these values. I've been going nuts … |
| | Ok i am going to try to explain this as good as possible. I got a form, which i plan to use as a calendar/agenda. I got labels for each week day, these will change each day. Below each label(day), i got textboxes which are used to enter appointments in(these … |
| | hi. i am developing a simple vb.net application. i have three forms in my app. the first form has 2 radio buttons from which i need to select one. based on the selection made in my next form a combobox ll be populated.so far so good.there is a back button … |
| | Hi everyone! How to disable a textbox and combo box by coding not by changing their properties? |
 | Heres what i want to do. I want to check the two fields in my table | I use Ms Access the fields are EmployeeID | StartingDayWork Sql = "Select * from Employees where EmployeeId = '" & txtID.text & "'" 'This is running but whenever i add StartingDayWork it … |
| | I am trying to save my scale configurations in the database so first I have to check if it exists in the database.and I am using the code below to do that . however when there is no data in the database I will get an error "No row at … |
| | Hi every one i am having some problem in deleting customer Record. I have also uploading the screen shot of my form. i have customer records in textboxes and booking records in datagridview . i have solved the problem to delete the records in gridview but i want a button … |
| | ok what i am trying to do is i have two textboxs which have figues in them and need the 3rd textbox to display the figure the code i am using doesnt seem to be doing anything could anyone spot it and tell me why it is not working for … |
| | hello i was trying 2create crystal reports but they dont work for some silly reason is there any other way reports can be created?? any ideas linking vb.net 2 access 2run reports |
The End.