Search results

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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!

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

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

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