mikeybware

I currently have some code that gets the overall top 25 frame sales, which is as follows: `Dim FrameCountSelectStr As String = "SELECT TOP 25 Count(Glasses.OrderID) AS GlassesCount, Glasses.Manufacturer, Glasses.FrameName FROM(Glasses) WHERE FrameName <> '' AND OrderDate >= #" & SearchDateStart & "# AND OrderDate < #" & SearchDateEnd & …

Hi Guys, Kindy assist me to make this code work. I want the datagridview to populate data from SQL server 2012 database based on the employment number selected in the combobox. below is the code I have tried to generate. Private Sub btnRecords_Click(sender As Object, e As EventArgs) Handles btnRecords.Click …

DataGridViewCheckBoxColumn Checking Issue I added a DataGridViewCheckBoxColumn to My Data Grid Dim DesChkBox As New DataGridViewCheckBoxColumn DesChkBox.Name = "chbSelect" DesChkBox.HeaderText = "Select" DesChkBox.TrueValue = True DesChkBox.FalseValue = False grdView.Columns.Add(DesChkBox) DesChkBox.Width = 50 grdView.ReadOnly = False grdView.AutoGenerateColumns = False grdView.RowHeadersWidth = 5 And through a procedure I want to check the …

I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code: [CODE]Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Settings.accdb" NotifyCon.Open()[/CODE] Ultimately I am …

getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) …

I am trying to sum a field in my MS Access database that I long ago stored as a string. I was using dbCommand.CommandText = "SELECT SUM(SubTotal) FROM Glasses WHERE OrderDate >= #" & SearchDateStart & "# AND OrderDate <= #" & SearchDateEnd & "#" and this would work for …

please i need urgent help on how save a form as pdf in vb10, all the code and seeing are c# and i dont understand them. i meean, if i run a program i will press save on the form that i am an save it as pdf to my …

Can you help me to add Next and Previous Buttons to this code please: Imports System.Data.SqlClient Public Class Form1 Dim id As Integer = 0 Dim idindex = 0 Dim command As SqlCommand Dim adapter As SqlDataAdapter Dim builder As SqlCommandBuilder Dim ds As DataSet Dim table As DataTable Dim …

i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make …

I got some issues with Syntax error for my insert statement. I can read access database without any issues. I tried to put in all data as simple string but still not working. Executing in Access works fine though. Please help. cmd.CommandText = "INSERT INTO POSITION (positionID,stockSymbol,stockName,cashTransaction,lastUpdate,initialQuantity,initialValue,currentQuantity,currentValue,positionStatus) VALUES ('2','2','2','2','2','2','2','2','2','2')" cmd.ExecuteNonQuery()

I am trying to insert some values into a database and I have the following SQL: insertString = "INSERT INTO SocialHistory (ExamID, Occupation, SafetyYN, ComputerYN, ComputerHrs) Values('" & CurrentExamID.ToString & "', (SELECT Occupation, SafetyYN, ComputerYN, ComputerHrs FROM SocialHistory WHERE ExamID = '" & LastExamID & "'))" When I execute the …

I have a calendar/scheduler that I am coding and I want people to be able to search for the next available date via a few options. One of those options is to only search those dates that are "Monday" for example. I have the following SQL command to retrieve data …

I have a database of customers (MS Access database) and I am trying to check out the demographics. I would like to list the top 5 cities and their count (how many times this city is found in my database), as well as the top 5 postal codes and their …

I have the following code which prints my datagrid nicely. The problem is that it only prints the first page and cuts off everything thereafter. I know I need to implement the e.HasMorePages = True in some manner but I am unable to get that working. Here is my code: …

Hi can someone please help me how to update after inserting ? In this code I am going to insert a transaction that borrow books in library system BUT In every borrow of books I need to lessen the quantity of the book.. I have an error in this code.. …

I want enter the telephone no into text box like this 022-1234567 how to set the textbox commands to get like this...........

Hello everyone, i am developing a Library system, where user can borrow books and return them. i have a table in my DB called "borrowed books" it contains list of information about the borrowed book and the borrower, when the user returns the book the system should remove the record …

i have a data gridview with 4 columns namely name age address and attendance. my problem is this ,using a button how i change the attendance in all to "OUT"? help me please

need some help guys im trying to put a hyphen between a number for the telephone number but i want to use the keypress or textchanged i already done it using the button so im trying to use the textbox rightnow but after the hyphen is been inserted to a …

Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = …

Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data. I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be …

I have a string of text being sent through a serial port to a text box (Text1.Text). The string has some symbols in in which I am assuming are Hex values. The hex values are Hex(1), Hex(4), Hex(12), and Hex(17). What I need to do is find the position of …

I have a form that has a tabcontrol (TabControl1) and within that tab control is another one (TabControl2). I have textboxes on the main form as well as in each of the tabcontrols. In my savebutton event I have the following code: If CheckIfDirtyAfterLock = "Just Unlocked" Then CheckIfDirty(Me.Controls) Else …

I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I …

I believe I may have already posted a much longer explanation of this , but its driving me spare!!! I have several pieces of code that click buttons thru sendmessage commands, all the code works fine in Windows 7! But I put the app on WindowsXP and only some of …

I just attempted to insert a .jpg image into an access 2010 database but now I want to retrieve it and now I have an error that says "parameter is not valid" [CODE] Con.Open() Using com As New OleDbCommand("Select Picture from MyImages where ID =1", Con) Dim imageobj = com.ExecuteScalar …

I have the following code that I am hoping to get working. The code will check for available DYMO printers and print the label. You are to create a template label and I saved mine as template.label. In that template label I have a text field referenced as TEXT1. The …

Dear All, I am developing a application where I have 1 parent from (windowstate of Parent from is set to Maximized) and 2 child forms. In my Parent form I have a menustrip with following code to activate child - [code] Public Class FormParent Public NewMDIChildForm1 As New Form1() Public …

I have the following code which creates a nice little instant messenger for my program. I am running into trouble when I try to send a message to a user that is not logged into their chat window. It waits about 20 seconds, then throws the error message. In the …

I have an Invoice.accdb database (in MS Access) that I am pulling into a MicrosoftReportViewer. I am having trouble subcategorizing the data, and was wondering if anyone could offer a little insight please. I would like to display the data as follows: Invoice Date [INDENT]ID Patient Name Pt ID Status …