Search results for query: *

OH THANK YOU! I assure you that I will post the final solution. Please accept a purple star - wish I could give you more of a thank you though :-)

Thank you for the help although I am just learning this VBA coding. I know that this is asking alot, but could you put an example database together and send it to me (lena.wood@starband.net) so I can see how it all works? I will understand if you don't have the time. I learn much better if I...

Thanks Rick, but as I said in my original message...there seems to be something missing from it. I appreciate your effort.

Guess this isn't possible. Thanks anyway :-)

Thank you!

If my boss wants the numbers lined up I will make a continous form to do it. What I am doing is creating a form (with subforms) of different statistics regarding our Security Clearances so all the fields are locked and can't be altered (although they couldn't because they information is from a...

I have always been told that you don't store calculated fields in a table. You would create a query and have the query make the calculations for you. When you create a report and/or form, the calcualtions would appear on the report and/or form just as if they were stored in a table. HTH

Paul, Under references, the first 6 are marked. There appears to be LOTS and LOTS that are not.

Norris - Thanks for the advice. Although I am at home working on 2000 I need for this to work on 97 so was trying to make it work without using the new conditional formatting of 2000. Paul - Thanks for the tip. I will try that when I get home from work. I will let you know if it doesn't work...

Wabeg, I am interested in learning more about the getuser(). I am in the process of making a safety suggestion database and want to be able to capture who initiates the suggestion being added and also be able to make it so only those assigned the suggestion to track can make changes to it...

The last time I tried to implement user level security I locked myself totally out of access. Our IT department had to come and re-install Access...to say the least, they were not happy with me :-( Kinda scares me to try it again. I will check out the FAQ though...I will just warn them I am...

Thank you for your help. Ellie

Checking my post from home and it appears that no one has an answer for me. Maybe this can't be done. Ellie

Delete all the records and compact your database. Ellie