Richard
asked on
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
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
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
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
ASKER
forgive me, have you modified the database/ i thought that you had by attching it but I cant see what you might have done?
are you reading the posted comments?
ASKER
yes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
unless you can say otherwise
which report are you looking at?
i revised the report "chaps data Query rpt"
i revised the report "chaps data Query rpt"
ASKER
looking at same report but cant see the difference, with huge respect to your goodself.
can still see many empty fields.
are you opening the report from the file that i uploaded? 
post your comment about the image
post your comment about the image
ASKER
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....
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....
ASKER
saved it to desk top and several other locs on my computer-still same
very strange...
very strange...
how are you opening the report?
ASKER
click on the bar in the "menu"
ASKER
can see the code behind it you have added
for each etc
for each etc
what "menu"?
just do a double click on the report
just do a double click on the report
ASKER
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
sorry got a train to jump on
will catch up later
thanks as usual
ASKER
tis weird
test on another computer...
ASKER
tested on another computer on the network and works fine.
must be a macro enabled situation??
any ideas?
must be a macro enabled situation??
any ideas?
ASKER
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
I enabled macros on the dialogue box
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.
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.
ASKER
not fire!