Hi steve;
I sent a copy of the zipped file to your email
sjellertson@hotmail.com. If it possible,please, send me a copy of what you did (sample copy) to sea your approuch.
Thanks
new9
prag8@yahoo.com
Hi:
What kind of error did you get?
Anyway, try the following:
On the fuction,
Change this "AlreadyAssigendInst_For_DesAspecificProg" to your continous form name and try it again.
Good luck,,
Hi:
I used another function to do the job and my fuction works fine. However, I am sure my function needs some tuining up to be perfect.
Note : I have a field on my form which has Recnum() as field source.
------------------------
My fuction:
------------------------
Option Compare Database...
Hi SteveCarey:
First of all thanks for your offer.
Actually, I developed my own security schem because 99% of the users were assighned same authority for the forms & reports. The only difference was on which data they can use (same data but different deprtments. Therfore, using Access security...
Hi fredk:
Please, can you tell me if my approch was fine? Also, I hope that can update me if you find a better way or any emprovement for waht I did.
Thanks,,
Hi:
If you use Access2000 you could use Conditional Formating on Format Menue to do the job. Actually, You can set up to three conditions for the field. Plus, you can use constants or other fields' values to write your conditions.
Also, you can play with Font & COL.
Good lock,
Quick though,
If you use the correct reference to the field in your detail {Reports!your reportName![FieldName]}, you can use it in your SubReport.
I might be wrong
Hi:
Give it a try:
Reports in Access have semelar princepals as Forms.
Since you delt with Form Subform, I think you can do the same with reports.
Create Main Report (use same query as your Main Form).
Create SubReport (use same query as your SubForm).
On your Main Report, add your SubReport and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.