Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-31-2019, 12:38 PM   #1
screentone
Newly Registered User
 
Join Date: May 2019
Posts: 3
Thanks: 4
Thanked 0 Times in 0 Posts
screentone is on a distinguished road
Question Selecting Form Fields for Report

Hello, I am making a database that has forms displaying records with an email field.

I am having trouble figuring out how to have a button that will allow me to add the email addresses of the current record to a text box in a report (with a comma between them preferably) that I could print or copy/paste.

Any help would be appreciated, thank you.

screentone is offline   Reply With Quote
Old 05-31-2019, 12:46 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,914
Thanks: 57
Thanked 1,293 Times in 1,274 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Selecting Form Fields for Report

Hi. Welcome to the forum. I'll try to give you a copy/paste approach for now, since I am not sure I understand the report connection at this time. So, you could try to put an unbound textbox on the header of your form. Then, you could try to populate it with the email address and just copy and paste the result whenever you need it. To do so, you could try using the following code in the Click event of your button.
Code:
Me.TextboxName = Me.TextboxName & "," & Me.EmailAddressField
Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
screentone (05-31-2019)
Old 05-31-2019, 01:13 PM   #3
screentone
Newly Registered User
 
Join Date: May 2019
Posts: 3
Thanks: 4
Thanked 0 Times in 0 Posts
screentone is on a distinguished road
Re: Selecting Form Fields for Report

Quote:
Originally Posted by theDBguy View Post
Hi. Welcome to the forum. I'll try to give you a copy/paste approach for now, since I am not sure I understand the report connection at this time. So, you could try to put an unbound textbox on the header of your form. Then, you could try to populate it with the email address and just copy and paste the result whenever you need it. To do so, you could try using the following code in the Click event of your button.
Code:
Me.TextboxName = Me.TextboxName & "," & Me.EmailAddressField
Hope it helps...
More about my initial thoughts to use a report: I have two different forms that display records from two different tables. I thought I might be able to add emails from both tables to a single text box. The emails would be added to a running list that can be added to and cleared by the user, but wouldn't be kept between sessions.

screentone is offline   Reply With Quote
Old 05-31-2019, 01:22 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,914
Thanks: 57
Thanked 1,293 Times in 1,274 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Selecting Form Fields for Report

Quote:
Originally Posted by screentone View Post
More about my initial thoughts to use a report: I have two different forms that display records from two different tables. I thought I might be able to add emails from both tables to a single text box. The emails would be added to a running list that can be added to and cleared by the user, but wouldn't be kept between sessions.
Well, there several places where you can store values to keep them independent of other objects. You can use a separate standalone form, a global variable, a TempVars variable, or a temp table.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
screentone (05-31-2019)
Reply

Tags
button action , form field , report

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting And Exporting A Single Record From A Form With Calulated Fields David92595 Forms 1 07-29-2011 01:00 PM
Question Selecting all fields if form field is blank lynxbci General 2 02-11-2011 05:59 AM
Selecting data on subforms and make them display on form fields rodvaN Forms 5 06-23-2009 05:34 AM
selecting Fields for report murlen Reports 2 04-13-2005 07:14 AM
Selecting what fields are displayed in a datasheet form Essendon Forms 2 07-16-2003 03:38 PM




All times are GMT -8. The time now is 05:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World