Search:
Type: Posts; User: AngelSpeaks
Search:
Search took 0.02 seconds.
-
I know, I'm talking to myself. I tried to query using MIN instead of MAX and IT WORKED!
-
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...
-
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. ...
-
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...
-
Thanks for your suggestion.
-
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...
-
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...
-
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.
-
Thanks. I appreciate your help.
-
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.
-
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...
-
-
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...
-
Datagridview form code.
Public Class FrmJobGrid
Inherits Form
Private WithEvents dgvJobs As New DataGridView()
Private bindingSource1 As New BindingSource()
Private...
-
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,...
-
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...
-
Oops, found the version link and selected the older version.
-
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...
-
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...
-
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 #...
-
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?
-
Update. Uninstalled Microsoft.Reporting.Services and RDLC Report Designer. Installed all updates to VS2019. Rebooted. Reinstalled Reporting Services (separately), then RDLC.
Using this link,...
-
No luck. When I go into Manage NuGet Packages, the Microsoft.Reporting services doesn't display
-
Thanks. I'll give it a try.
-
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.
-
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...
-
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. ...
-
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.
-
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...
-
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],...
-
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...
-
:) 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
...
-
-
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
...
-
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...
-
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...
-
Thanks John, that's probably a better idea.
-
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...
-
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.
-
And I've confirmed that there are 684 rows returned in adoBenefits.
|
Click Here to Expand Forum to Full Width
|