Search:

Type: Posts; User: AngelSpeaks

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    1,242

    Re: Query Obtain Value from Previous

    I know, I'm talking to myself. I tried to query using MIN instead of MAX and IT WORKED!
  2. Replies
    3
    Views
    1,242

    Re: Query Obtain Value from Previous

    Well I tried something new and it's getting better but it still has issues. The Counties that have three rows is not correct the on lowest date. The Counties that have two rows are correct. Here...
  3. Replies
    3
    Views
    1,242

    Query Obtain Value from Previous

    Hi Guys,

    I have a table called tblPWTable. It has rates for County, and Effective Date. The rate I want is from a table called tblPWBenefits. It has County and Date Worked and Check Date. ...
  4. Re: Access 2013 Automate Queries Output To Separate CSV Files

    OK, I figured it out. Here is my code in case anyone is interested.


    Private Sub cmdSplit_Click()
    TempVars.RemoveAll

    Dim rsJobs As DAO.Recordset 'Output dataset...
  5. Re: Access 2013 Automate Queries Output To Separate CSV Files

    Thanks for your suggestion.
  6. [RESOLVED] Access 2013 Automate Queries Output To Separate CSV Files

    I am currently using Access 2013. My database has several tables relating to payroll data. Some of the tables are:

    tblEmployees
    tblJobs - Describes jobs that an employee is assigned to...
  7. VS 2019 Re: VB.NET Excel Worksheets - Loop thru all worksheets in folder

    OK, here is my code incase anyone wants to use it. I am bringing in all Excel spreadsheets in a selected folder into a datagrid, manipulating the data, and adding it to a table.

    First code...
  8. VS 2019 Re: VB.NET Excel Worksheets - Loop thru all worksheets in folder

    Thanks for the suggestion Chris, but I have to do edits before I bring the spreadsheet into a table. I will save your idea for later.
  9. VS 2019 Re: VB.NET Excel Worksheets - Loop thru all worksheets in folder

    Thanks. I appreciate your help.
  10. VS 2019 Re: VB.NET Excel Worksheets - Loop thru all worksheets in folder

    Thanks for the suggestion. Why? Good question. When I googled for suggestions on importing Excel spreadsheets, I found that code and copied in verbatim. I will use the code you suggested.
  11. VS 2019 [RESOLVED] VB.NET Excel Worksheets - Loop thru all worksheets in folder

    Currently, my VB.NET 2019 application has a form to select a workbook, then the sheet, and then load the worksheet to a datagrid and then add to a database table (Access). This works great for a...
  12. Replies
    4
    Views
    3,599

    Re: ReportViewer and Form Binding Source

    Thanks for your help!
  13. Replies
    4
    Views
    3,599

    Re: ReportViewer and Form Binding Source

    Reportviewer form code:


    Public Class FrmReport
    Public Property strReport As String
    Public Property strType As String
    Private Sub frmReport_Load(sender As System.Object, e As...
  14. Replies
    4
    Views
    3,599

    Re: ReportViewer and Form Binding Source

    Datagridview form code.


    Public Class FrmJobGrid
    Inherits Form
    Private WithEvents dgvJobs As New DataGridView()
    Private bindingSource1 As New BindingSource()
    Private...
  15. Replies
    4
    Views
    3,599

    ReportViewer and Form Binding Source

    I hope I'm explaining this correctly. I'm using VB2019, ReportViewer, and Access Database.

    I have a form with a datagridview that is bound via code to a table, let's say tblJobs in my database,...
  16. Re: VB.NET 2019 Trying to Install Report Viewer

    I'm marking this resolved! Now it's time to create a report!

    The issue that John mentioned in the other thread about the invalid cast, happened and his fix worked.

    Thanks. I need lotsa...
  17. Re: VB.NET 2019 Trying to Install Report Viewer

    Oops, found the version link and selected the older version.
  18. Re: VB.NET 2019 Trying to Install Report Viewer

    The only issue I have remaining is that the older version of microsoft.reportingservices.reportviewercontrol.winforms.150.900.148 is not showing up on the list. From what I can see, I can directly...
  19. Re: VB.NET 2019 Trying to Install Report Viewer

    Here is a very happy update! All of the examples I saw on the internet showed nugent.org as the Package Source. So, I brought up my rarely used Visual Studio 2013 and found two other sources listed...
  20. Re: VB.NET 2019 Trying to Install Report Viewer

    ahmish, that was my first attempt in post # 1, it wasn't there. Then I changed to Package Source source folder to c:\Downloads\ and it pops up, but it's the one that I manually downloaded in post #...
  21. Re: VB.NET 2019 Trying to Install Report Viewer

    Just a hunch. I've never used SQL Server. I just checked and I have Microsoft SQL Server 2008 installed. Could this be the reason?
  22. Re: VB.NET 2019 Trying to Install Report Viewer

    Update. Uninstalled Microsoft.Reporting.Services and RDLC Report Designer. Installed all updates to VS2019. Rebooted. Reinstalled Reporting Services (separately), then RDLC.

    Using this link,...
  23. Re: VB.NET 2019 Trying to Install Report Viewer

    No luck. When I go into Manage NuGet Packages, the Microsoft.Reporting services doesn't display
  24. Re: VB.NET 2019 Trying to Install Report Viewer

    Thanks. I'll give it a try.
  25. Re: VB.NET 2019 Trying to Install Report Viewer

    Thanks for responding. I do have it installed and confirmed it. When I try to add it to the project, it's not finding the Microsoft Reporting Services extension.
  26. Re: VB.NET 2019 Trying to Install Report Viewer

    Additional Info. At Tools-Nuget-Package Manager-Package Manager Console, I entered:
    Install-Package Microsoft.ReportingServices.ReportViewerControl.Winforms -Version 150.1358.0 which I received...
  27. [RESOLVED] VB.NET 2019 Trying to Install Report Viewer

    I've reviewed the other discussion here with no luck.

    I have an existing VB Windows Form app. I've confirmed that I have Microsoft Reporting Services Project and Microsoft RDLC Report Designer. ...
  28. Re: VB.Net 2019 SQL to Load DGV

    Thank you Karen. I thought that would be the best option. I did add Access to my Google search and it still gave me that Collate.
  29. [RESOLVED] VB.Net 2019 SQL to Load DGV

    Hi All,

    I'm using the following SQL code:

    SELECT DISTINCT tblMasterPWRates.Region FROM tblMasterPWRates;

    to load a datagridview combobox. The results when I try this in Access returns the...
  30. Re: MSAccess 2013 Database Design Questions and Query Issue

    I changed to IIF and the SQL is

    SELECT tblHoursInput.Date, tblHoursInput.Employee, tblHoursInput.Job, tblHoursInput.[Job Name], tblHoursInput.Hours, tblHoursInput.Travel, tblHoursInput.[O/T],...
  31. MSAccess 2013 Database Design Questions and Query Issue

    I'm designing an Access Database using a rate table that is provided by a government entity. The columns in the Rate Table:

    Effective Date
    County
    TradeTitle
    Region (represents part of the...
  32. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    :) I FIXED IT! I finally got it to work!

    Successful code is:

    If dgvHoursInput.Item(7, i).Value Is DBNull.Value OrElse String.IsNullOrWhiteSpace(CStr(dgvHoursInput.Item(7, i).Value)) Then
    ...
  33. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Thanks. Good to know.
  34. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Here's an update:


    If dgvHoursInput.Item(8, i).Value Is DBNull.Value OrElse CStr(dgvHoursInput.Item(8, i).Value) = String.Empty Then
    dgvHoursInput.Item(8, i).Value = 0
    ...
  35. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Thank you for responding John. I was following the procedure to import Excel spreadsheets into Access from this It was at the top of my Google. I will look for the reverse.

    Same thing with my...
  36. [RESOLVED] VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Hi Folks,

    I'm currently trying to import an Excel spreadsheet into a DataGridView. That part works great. Then I'm checking each column to make sure that if the column is null that it's set to...
  37. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks John, that's probably a better idea.
  38. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks for responding si_the_geek. Question? Does the INSERT INTO table2 (Field1, field2).............. also create the columns and their definitions or do I have to do the following (which does...
  39. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks, I knew it was something stupid. I've used your suggestion on another table, I thought there would be an easier way when a table was being created by basically copying it.
  40. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    And I've confirmed that there are 684 rows returned in adoBenefits.
Results 1 to 40 of 59
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width