Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

access query and report

i attch dbe.
go to chaps data query report
This report shows fields that have some entries and fires where there are no entries.
Is it posssible to produce a report based on a query like this:
If there are no entries in that field DO NOT include that field in the report.

Also could then any empty space be removed in the report to save space/paper (which is the real object)




practice-completionDatabase.mdb
0
topUKlawyer
Asked:
topUKlawyer
  • 13
  • 10
1 Solution
 
topUKlawyerAuthor Commented:
show read "fields where there are no entries"
not fire!
0
 
Rey Obrero (Capricorn1)Commented:
see if this helps

set the can grow and can shrink property of the textboxes
add code in the detail format event to hide textboxes that don't have values

you may try using sub reports.
practice-completionDatabase.mdb
0
 
topUKlawyerAuthor Commented:
forgive me, have you modified the database/ i thought that you had by attching it but I cant see what you might have done?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Rey Obrero (Capricorn1)Commented:
are you reading the posted comments?
0
 
topUKlawyerAuthor Commented:
yes
0
 
Rey Obrero (Capricorn1)Commented:
did you see the change?

here is the file again, open the report


practice-completionDatabase.mdb
0
 
topUKlawyerAuthor Commented:
must be a Slow Brain Day....i cant see the difference...i seem to be getting all the same fields, empty or not.

unless you can say otherwise
0
 
Rey Obrero (Capricorn1)Commented:
which report are you looking at?

i revised the report "chaps data Query rpt"
0
 
topUKlawyerAuthor Commented:

looking at same report but cant see the difference, with huge respect to your goodself.

can still see many empty fields.
0
 
Rey Obrero (Capricorn1)Commented:
are you opening the report from the file that i uploaded? here is the report


post your comment about the image
0
 
topUKlawyerAuthor Commented:
looks great but nothing like the one I opened from the one you sent me

ie the jpg looks fine but doesnt look like the report at my end...

are sure you didnt make a fresh copy at your end which hasnt been sent yet....

0
 
Rey Obrero (Capricorn1)Commented:
download the file i uploaded at http:#a34971143

and save it AWAY from your files.
0
 
topUKlawyerAuthor Commented:
saved it to desk top and several other locs on my computer-still same

very strange...
0
 
Rey Obrero (Capricorn1)Commented:
how are you opening the report?
0
 
topUKlawyerAuthor Commented:
click on the bar in the "menu"
0
 
topUKlawyerAuthor Commented:
can see the code behind it you have added


for each etc
0
 
Rey Obrero (Capricorn1)Commented:
what "menu"?

just do a double click on the report
0
 
topUKlawyerAuthor Commented:
am doing that i really am,  how i usually open reports...

sorry got a train to jump on

will catch up later

thanks as usual
0
 
topUKlawyerAuthor Commented:
tis weird
0
 
Rey Obrero (Capricorn1)Commented:
test on another computer...
0
 
topUKlawyerAuthor Commented:
tested on another computer on the network and works fine.

must be a macro enabled situation??

any ideas?

0
 
topUKlawyerAuthor Commented:
have awardede points but any ideas as to why tmy computer is blocking the code would be welcome.

I enabled macros on the dialogue box
0
 
Rey Obrero (Capricorn1)Commented:
without seeing your computer, i can't really tell.
check virus protection softwares (norton ???)  that you have in your pc and compare it with the pc where you were able to run the report successfully.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 13
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now