Search results

So I have seen this all throughout the forums but it all has to do with the same form and not a different one. I am utterly stuck with this. Goal: Have a basic form that has a combo box that displays the salesman for a car lot. User then selects a name out of the combo box. Now - there is a...

Been a year since being on this forum and its been a year since using Access. That being said - I dont remember a thing, especially when I hardly knew anything to begin with. I am attempting to build a simple database that can track prospective and sold customers. Attached is a picture...

Hello all, I have a continuous form that is slow on loading a portion of the code. The form is designed to pull students who need to be either warned or terminated based off of their GPA. Below is the code that is delayed in being displayed on the form: Public Function...

I have a simple note section on my form (data type set to memo). This is where my staff enters any notes when they speak to a student. For some reason, on a handful of records (3-5 of 3,000 records) a run-time error occurs when the user attempts to edit or add anything to the notes. Does...

I have been battling this for awhile and this is a result from the thread below: http://www.access-programmers.co.uk/forums/showthread.php?t=97048 However, it seems more fitting to have the thread continue here as I am moving onto the relationships. After setting up my tables and attempting to...

Okay - the other database is in the works and is going sloooow (the one that is being created with normalization). Meanwhile, my other database that has no normalization I am having a problem running a query (now I know why its so important to have good structure). To give you an idea on how...

Im just curious on how some of you made a career by creating DB's for clients. Everything I see is generally some other program besides Access. Is Access something I should not learn because there is no demand or is this strictly free lance work? These past few months have captivated my...

What would trigger an error to occur if there has been no changes to a DB. My error # is 2427 (You entered an expression that has no value). This error occurs when I click on a command button to open a report. When I debug, it sends me to an IF statement that I have loaded in the On Format of...

Every time a report is opened, it displays the page at 100% - thus allowing you to view a small portion of the document. Is there a way to lock the zoom at 75% to view the overall page upon opening the report? Thanks, John D

This is what I have: Private Sub GO_Click() If [ARyear] = 2006 Then DoCmd.OpenForm "frm2006AR", acNormal DoCmd.Close acForm, "frmSelectYear" Else End If If [ARyear] = 2005 Then DoCmd.OpenForm "frmFilterForm", acNormal DoCmd.Close acForm, "frmSelectYear" Else End If...

I only have one table and I read so often that its better to have multiple tables. For what I have, it seems to work fine. Will this cause problems down the road? Thank you once again John D

I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc). I am trying to get the report to read the status and check the appropriate box in the...

I have a report that has multiple check boxes etc. When a check box is checked, it then makes the check box bold and then bolds the box surround that entire field. Attached is a picture of 'Employed in the Field' being checked and the effects of it. However, I have a long string of code that...

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

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

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

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

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

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