Search results

  1. J

    Check box not visible on report when printed

    It was the CTRL key (A97)... but worked like a charm! Thank you
  2. J

    Check box not visible on report when printed

    How can I get the check box to be visible when I print out a report. For some odd reason, they are extremely difficult to see - even when I make it 1pt border. I have created a transparent box surrounding the check box, but the box is a little large for the report. (I cant create a box the...
  3. J

    Need Expert Help in Access - Excel

    Pat, websites are really good, I think I can work off of what you provided. Thanks a million. John
  4. J

    Need Expert Help in Access - Excel

    Peter, I will be eliminating all worksheets except the Completion and Placement Charts (CPC) if I can get Access to update these only. The form is submitted as a print out. The problem is the Accrediting body. They are very adament about using there form and last time I changed one of there...
  5. J

    Need Expert Help in Access - Excel

    This might help in understanding what I need... Each student is one or the other: 1) Terminated 2) Terminated but employed in the field 3) Graduate employed in field 4) Graduate Furthered Education 5) Other Unavailable (Death, Medical, Prison and so on) 6) Graduate employed in unrelated...
  6. J

    Need Expert Help in Access - Excel

    Okay, I referenced this website: http://support.microsoft.com/default.aspx?scid=kb;en-us;193039 and I understand the concept, but how is this tied into Access - it appears it is working in Excel only. I apologize for the questions :o John D
  7. J

    Need Expert Help in Access - Excel

    I have a situation. In completing our Annual Report for our Accrediting body for my school, it requires us to complete a 'Completion and Placement Chart'. This chart was provided to us in Excel. The problem was that we needed a system to automaticaly update this chart as the year progressed...
  8. J

    Animated Splash Screen

    Dave, I have used the search function and this is an animated logo that is within the database once it is open. This I have allready accomplished, however I was wondering about the Splash screen when you first open Access (when you enter USER ID and PASSWORD).... Thinking about it though, I...
  9. J

    Read from another excel

    Correct me if im wrong, but it seems like a simple formula: =SUM('enter your worksheet here'!enter cell reference here) Of course this is if your worksheets are located in the same workbook.
  10. J

    Animated Splash Screen

    I have learned how to create animated command buttons within a form. This works out great, but this brought on new ideas. Currently, all I have is a stand alone picture (our logo) that is stored in the same directory as the db and to my knowledge this has nothing to do with access at all...
  11. J

    Best Book for Access 97

    Thank you Pat! Thank you Pat for the great suggestions on the books. I received both of them and they work out great. A dozen of question have allready been answered in these books and they both work hand in hand! John
  12. J

    Tab Control Box - Font Color

    Does that apply to the text/box inside the tab control? If I cant do the above, can I make the box surrounding the Felony / misdemeanor turn red in the event that it has been checked... I have tried the below.. Private Sub Form_Current() If [Felony] = True Then Felonybox.BackStyle = 1...
  13. J

    Tab Control Box - Font Color

    I believe thats the proper word for it. Attached is a screenshot of a section of the database that I have started working on. It is to track placement for a college. Its my first ever and I am fairly good at making things look good, but as far as function - I am terrible. I can change the...
  14. J

    Simple yet complicated

    ...Precisely why I have just purchased two books on Access...
  15. J

    Best Book for Access 97

    Thank you for the quick responses, I immediately went and ordered the books that Pat mentioned from Amazon ($15.00 for both including shipping). If I need more then this I will certainly look into "Access Database design and programming". Thanks!
  16. J

    Best Book for Access 97

    I allready looked at what was recommended in this forum - but I noticed there are only two books listed. Are both of these books good for beginners or is the Access 97 Bible better? I have seen about a dozen of books and would like to have a few on hand to learn from and to reference as my...
  17. J

    Simple yet complicated

    That would certainly cause me a headache if I have to do that manually. All and all, we just need to identify the user in the record and have that be displayed in the form so that other users may know who to contact within our agency. (We are using Windows 2000 and Access 97) if that makes a...
  18. J

    Simple yet complicated

    I have searched and tried previous examples to only fail in this process. We have a database that is accessed by over 20 employees at one time and virtually every day we run into the same problem. Someone is trying to edit a record but can not do this due to another user being logged into that...
Back
Top Bottom