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
...report name
stDocName = "Sectors_Dueties_List_ByJob_Report"
DoCmd.OpenReport stDocName, acPreview
Add the line between astress after acPreview
your filter from your own main form
*, , "Sector_Code =Forms!Sector_Jobs_Dueties_Main0_Form!combo16"*
Hope, it will help
Hi Ch1:
"I have a main form and several buttons on it to take me to different forms"
Have you concedered using SubForms?
COMP (main form)& UNIT (subform) (linked fileds : based on your structure)(Assumeng they have One-To-Many relationship).
"Now is the problem the tabels are not...
you might do that by adding Total (from the query menu) on your query.Then add the field [month] to the query. Finally, chose Group By for the the [month] field
Hope, this will help :-)
Hi luccas,
***Extra Information***
In Access 2000, you can use Condetional Formating on Format Menu to set up a maximum of three condetions for a specific field (text or numeric).By doing this, you can set Back Col,For Col and Font.
Try it, :-)
PS: You can do same thing on Forms
Hi luccas,
***Extra Information***
In Access 2000, you can use Condetional Formating on Format Menu to set up a maximum of three condetions for a specific field (text or numeric.On doing this, you can set Back Col,For Col and Font.
Try it,
PS: You can do same thin on Foms
Hi,
Yuo wrote that "even if it is a duplicate",so maybe you did not set up a primary key for your forth table.
Why do not you try to creat a macro to run your append query then run it each time yor delete a record(Assument that yor forth table will hold deleted record only). Then, when...
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.