Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: new9
  • Order by date
  1. new9

    signon security

    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
  2. new9

    signon security

    Hi OldTom, I need your email to send the file. PS: I tried to send the file to OldTom@tommoranbtclick.com but it did not go through :~/
  3. new9

    signon security

    Hi adolfop, I sent a copy of the zipped file to your email (adolfop@telstra.com).I hope it will help.
  4. new9

    signon security

    Higadsbywc; I sent a copy of the zipped file to your email.
  5. new9

    signon security

    Hi wenyonk & Gator9 : I sent a copy of the zipped file to your e-mails. Good luck
  6. new9

    giving records a number in a form

    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,,
  7. new9

    giving records a number in a form

    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...
  8. new9

    signon security

    Hi Animaniac : I sent the zip file to your work Email. Good Luck
  9. new9

    signon security

    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...
  10. new9

    signon 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,,
  11. new9

    signon security

    Hi fredk: I sent you a zip file on 9-2-2002. Hope you like it. Take care,, PS: I am new to the site not to Programming :-)
  12. new9

    signon security

    Hi fredk: I have a zipped file but I don't know how to send it. :~/
  13. new9

    Hilite a 0 value record in a report.

    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,
  14. new9

    Summing Totals Between Subreport and Main

    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
  15. new9

    Print by ID?? Help

    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...
  16. new9

    Update table with values on the form

    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...
  17. new9

    Average

    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 :-)
  18. new9

    Activate a textbox backcolor from another textboxes value

    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
  19. new9

    Activate a textbox backcolor from another textboxes value

    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
  20. new9

    Delete, Append, Make New Table Querries....what???

    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...

Part and Inventory Search

Back
Top