?
Solved

access query and  report

Posted on 2011-02-24
23
Medium Priority
?
223 Views
Last Modified: 2012-05-11
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
Comment
Question by:topUKlawyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 13
  • 10
23 Comments
 

Author Comment

by:topUKlawyer
ID: 34970120
show read "fields where there are no entries"
not fire!
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34970318
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
 

Author Comment

by:topUKlawyer
ID: 34970434
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34970555
are you reading the posted comments?
0
 

Author Comment

by:topUKlawyer
ID: 34970648
yes
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 34971143
did you see the change?

here is the file again, open the report


practice-completionDatabase.mdb
0
 

Author Comment

by:topUKlawyer
ID: 34971347
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34971449
which report are you looking at?

i revised the report "chaps data Query rpt"
0
 

Author Comment

by:topUKlawyer
ID: 34971614

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

can still see many empty fields.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34971675
are you opening the report from the file that i uploaded? here is the report


post your comment about the image
0
 

Author Comment

by:topUKlawyer
ID: 34971856
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34971897
download the file i uploaded at http:#a34971143

and save it AWAY from your files.
0
 

Author Comment

by:topUKlawyer
ID: 34972021
saved it to desk top and several other locs on my computer-still same

very strange...
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34972068
how are you opening the report?
0
 

Author Comment

by:topUKlawyer
ID: 34972130
click on the bar in the "menu"
0
 

Author Comment

by:topUKlawyer
ID: 34972148
can see the code behind it you have added


for each etc
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34972193
what "menu"?

just do a double click on the report
0
 

Author Comment

by:topUKlawyer
ID: 34972216
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
 

Author Comment

by:topUKlawyer
ID: 34972228
tis weird
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34972398
test on another computer...
0
 

Author Comment

by:topUKlawyer
ID: 34977949
tested on another computer on the network and works fine.

must be a macro enabled situation??

any ideas?

0
 

Author Comment

by:topUKlawyer
ID: 34981527
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34981628
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question