36 Solved Topics
Remove Filter  | Hello all I have a form with two datagridviews. Grid A is polulated with orders from DB, grib B has an empty table with the same column name as grid A. Im currently draging orders from Grid A onto grid B. My isue is that since grid B has only … |
| | Hello I have created awhile ago in VS2017 an application [application A] with CR sp21 which works fine. Now Ihave another application [application B] created in vs2019 with CR sp29. When I install app B on the same pc where App A is installed the CR wont work so I … |
| | Hi all I Have a CalendarvProject with a 3rd party Calendar control. the application was working fine untill I upgraded the Calendar Control . When I opened the solution two references were no longer availabe, so I had errors. One of the references was ExtremeCalenderControl the other AxXtremeCalendarControl. I was … |
| | Hello all. I have a funtion in MYSQL to substruct days from a date. This function seamsto work but some dates it times out. This is my function CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date DETERMINISTIC BEGIN declare calculated date; declare added int default 0; Lbl_Loop: Loop IF … |
| | Hi all I have a x32 bit application on a windows10 x64 machine. The application was working fine untill I change the connection string from OLEDB to ODBC with a DSN. Since my application x32 bit I created a x32 bit DSN to an ACCESS db wich also is a … |
| | Hi all I'm new using LinQ. Im having Specified Cast not Valid in this Function. Hope someone let me know what I'm doing wrong. this is the Function Private Function GroupedBy() As DataTable Dim Sales As New ds_Sales_OELI Dim dt As DataTable = Sales.Not_SCheduled GroupedBy = New DataTable Dim dr … |
| | Hi all I have a table with a Masked column. How can I INSERT or UPDATE data into the masked column at run Time with out Loading the column into a textbox. The column is as Folows ID Process 1 StartY CompleatY 2 Start_ Compleat_ Thanks in advance. |
| | Hi all I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 … |
| | Hi all I have a DataGridView with 2 Columns an Order column (text) and a price Column (decimal) The Datagrid contains all the orders and price for a certain customer. I'm currently adding all the prices and adding a new row to the datatable containing the total.In this row on … |
| | Hi all I Currently have a MDI Form that contains a DataGridView. When I open a dialog form as a MDi MdiChildren the dialog form partionly hides behing the Datagridview. (I also tried with a windows form same thing happens). Can any one help me solve this with out having … |
| | Hi all I have a Products table which has a description and a size column the description is a string value and the size has a double value. What I need to do is after reading the data it converts the decimals value of the size column into a fraction. … |
| | Hi all I have a Mdi Child Fom being oppened from the parent the form opens but the Load event will not fire UP. Doesn't the load event suppose to fire up every time the form is opened? Here isthe code usedto open the form from the Parent and also … |
| | |
| | Hi I'm trying to Select Data from an Access DB. I wrote this query to Select all Invoices that were Invoiced between two dates. I get the following error Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13' "SELECT * FROM invoiced_filter WHERE Invoiced > " & … |
| | Hi all I have an Access database Table and one of the columns has a date value the column name is closing. I would like to do an order by closing asc the null values are allways on top and I would like it to be at the bottom. I … |
| | Hi all I have the folowing to calculate the Number of weeks between two dates. The OpenDate= Nov-1-12 and closingDate= Nov-29-12. When Executing the the NumberOfWeeks=3 If I go to the calander 4 weeks why is the NumberOfWeeks=3 NumberOfWeeks = DateDiff(DateInterval.Weekday, OpenDate, ClosingDate) Thanks In Advance.  |
| | Hi all I'm trying to shade a cell based on a date difference between column 7 & 8. It seams to work accept column 8 seams to be the one being shaded instead of column 7. I have googled but can't find a solution to have the calculatin being made …  |
| | Hi all. I have a program in vb.net and with it I have an expiration Key. I would like this key to be valid for 3 moths for example. I don't want to use the users system.date because to prevent them from changing the date. I there a way I … |
| | hi I have successfuly created an access database with vb.net accept it is not password protected. Can someone help me to password protect this DB. Here is the code I use. Thank you [CODE] Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click Try Dim cat As New ADOX.Catalog … |
| | Hi all In the following Sub I'm sending an Attachment when the email has been sent I would like to delete the attachment but I get an system.IO.IOException Error. the file I'm trying to delete is being used by another process. How can I detect if the process has finished. … |
| | I have a reportviewer that prints a second empty page with the header only nothing in the body. I have searched for this issue and I learned that the Width of the report body should be equal to the page width minus the right and left Margins. So I have … |
| | I have two arraylists. The JobArraylist gets adresses from a database table and JobIDArray Gets the ID for those addresses. I'm populating a Combobox with the JobArrayList which is working ok. When I select a an address in the combobox I use the sectectindex to get the AdressID from JobIDArray. … |
| | Hi all With the following SQL " Dim Query As String = "UPDATE JobName_tbl SET [JobDate]=@NewDATE, JobAddress=@Newaddress Where JobID=@ID" nothing happens nothing gets updated nor do I get an error. But as soon as I remove the [JobDate]=@NewDATE, it works fine. Hope someone can help me with this situation. Here … |
| | Hi all I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name) This is the query that I have in the properties SELECT [Date], Address, Customer, Orders … |
| | HI ALL! Let me start by letting you know that I'm still new to VB. All I know about Programing is with the use of google, Videos, and some good help from DaniWeb. I'm doing a program which searches datagrid colums with some classes That I have wrote. I have … |
| | [QUOTE]Hi all I am using Vb2008 Express and an Access DB. I would like to Display a note from a column in the Notes_tbl to a text box this from an Access database. Here is the code that I used but it does not do the job. [/QUOTE] [ICODE] Dim … |
| | :?: Hi all I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object" Here is my code Thanks [CODE]Imports System Imports System.Data Imports System.Data.OleDb Public Class ExellFrm Private Sub …  |
| | [QUOTE]Hi all I have two forms which are being displayed from the MDI Parent form. In the following code I would like to send data from form 1 to form 2. [/QUOTE] [CODE] DsgnForm.InsertOE = txtOrderEntry.Text DsgnForm.InsertFN = txtFirstName.Text DsgnForm.InsertLN = txtLastName.Text DsgnForm.InsertAD = TxtAddress.Text [/CODE] [QUOTE] My problem is … |
| | [QUOTE]Hi I need help to center a label with a form. I have tried with the following code but was unsuccessful. [/QUOTE] [CODE]Me.Width = 135 Me.Height = 38 Dim w As Integer = Me.Width / 2 Dim h As Integer = Me.Height / 2 Dim lblw As Integer = Me.lblnumber.Width … |
| | HI I'm trying to use a menu on a datagridview, I have put a Contextmenutrip on the form. When I right click in a cell I would like a menu to pop up. but nothing happens. This is the code I have tried. [CODE] Private Sub CustomerPopMenu_ItemClicked(ByVal sender As Object, … |
| | Hi I have a Datagrid with column(1) showing the date. The dates are being Displayed as 01-13-2009 (mm-dd-yy). That's how it is saved in the DB. I wouls like it to be displayed in the Datagrid in the following format Jan-13-2009. Can anyone help? Thank you |
| | [QUOTE]HI These are the forms I Have Log in,Customer,Order. They are opened In this order. At start up the Log in Form assigns the User in The Order Form and all works fine. But when I close the Order Form I loose the user. I would like to maintain the … |
| | I have two Issue using a MDI app. 1-at this moment I'm able to open MDI child forms using the MDIparent except when the I opens form1 I'm also able to open forms 2 and 3 . but I only want one form to be open at a time. 2- … |
| | Hi I have a checklist box and I am trying to Check and Uncheck the the Items with a single click. My code seams to be checking and uncheking if the Item is not selected. If I Click on an Item that is checked it will uncheck it or vice … |
| | [QUOTE]Hi I have an INSERT INTO SQL that keeps on retuning an Syntax error in Insert Into. I cant seam to see where the error is, can anyone Help. This is my SQL.[/QUOTE] [ICODE]Dim DesignSQL As String = "INSERT INTO Design_tbl (CustmrID,[User],Builder,Model,Type) values ('" & _ CustID & "', '" … |
| | I been searching for days for a sulotion but can't seem to find one. The coed that I have does not give me an error but it does not save anything on the table either ' Can someone help me find what I'm missing? this is my coed [CODE] Dim … |
