Selasa, 31 Maret 2020

Re: [MSAccessProfessionals] Quick Access Toolbar video and download

thank you, Bill! I also turn on the Edit Toolbar in VBA ... mostly for the icons to comment and uncomment a block of code :) Add-ins are another thing I added. I have 3 of them posted

Data Dictionary
http://msaccessgurus.com/tool/Addin_DataDictionary.htm

Document SQL, RecordSource, RowSource for Queries, Forms, and Reports
http://msaccessgurus.com/tool/Addin_DocumentSql.htm

Workspace Save and Restore Table Size and Position
http://msaccessgurus.com/tool/Addin_Workspace.htm

Add-ins are trickier since you have to run Access as Administrator to install them. I made a video tutorial on how to do that here:

How to Make and Install an Access AddIn
https://www.youtube.com/watch?v=ljV2vx_r-Bo

warm regards,
crystal

original message:

-----------------------------------
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!
-----------------------------------

On 3/30/2020 11:47 AM, Bill Mosca wrote:
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
 

Re: [MSAccessProfessionals] Quick Access Toolbar video and download

thank you, Duane!


On 3/30/2020 8:05 AM, Duane Hookom wrote:

Very nicely done and great information Crystal. Thanks for sharing.

Duane
Please be safe everyone!


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via Groups.Io <strive4peace2008=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 7:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Quick Access Toolbar video and download
�
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!




Re: [MSAccessProfessionals] Subreport not returning rows

I am sure not what happened but it started working just as it was originally written. I don't even know why it decided to.


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 Monday, March 30, 2020, 12:30:52 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:


Thanks for including the previous message. 

Find the reason. I think I asked very early on if the form was closing. When the report has displayed you can open the debug window (press Ctrl+G) and enter:
[forms]![frmWorkOrderlog]![txtDatefrom]

What do you see?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 12:18 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Subreport not returning rows
 
This is the query for the sub report:

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

For some reason I am losing the contents of the txtDatefrom and txtDateTo when the subreport fires up.



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 Monday, March 30, 2020, 11:59:09 AM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:


Art,
You need to include all of the significant information from previous posts so we know what you are referring to. 

Can you provide the SQL view of the subreport's record source?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 11:46 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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.

Senin, 30 Maret 2020

[AccessDevelopers] Excellent Chance to earn digital currency on your Phone, Free, No Risk, No cost. [3 Attachments]

 

Hello Everyone,

I am Tony, Sorry for bugging you.

We are members of the PI network which is the first digital currency for everyday people.

Pi is a new cryptocurrency for and by everyday people that you can "mine" (or earn) from your phone.

This brand new digital currency (https://minepi.com/cakzxd) was developed by a group of Stanford University Ph.D.'s.

You can earn your own PI coins for free by simply downloading the (Pi Network) app from the Google Play Store or Apple App Store.

It does not drain your phone battery, And you even do not need to leave the APP open to mine,

Pi does not affect your phone's performance or use your network data.

Once you have downloaded the app (pi network, or pi, or minepi) app from the Google Play Store or Apple App Store and insert the invitation code (cakzxd), you just need to click the green lighting button once a day(every 24 hours) to start mining.

Follow the steps below, to get started:
1. First of all you would need to download the Pi app(pi network, or pi, or minepi) app from the Google Play Store or Apple App Store. Or download the app from https://minepi.com/cakzxd

The apple store link is https://apps.apple.com/ca/app/pi-network/id1445472541
The Google Play store link is https://play.google.com/store/apps/details?id=com.blockchainvault

2. After installing the app, you need to verify your identity to log in to the app. You can verify using Facebook account or cell phone number (minepi will text you a verification code),
Or you need to send an SMS to USA or UK if you are outside North America, please email me at arcticglobal@gmail.com if you get any problem.
I highly recommend that you verify your PI account immediately by phone or Facebook to avoid losing any PI coins you mined. (In case you have forgotten your password or changed your telephone device, you cannot log in again with your password.)

3. The app will ask you for the invitation code. Use cakzxd as your invitation code.

4. The app will start a guided tour and it will show you how to use the app. In order to start mining just click the green color Lightning Bolt symbol & that all.

5. Remember to tap the green color Lightning Bolt symbol every 24 hours to renew the mining cycle. Suggest setting up a timer to remind you.

6. Three days (72 mining hours) later, build your own security circle to increase your mining rate. You can email me at arcticglobal@gmail.com if you have any difficulty or do not know how to.

7. I suggest you sending an email to arcticglobal@gmail.com after you setup your account, so I can check your account and help you correct any problem ASAP.

8. Tap chat (right upper corner), then tap "@cakzxd's earning team", you may post your question there, or read my answer to those questions or any notification.

No cost, No risk, No hazard

Pi Network https://minepi.com/cakzxd

invitation code: cakzxd



If you have a cell phone, know how to install an app. and want a stable income with unlimited opportunity in the near future, you are in the RIGHT PLACE at the RIGHT TIME.
You do not need to sell anything, No inventory. No deliveries. No collecting payments. No meetings. No bugging friends. There are no fees to purchase, no quotas, and no limits, even there is no financial commitment required.
You only need to take less than 5 seconds daily. Free training is included.
No Cost, No Risk, No Hazard
What have you got to lose?




Is the new cryptocurrency PI Network another scam or legit?

I have always been very skeptical and distant from all the hype around digital currency in general due to my basic investment principle that when everyone on the street starts talking about an investment product, it is generally too late to invest in it. It is in this state of mind that I listen to a family friend who tried for months to encourage me to join his cryptocurrency investment group. He got my attention when he mentioned that this one is a new innovation that is at the free distribution phase with no financial commitment required.

As soon as I reached home, I started making some background research on the Pi Network and found that not only it is a very legitimate and innovative digital currency initiative, but more importantly, it is still at the right stage to jump in with an excellent risk-reward ratio. Of course, there is no guaranty that it will be a successful project, but what you tent to lose is a few minutes a day of hitting a button on your mobile and the mobilization of your network of friend and family at no financial cost to you or them for a possible reward of amassing lot of Pi digital currencies that could be very valuable in the future if the project is successful. Below is the summary of the findings of my research on the PI Network and my recommendation.

1. It is a project credited to three Stanford University PHDs namely: Dr Nicolas Kokkalls (head of technology), Dr. Chengdiao Fan (Head of product) and Vincent McPhillips (head of the community)

2. The company only offers a service, but no product. After downloading the Pi Network app, you need to confirm that you are a human by pressing a lightning symbol on the app at 24 hours intervals. This will initiate the mining process at a predetermined rate on your mobile device (currently 0.20pi/hr) without draining your phone battery. You are free to exit the app after that action without discontinuing the mining process.

3.  It is a FREE App. Free to download (with no ads) either from google play or apple store. You may search pi, pinetwork,or minepi

4. Members can join only on invitation from other members. You can accelerate your mining rate by inviting other members to join using your code. You are welcome to use mine to join if you decide to or if this review adds any value to you (cakzxd).

5. After three successful mining cycles of 24 hours each, you qualify to become a contributor and you can form a security circle of 3 to 5 trusted members. This will accelerate your mining rate as well.

6. The mining rate has been halve for any multiple of 10 members that the network achieved. The project started in March 2019 at a rate of 3.1 Pi/hr and in November 2019 the network reached 1 million members and the current rate is 0.20 pi/hr.

7. The next milestone is at 10million members and it is not yet clear if the mining process will be discontinued at that stage or if it will continue to reduce in speed.

8. On Pi network white paper, a summary description of the technology they use is as follows: For Pi, we introduced the additional design requirement of employing a consensus algorithm (the process that records transactions into a distributed ledger) that would also be extremely user-friendly and ideally enable mining on personal computers and mobile phones. The consensus algorithm that they use is the Stellar Consensus Protocol (SCP) that was architected by David Mazieres a Professor of Computing Science at Stanford University as stated in Pi Network white paper as well.

My recommendation:

Pi has no value currently, just as Bitcoin in 2008, but could have value in the future. Pi Network is using an innovative digital currency technology that will decentralize the mining of digital currency to ordinary people and is user-friendly through mobile phones. In my view, the risk-reward ratio justifies my recommendation of jumping in while it is still open. But like for everything in life, feel free to do your own research. This is only my personal opinion and if you decide to go by it I will appreciate you using my code to join. It will bless me in return by accelerating my mining rate. You can reach me at arcticglobal@gmail.com if you would like to discuss more about this project.

Again, before and after installing this PI app, please read the following and make sure you understand them well, Or if you have any questions, please reply to this email or reply to arcticglobal@gmail.com

--PI is global,

--Verify your PI account with your phone number or Facebook immediately to avoid losing any PI coins you mined,

--1 person, 1 PI account, 1 device, 

--Update the mining cycle every day by pressing the green lighting button every 24 hours,

--after 3 days, build your own security circle to increase the earning rate.


__._,_.___
View attachments on the web

Posted by: goa29 gohomes29 <gohomes29@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Check out the automatic photo album with 3 photo(s) from this topic.
ad final - 2.jpg google2.jpg apple2.jpg


Please zip all files prior to uploading to Files section.

.

__,_._,___

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

So I just requested a sharepoint site. and it was granted. what do you know

Jim Wagner


On Monday, March 30, 2020, 10:12:49 AM MST, Rob Koelmans <r.koelmans@metamicro.nl> wrote:


Why not just email an Excel-template around? If needs to be pdf you need a pdf-form creator from Aabyy, Foxit, Adobe PDF creator.

 

On or site, you see some very simple code to have people submit their hours to SQL-Server of Azure-SQL. We have Flow threads that you can use if you want.

 

https://youtu.be/uLCcdZ3d_pw

rob

 

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Jim Wagner
Verzonden: maandag 30 maart 2020 18:58
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

Our department does not have access to sharepoint. getting people just to use slack and zoom is like very difficult. one person said that she did not want to have to go and use something else and would only use email. I am living in a tech dinosaur land of people

 

Jim


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 9:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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

Thanks for including the previous message. 

Find the reason. I think I asked very early on if the form was closing. When the report has displayed you can open the debug window (press Ctrl+G) and enter:
[forms]![frmWorkOrderlog]![txtDatefrom]

What do you see?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 12:18 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Subreport not returning rows
 
This is the query for the sub report:

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

For some reason I am losing the contents of the txtDatefrom and txtDateTo when the subreport fires up.



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 Monday, March 30, 2020, 11:59:09 AM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:


Art,
You need to include all of the significant information from previous posts so we know what you are referring to. 

Can you provide the SQL view of the subreport's record source?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 11:46 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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] Subreport not returning rows

This is the query for the sub report:

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

For some reason I am losing the contents of the txtDatefrom and txtDateTo when the subreport fires up.



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 Monday, March 30, 2020, 11:59:09 AM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:


Art,
You need to include all of the significant information from previous posts so we know what you are referring to. 

Can you provide the SQL view of the subreport's record source?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 11:46 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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

Why not just email an Excel-template around? If needs to be pdf you need a pdf-form creator from Aabyy, Foxit, Adobe PDF creator.

 

On or site, you see some very simple code to have people submit their hours to SQL-Server of Azure-SQL. We have Flow threads that you can use if you want.

 

https://youtu.be/uLCcdZ3d_pw

rob

 

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Jim Wagner
Verzonden: maandag 30 maart 2020 18:58
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Getting Access data into a PDF Template

 

Our department does not have access to sharepoint. getting people just to use slack and zoom is like very difficult. one person said that she did not want to have to go and use something else and would only use email. I am living in a tech dinosaur land of people

 

Jim


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 9:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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

Art,
You need to include all of the significant information from previous posts so we know what you are referring to. 

Can you provide the SQL view of the subreport's record source?

Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 11:46 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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

Our department does not have access to sharepoint. getting people just to use slack and zoom is like very difficult. one person said that she did not want to have to go and use something else and would only use email. I am living in a tech dinosaur land of people

Jim

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Rob Koelmans <r.koelmans@metamicro.nl>
Sent: Monday, March 30, 2020 9:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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