ACCESS FEED

Senin, 30 Maret 2020

Re: [MSAccessProfessionals] Quick Access Toolbar video and download

Thanks, Crystal. I tend to customize the heck out of my Outlook and Access Ribbons. Then there is the VB Editor menu bars and add-ins. I truly hate changing machines because a lot of that stuff just doesn't have easy import/export capabilities.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Subreport not returning rows

For whatever reason, the subreport query loses the date criteria which is obtained via the main report query.

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Wednesday, March 25, 2020, 11:17:08 PM CDT, Arnelito Puzon <agpuzon@gmail.com> wrote:

why not move the HAVING clause to WHERE clause of the query.

Re: [MSAccessProfessionals] Getting Access data into a PDF Template

You can have it as all pdf documents. But its more work. You need a C# project. Easiest is to create Word docx and have a OnCreate Trigger in SharePoint that automatically converts it into a PDF.

Rob

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: maandag 30 maart 2020 18:37
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

so because it is a university and we are under ferpa and other adherents and some people's lack of trust and understanding of these new technologies, I am limited. this may seem crazy but it is what it is.

I have played with powerapp but putting something like this in production would be more of trying to pass a bill through legislation right now. it would be like trying to get the earth to stop turning.

I once asked if i could get SQL server installed on my machine. considering we had bought SQL as a department. But they told me "SQL is a security risk" I said what???

Jim.

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 3:44 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

We built a PowerApp that integrates with Access through SQL-Server with an option to sign report. Perhaps I’m not understanding correctly but why would use PDF for that?

Kind regards.

Rob

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Stuart Schulman via Groups.Io
Verzonden: maandag 30 maart 2020 03:13
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

I’ve done that using Access many times in different client sites.

Stuart

Sent from Mail for Windows 10

From: anzus101
Sent: Saturday, March 28, 2020 10:25 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

Check PHP Rad and Postgres.I am starting to move away from access and these technologies are my best picks.

On Friday, March 27, 2020, <josephwagner2@outlook.com> wrote:

Hello All,

We are trying to send out timesheets now that we are stuck at home. But the VP wants them to be fillable forms so that they can fill out hours and then sign and return. We have looked everywhere and are unable to get data into the template. Is there a way to do that? I did find a site that stated that it cannot be done, but where there is a cannot be done, there is a can be done.

Any help would be greatly appreciated.

Thank You
Jim Wagner

Re: [MSAccessProfessionals] Subreport not returning rows

I tried adding parameter and now when the report kicks off it prompts me for an From and To date....

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Wednesday, March 25, 2020, 09:25:08 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Art,

When you are in design view of your query, click the parameters icon near the top right. Enter you form/control and select Date With Time.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Wednesday, March 25, 2020 3:11 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Subreport not returning rows

Duane,

Sorry it took so long o reply, Putting out fires all day. The form frmWorkOrderLog stays open during the whole process. You have to click a button to close it. The user enters the start date in text field txtDateFrom and the end date in text field txtDateFrom and click a button that execute the following code:

Private Sub cmdReport_Click()
On Error GoTo Err_cmdReport_Click

Dim stDocName As String

stDocName = "rptWOLogReport"

'Check values are entered into Date From and Date To text boxes
'if so run report or cancel request

    If Len(Me.txtdatefrom & vbNullString) = 0 Or Len(Me.txtDateTo & vbNullString) = 0 Then
        MsgBox "Please ensure that a report date range is entered into the form", _
               vbInformation, "Required Data..."
        Exit Sub
    Else
        DoCmd.OpenReport stDocName, acPreview
    End If
Exit_cmdReport_Click:
    Exit Sub

Err_cmdReport_Click:
MsgBox Err.Description
Resume Exit_cmdReport_Click
End Sub

If I hard code the to and from dates into the query:

SELECT Count(SV00300.Service_Call_ID) AS CountOfService_Call_ID, SV00300.Type_of_Problem
FROM SV00300
GROUP BY SV00300.Type_of_Problem
HAVING (((SV00300.DATE1)>=[forms]![frmWorkOrderlog]![txtDatefrom] And (SV00300.DATE1)<=[forms]![frmWorkOrderlog]![txtDateto]));

It works. But when I change it to:

Is does not return anything.

Can you explain how I use Parameter data types in my query. I don't think I have encountered them before.

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Tuesday, March 24, 2020, 06:11:15 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Art,

Can we assume you are not closing the frmWorkOrderlog anywhere prior to the report fully displays?

I would try add Parameter data types to the subreport's record source for the dates.

Does this query return records when the report is open?

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Tuesday, March 24, 2020 5:10 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Subreport not returning rows

I have a report that works fine. But I pulled in a query from the object viewer which createa a sub report but its only retrieving one row. If you run the query it returns multiple rows. I am I missing a setting in the sub report? Then I figured out that there was a master/child link between the main report and the sub report. I removed that and it worked fine.

But then I ran into another issue, I changed the sub report query to the following:

SELECT Count(SV00300.Service_Call_ID) AS CountOfService_Call_ID, SV00300.Type_of_Problem
FROM SV00300
GROUP BY SV00300.Type_of_Problem
HAVING (((SV00300.DATE1)>=[forms]![frmWorkOrderlog]![txtDatefrom] And (SV00300.DATE1)<=[forms]![frmWorkOrderlog]![txtDateto]));

and now the subreport does not return any data.

The main report record source is as follows:
SELECT SV00300.ADRSCODE AS [Unit No], SV00300.CUSTNAME AS [Tenant Name], SV00300.Service_Call_ID AS [Work Order ID], SV00300.Service_Description, SV00300.DATE1 AS [Work Order Date], SV00300.Type_of_Problem AS Type, SV00300.Status_of_Call AS Status, SV00300.Technician
FROM SV00300
WHERE DATE1>=[forms]![frmWorkOrderlog]![txtDatefrom] And
DATE1<=[forms]![frmWorkOrderlog]![txtDateto] And
Status_of_Call=Nz([forms]![frmWorkOrderlog]![cbostatus],Status_of_Call);

If I leave the dates hardcoded in the sub report it returns rows.

Any ideas?

Thank you

Art Lorenzini,
Sioux Falls, SD

Re: [MSAccessProfessionals] Getting Access data into a PDF Template

I once asked if i could get SQL server installed on my machine. considering we had bought SQL as a department. But they told me "SQL is a security risk" I said what???

Jim.

We built a PowerApp that integrates with Access through SQL-Server with an option to sign report. Perhaps I'm not understanding correctly but why would use PDF for that?

Kind regards.

Rob

I've done that using Access many times in different client sites.

Stuart

Sent from Mail for Windows 10

From: anzus101
Sent: Saturday, March 28, 2020 10:25 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

Check PHP Rad and Postgres.I am starting to move away from access and these technologies are my best picks.

On Friday, March 27, 2020, <josephwagner2@outlook.com> wrote:

Hello All,

We are trying to send out timesheets now that we are stuck at home. But the VP wants them to be fillable forms so that they can fill out hours and then sign and return. We have looked everywhere and are unable to get data into the template. Is there a way to do that? I did find a site that stated that it cannot be done, but where there is a cannot be done, there is a can be done.

Any help would be greatly appreciated.

Thank You
Jim Wagner

Re: [MSAccessProfessionals] Subreport not returning rows

Do I get rid of it in the query.... ?

>=[forms]![frmWorkOrderlog]![txtDatefrom] And (SV00300.DATE1)<=[forms]![frmWorkOrderlog]![txtDateto]));

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Wednesday, March 25, 2020, 09:25:08 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Art,

When you are in design view of your query, click the parameters icon near the top right. Enter you form/control and select Date With Time.

Duane

Duane,

Private Sub cmdReport_Click()
On Error GoTo Err_cmdReport_Click

Dim stDocName As String

stDocName = "rptWOLogReport"

'Check values are entered into Date From and Date To text boxes
'if so run report or cancel request

Err_cmdReport_Click:
MsgBox Err.Description
Resume Exit_cmdReport_Click
End Sub

If I hard code the to and from dates into the query:

It works. But when I change it to:

Is does not return anything.

Can you explain how I use Parameter data types in my query. I don't think I have encountered them before.

With Warm Regards,

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265 Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Tuesday, March 24, 2020, 06:11:15 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Art,

Can we assume you are not closing the frmWorkOrderlog anywhere prior to the report fully displays?

I would try add Parameter data types to the subreport's record source for the dates.

Does this query return records when the report is open?

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Tuesday, March 24, 2020 5:10 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Subreport not returning rows

Re: [MSAccessProfessionals] Quick Access Toolbar video and download

Thank you!

> On Mar 30, 2020, at 8:40 AM, crystal (strive4peace) via Groups.Io <strive4peace2008=yahoo.com@groups.io> wrote:
>
> hello Access lovers,
>
> I just set up a machine with Office 365 and one of the first things I did when I opened Access was import my Quick Access Toolbar (QAT) since it helps me work faster and be more productive. I made a video tutorial about how to do this, and commands that I find useful:
>
> https://www.youtube.com/watch?v=I_DCvlt8tYo
>
> Here is a download link for my QAT if you want to use it too:
> http://msaccessgurus.com/tool/QAT.htm
>
> I hope it can help you as much as it helps me!
>
> kind regards,
> crystal
>
> remote programming and training
> let's connect!
>
>
>
>

-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.

View/Reply Online (#115454): https://groups.io/g/MSAccessProfessionals/message/115454
Mute This Topic: https://groups.io/mt/72651024/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-