Search results

Hi I have a report that shows all records with criteria for land development (which are each scored) then all scores are added up for each record. This works great. However, I have been told that it needs to be ordered by the total score, in decending order, which I cannot do. The total...

Hi I have a field that needs to be populated with percentages according to the site area given, which is this: SITE_AREA GN_Ratio Less than 0.4 100% Between 0.4 and 2 90% Between 2 and 10 75% More than 10 50% I am attempting to try and populate a field on one...

Hi I have another post at the moment but this one is important too. I have a form that calculates the yield using these steps: 1. User selects the location and characteristics of the site 2. The density automatically shows 3. The percentage is from the first tab on the form 4. The user selects...

Hi I have this form that users need to answer questions that will show up scores. I have created the form, which works well, except for the fact that when a user choose an answer, it is not 'sticking'. For example, for the first question, a user will pick one of the answers, then move on to...

Hi Is there a query that first finds out whether a field is null that then goes in to more If functions? This is what I have at the moment: If mixed = "town centre" then mixed_ratio = "25%" else If mixed = "employment" then mixed_ratio = "100%" else mixed_ratio = "75%"...

Hi I am hoping someone can help me with this. I have a form that has two combo boxes (Location and Char). When an option is chosen from the two combo boxes, I need the next field to display a number (Density) that is dependant on the combo box choices. I will explain this more as it may not...

Hi I have been working on a database that holds information about sites around the UK which are scored on whether they are located well etc. A form has been made that looks up questions and answers from two different tables (answers are in a combo box as each question has at least two answers)...

Hi I feel really stupid for asking this, but I am so stressed at the moment, I can't concentrate! I have a database that stores land locations and information relating to it. In the database, I need a form that asks 13 questions and answers are given in drop down boxes (about 3 answers to...

I have check boxes that enable and disable text boxes on one of my forms. However, I am having trouble getting it to stick to being checked when I close the form. For one of the check boxes, this is the code: Private Sub extent_AfterUpdate() If Me.extent = True Then PP_SITE_CAP.Enabled...

Hi guys I have a piece of code that words out an area of land that is available to build on from its full value, using the following code: Private Sub DT_PERCENT_AfterUpdate() Dim fMultiply As Integer If SITE_AREA_FY > 0 And DT_PERCENT > 0 Then fMultiply = SITE_AREA_FY * DT_PERCENT...

Hi I have a problem with an Order By Clause. Basically, my database holds records of sites in the UK, and I have a select query (qry_SumGIS3) that opens up a summary report (rptSumGIS3) when a button is clicked on the menu page. The report opens perfectly, showing me all the information I...

Hi guys. Not sure how to do some calculations for a form I have. I have 10 objectives per site, and each objective a different number of measures. For example, Objective 1 has 2 measures, Objective 2 has 6 measures etc. Each measure has a weighted score (which is measure score x measure...

Hi I will give you an overview of what I have. I have a database that records sites in Blackburn and each site has a unique ID (RTP_ID). Each site has 10 objectives with 25 Measures in which the sites are scored against. Objective 1 has 2 measures Objective 2 has 8 measures Objective 3...

I have a search button on my menu form that, when clicked, asks the user to enter a desired Reference number they wish to search for. This works fine when it is a Reference number that is stored within the database. I have tested it to see if it works with reference numbers that do not exist...

This has been posted before, but I need to get an answer to it as it is for a tight deadline project at work. I have a Add New Record button, and code in an OnClick() event, as shown below. The thing is, when I click the button, it doesn't execute the DoCmd.GoToRecord , , acNewRec line, and I...

I would like to know how to write code to open up my main form (FRM_PRIMARY) on a new record so that the user can add a new site without clicking another add record button. Also, I have a button that will search for a certain record (using either the ID or Postcode of a site). How can this be...

Hi, I have another problem with my Access database now... I am trying to disable fields when a certain value is chosen. I can do it for one field with this code: If ALLOCATION_LP = "Other" Then OTHER_ALLOCATION_LP.Enabled = True Else OTHER_ALLOCATION_LP.Enabled = False End If That one works...

Hi. I am new to this site, and fairly new to Access itself. I am currently designing a database for work that allows people to store information about sites around Blackburn. There is one main form and 3 subforms inside of it. On Subform Yield Assessment, I would like the database to...