Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-31-2019, 01:19 PM   #31
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,476
Thanks: 0
Thanked 577 Times in 573 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: empty field in eepoet

I thought you were trying to set visibility of controls on form. This can be done in a report. Code would be in Detail section Format event for dynamic display per record but only executes direct to printer or PrintPreview, not Report view

Didn't displaying N/A resolve this issue?

Conditional Formatting can set backcolor, not bordercolor. So if borders were transparent then CF could set background to white when there is no data (or field has N/A) and field would have appearance of not visible. This will work in Report or Print views. If field has N/A, also use an expression in textbox: =IIf(fieldname="N/A", Null, fieldname). But then maybe should go back to not saving N/A and could use number type field for quantitative data.

I find all that color coding rather distracting. Keep in mind if report is copied in B&W, colors will be lost and boxes various shades of grey which can make reading values harder.

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by June7; 10-31-2019 at 01:51 PM.
June7 is offline   Reply With Quote
Old 10-31-2019, 01:43 PM   #32
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,371
Thanks: 115
Thanked 3,111 Times in 2,829 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: empty field in eepoet

VBA code does work in report view as previously stated.
Much of it will not work in print preview e.g. Click or got focus events...again as previously stated
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
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.


Website links:
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.
,
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.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-31-2019, 01:53 PM   #33
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,476
Thanks: 0
Thanked 577 Times in 573 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: empty field in eepoet

Sorry, I meant for automatic dynamic display per record without user interaction, code must be in Detail Format event and only works for print or PrintPreview.

If you want user interaction, that's what forms are for.

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 10-31-2019, 02:08 PM   #34
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,371
Thanks: 115
Thanked 3,111 Times in 2,829 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: empty field in eepoet

User interaction is also what Report View is for.
Though I rarely use it, report view does have benefits including button and hyperlink clicks as well as possible uses such as Dick is suggesting.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
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.


Website links:
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.
,
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.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-31-2019, 03:01 PM   #35
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,499
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: empty field in eepoet

[QUOTE=isladogs;1648200]Try the attached
Here is the old report and basically what I was experimenting with that you asked for.
Attached Files
File Type: zip DicksVitalTruncade.zip (72.9 KB, 11 views)
Dick7Access is offline   Reply With Quote
Old 10-31-2019, 03:03 PM   #36
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,476
Thanks: 0
Thanked 577 Times in 573 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: empty field in eepoet

I agree, one can be made to work somewhat like the other. I have used a form for printing and displayed a report on a form. If OP wants something that can be printed for distribution to doctor or patient, will have to be report Print and code in Format event.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 11-03-2019, 02:37 PM   #37
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,499
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: empty field in eepoet

I want to merge data from two tables into 1 table. (same DB) (same field names) (different data) but some have same ID numbers. What kind of query should I use?

Dick7Access is offline   Reply With Quote
Old 11-03-2019, 03:46 PM   #38
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,476
Thanks: 0
Thanked 577 Times in 573 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: empty field in eepoet

Do these tables have related dependent tables?

Can use a UNION query for temporary 'merge' but if you went them in a new table with ID as unique identifier, will have to create new ID field and associate dependent records with that new ID. Gets tricky.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Dick7Access (11-03-2019)
Old 11-03-2019, 05:17 PM   #39
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,499
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: empty field in eepoet

no they are stand alone tables. thanks I will study Union queries.
Dick7Access is offline   Reply With Quote
Old 11-03-2019, 06:55 PM   #40
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,499
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: empty field in eepoet

Quote:
Originally Posted by June7 View Post
Do these tables have related dependent tables?

Can use a UNION query for temporary 'merge' but if you went them in a new table with ID as unique identifier, will have to create new ID field and associate dependent records with that new ID. Gets tricky.
Thanks again, Union query worked well!

Dick7Access is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] If the field is empty, use a different field as a data source frankt68 Forms 3 01-05-2018 02:08 AM
If you forget any field is empty , MsgBox alerts the forgotten field Falcon88 Forms 3 10-11-2015 07:34 PM
When is an empty field in a table not really empty? psu_1995 Modules & VBA 3 01-30-2008 03:04 AM
Empty Field - but NOT really halem2 Tables 8 10-18-2007 12:06 PM
Empty Field Lyncroft Forms 4 01-15-2003 12:29 AM




All times are GMT -8. The time now is 04:48 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