Search:

Type: Posts; User: Alfarata

Page 1 of 8 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    681

    Re: hELP WITH LOADGRID QUERY

    As you may have noticed I am having problems with this database query. I have little or no training in VB.net or SQL. But, I am trying to figure this out. Let me explain what I’m try to do.
    I have a...
  2. Replies
    5
    Views
    681

    hELP WITH LOADGRID QUERY

    SQL.ExecQuery("SELECT VendorName, MachineNumber,Date, Description, Quantity, Price, Quantity * Price AS TOTAL " &
    "FROM Parts " &
    "WHERE...
  3. Replies
    5
    Views
    681

    VS 2019 Re: hELP WITH LOADGRID QUERY

    I had written this 6 months ago. with some help. I stepped away for a while due to health problems. I was aske to do some additional work making a grid to show monies spent on a piece of equipment....
  4. Replies
    5
    Views
    681

    VS 2019 hELP WITH LOADGRID QUERY

    I HAVE A SYNTAX PROBLEM THAT IS KICKING MY BUTT. I'M SURE THE ANSWER WILL EMBARASS ME BUT HER IT IS.


    '****EXECUTE QUERY AND POPULATE GRID*****

    SQL.ExecQuery("SELECT VendorName,...
  5. VS 2017 Win32 Exception Can not find file specified with openfiledialog is canceled

    I am using the openfiledialog to pick a file which I then use the

    OpenFileDialog1.ShowDialog()


    FilePathtxt.Text = OpenFileDialog1.FileName

    ...
  6. Replies
    3
    Views
    1,276

    VS 2017 Re: Load a word file from a Form

    Thanks

    I like the last item best
  7. Replies
    3
    Views
    1,276

    VS 2017 [RESOLVED] Load a word file from a Form

    Imports System.IO
    Public Class testform
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    FilePathtxt.Text = Nothing


    ...
  8. Replies
    2
    Views
    1,102

    Re: Parametr query fails

    thank you
  9. Replies
    2
    Views
    1,102

    [RESOLVED] Parametr query fails

    Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click

    Dim MyDays As Integer

    Integer.TryParse(txtDays.Text, MyDays)

    'EXECUTE QUERY AND...
  10. Replies
    4
    Views
    1,751

    Re: Query fails with text box

    This appears to work.

    Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click

    SQL.ExecQuery("SELECT PartusedID, VendorName, MachineNumber,...
  11. Replies
    4
    Views
    1,751

    [RESOLVED] Query fails with text box

    I can run this query using this form no problem

    Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click

    SQL.ExecQuery("SELECT PartusedID,...
  12. Re: All pages with reportviewer controls have failed

    I have uninstalled the report viewer and reinstalled it with no errors. All my error remained every page showed errors. The error said I had to fix the problem from the design view and not to change...
  13. All pages with reportviewer controls have failed

    Every page I have the references a reportviewer control shows this error

    The designer cannot process the code at line 28: Me.HiTechDataSet8PrintWO = New HiTech3.HiTechDataSet8PrintWO() The code...
  14. Replies
    4
    Views
    576

    help finding last Item saved n MS SQL DB

    I need to find the autofill # named WorkOrderID in table Workorders


    SQL.ExecQuery(" SELECT * " &
    "FROM WorkOrders " &
    " ORDER BY WorkOrderID " &
    ...
  15. Re: Pages always show all records not just the one queried

    thanks for your time and help. This might not be kosher but it is working and a 2:00 AM that's cool. Here is my code change i'm sure tomorrow I can clean it up some.

    Try
    ...
  16. Re: Pages always show all records not just the one queried

    I have the second query that uses the Parameter Mine is named WOID, that data has had the information passed from a text box. That part is working. when I run the query from the query builder it...
  17. Re: Pages always show all records not just the one queried

    I guess I slow but do not seem to be able to figure out how to do a query without asking for the particular item I want to query on. Its not a known item until you decide to ask for it. If I have a...
  18. Re: Pages always show all records not just the one queried

    I guess I slow but do not seem to be able to figure out how to do a query without asking for the particular item I want to query on. Its not a known item until you decide to ask for it. If I have a...
  19. [RESOLVED] Pages always show all records not just the one queried

    I am trying to print out a report based on the data entered in a text box as the parameter for the ALLWorkOrdersTableAdapter. it has listed one normal Fill,GetData() all items, and one...
  20. VS 2017 Re: Unable to print any report except the first itemin the DB

    I GET THIS ERROR


    'Private Shared Function NEWMethod()
    ' Dim WOID As New ReportParameter
    ' Return WOID
    'End Function

    Private Sub cmdPrint_Click(sender As Object, e...
  21. VS 2017 Re: Unable to print any report except the first itemin the DB

    Yes one record is what should be printed. I enter a 12 in the txtbox on the PrintWO page with the .ReportViewer1 on it The txtBoxWO gets the Input The cmdPrint buttons collects it and the code Runs....
  22. VS 2017 [RESOLVED] Unable to print any report except the first itemin the DB

    Been fighting this for a week. I have deleted all and restarted. I have a Query that works correctly in my table adapter as a FillBY, GetDataBY(WOID). It runs and works in query builder.
    But when I...
  23. Re: Syntax error with Table Adapter

    HEE IS THE CODEIN XML STARTING LINE 97 THRU 126
    Deserialization failed: The element 'Report' in namespace
    'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' has invalid...
  24. Re: Syntax error with Table Adapter

    sO I HAVE BEEN FIGHTING THIS FOR 5 DAYS. I HAVE FOUND MORE ISSUES THAN I CARE TO THINK ABOUT. BUT APPARTENTLY VISUAL STUDIO HAS AN ISSUE WITH REPORTS AND A FILLBY ADAPTER. FIRST MY LIST OF DATA...
  25. Re: Syntax error with Table Adapter

    oK I MADE THIS CHANGE AND NOW HAVE THIS ERROR

    System.InvalidCastException
    HResult=0x80004002
    Message=Conversion from string "WOID" to type 'Integer' is not valid.
    ...
  26. Re: Syntax error with Table Adapter

    Sorry here is the error description:


    Severity Code Description Project File Line Suppression State
    Error BC30455 Argument not specified for parameter 'WOID' of 'Public Overridable Overloads...
  27. [RESOLVED] Syntax error with Table Adapter

    I have been working on doing some reports with a Parameter entered prior to printing I seem to be narrowing the problem But I now have another one that I need help with,
    Imports...
  28. VS 2017 Re: Help with parameter for dlc report

    I have been looking and reading and have made some additional changes.

    Private Sub txtPrint_Click(sender As Object, e As EventArgs) Handles txtPrint.Click
    Dim WOID As New ReportParameter...
  29. VS 2017 Re: Help with parameter for dlc report

    SORRY
    THE 'WO' parameter is missing a value
  30. VS 2017 [RESOLVED] Help with parameter for dlc report

    I AM TRYING TO PASS A USER INPUTED VARABLE INTO A PARAMETER FOR THE REPORT BUT NO MATTER HOW I LOOK AT THIS AND THE DIFFERENT WAY I HAVE SEEN IT DONE ON THE WEB I CAN NOT GET IT TO WORK. MOST...
  31. VS 2017 i AM USING A MDI PARENT AND CHILDREN PAGES

    HOW CAN I HAVE THE CHILD FORMS ALWAYS OPEN IN THE MAXIMUM SIZE. TO FILL THE MDI PARENT? THE WINDOW STATE I AM USING DOES NOT ALWAYS WORK MOST TIMES IT DOES NOT.

    THANKS



    Private Sub...
  32. Replies
    4
    Views
    467

    VS 2017 Re: Find data grid view row

    Thanks
    I will do so.
    But this appears to work


    Private Sub DGVIEW5_MouseClick(sender As Object, e As MouseEventArgs) Handles DGVIEW5.MouseClick
    TextBox1.Text =...
  33. Replies
    4
    Views
    467

    VS 2017 Re: Find data grid view row

    Thanks
    I will do so.
    But this appears to work


    Private Sub DGVIEW5_MouseClick(sender As Object, e As MouseEventArgs) Handles DGVIEW5.MouseClick
    TextBox1.Text =...
  34. Replies
    4
    Views
    467

    VS 2017 [RESOLVED] Find data grid view row

    I need to figure out how to find the row number of a Data Grid View when I click on a row.
    I'm thinking I need to use Mouse Click event but how to I ask for the row selected.

    Thanks
  35. Replies
    5
    Views
    1,937

    Re: SQL syntax problem

    I see it now thanks
  36. Replies
    5
    Views
    1,937

    Re: SQL syntax problem

    I am only guessing here but are you saying I should look at the msgboxes with any exception text? If so then I'm lost because I have seen nothing about a problem. I just see and empty data view grid...
  37. Replies
    5
    Views
    1,937

    [RESOLVED] SQL syntax problem

    This is my query in MSSQL 2017 works fine in the database

    SELECT WorkOrderID, MachineNumber, WorkorderDate, Priority, Problem, Description, EmployeeName
    FROM dbo.WorkOrders...
  38. Replies
    2
    Views
    553

    Re: Conversion Failed Error

    Thanks
    I never gave that a thought.
    Thanks
    Bill
  39. Replies
    2
    Views
    553

    [RESOLVED] Conversion Failed Error

    When trying to save my data I am getting this error. "Conversion Failed when converting date and/or time from character string.
    I collect my date time from a Date Picker Box. this variable is to be...
  40. [RESOLVED] Help translating SQL CE to SQL server in VB.net

    In the code below near the bottom is marked the line I need to translate. I want to be able to update this Datagridview
    This code I have found and have be using from youTube. It is working fine in...
Results 1 to 40 of 320
Page 1 of 8 1 2 3 4



Click Here to Expand Forum to Full Width