Search results for query: *

Hi, I have made a project in windows form in visual studio community editon 15. My all form was designed in 1024 x 768 resolution. When I run setup on another pc or laptop the screen resolution does not matches. If my clients using different resolution like 1600 x 1200 or 1600 x 900 or any...

Hello, I have added 6th column to my access database table named as TblInvoice. I am retrieving data from this column in text box named as TxtRefNo My code is Public Sub InvInfo() con.Close() con.Open() str = "Select * from TblInvoice where InvoiceID=@id" cmd =...

Hellow, I have code for DataGridView1_CellContentDoubleClick to edit row from another form as Private Sub DataGridView1_CellContentDoubleClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellContentDoubleClick Dim cells = DataGridView1.Rows(e.RowIndex).Cells...

I have a form named FrmInvoice. It has a datagridview witch populate data from following code on form load event. Try Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Access\Sale.accdb") 'Dim cmd As OleDbCommand = New...

Hi, I have a windows form named as FrmInvoiceEdit. In this form saved Invoice is displayed in datagridview1 by searching Invoice no. in text box which is named as TxtInvoiceNo. The code is Dim cmd As New OleDbCommand("SELECT * from TblTest WHERE InvoiceID = @InvoiceID", con) With...

Hello, I am using SAP crystal report version 13.0.4 I have a invoice designed in this report. Now I want to Print the same Invoice with Original Copy, Duplicate Copy on each new page's Top Right side. I have tried Parameter Field. In Value Section I typed Original Copy, next line Duplicate Copy...

Hello, I have a project in which Invoice is generated and saved in MS Access database. When User search the Invoice by Date wise and Customer wise with Form - FrmSalesReport, the data is displayed from TblInvoiceQuery in datagridview. When user click desire customer, another Form named...

Hello, I have a windows form in which it has a datagridview which shows data from Access database table named TblTest by entering Invoice number in Text box named as TxtInvoiceNo. The code for this is - Dim cmd As New OleDbCommand("SELECT * from TblTest WHERE InvoiceID = @InvoiceID", con)...

Hello, I have a unbound datagridview which depend on Query from Access database like following - Column1 Column2 Column3 Column4 Column5 Date InvoiceID CustomerName Cash / Credit Amount...

Hello, I am making a small project on Invoice. I have a datagridview for Adding, Editing and Deleting products. For Adding there is a Button. For Editing and Deleting products I have made a ContextMenuStrip1. The ContextMenuStrip1 is operated when someone select the cell of datagridview and...

Hello, I have a table named TblInvoice which have following columns. InvoiceID(Primary key), DateofSale, CustomerID, SaleType, TypeofSale. For transferring data to this table the code is con.Close() Try con.Open() If MsgBox("Save Data to database ?", vbYesNo +...

Hello, I am using Vb.net. I have a datagridview1 in winform for adding product, quantity, rate, amount, etc. I have other textboxes for Customer Name and Address. The data is saved with a button - SAVE. I have a code to check if any textbox is empty as - If TxtCustomerName.Text = "" Or...

Hi, I am using vb.net and Access database. In Access database there is a table named TblInvoiceQuery. It has DateofSale, InvoiceID, CustomerName, TypeofSale, SumOfTotal columns. The DateofSale is set to general date format. I have four datepickers named as - Datefrom, TimeFrom and DateTo...

Hello, I have a form from which I transfer data to access table. The form has date, Invoice Id, Customer name and one combo box named as CmbTypeofSale which has two options 1. Cash 2. Credit The access data table has date, Invoice Id, Customer name, Cash and Credit columns. I want if Cash option...

Hello, I am using vb.net and access database. I have FrmInvoice which has a unbound datagridview1. It has columns like ProductID, Product Name, Qty, Rate, Amount. I have a second form named as FrmAddItems for transferring values to FrmInvoice's datagridview through Textboxes ie. TxtProductID...

hi, I am using Vb.net and Access database. I want a code to avoid duplicate records. In Access Database I have a table named as TblBrand. It has BrandID as Primary key & BrandName as column for recording brand name. I made some entries in BrandName column in Access Database. While saving new...

Hi, I am new to vb.net . I am developing a Invoice for small business in vb.net using Visual Studio 2015 Community Edition. I liked a design which I am attaching which has a vertical main menu with side menu panel. Also attaching my Project. Can I make This type of menu ? Someone Can help me ...