Search results

There are 5 scenarios that can come out of mixed - housing, transport and government is 75%, town centre is 25% and employment is 100%. But when nothing is picked in the null field, i don't want anything to be placed in the mixed_ratio field.

I have actually sorted it now. I was trying to use the And function in the Dlookup but it wasn't working, but I realised that I hadn't put the correct parenthese around it and now it works perfectly!

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

Im not sure what I have to do. The locations are in one table, the chars are in another, and the density is in a third table, but with the id's from the location and char tables as combinations...

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

I think you were right, because I have changed it to a single form view and it works ok now. However, I want to be able to use this as a sub form on my primary form. When I open the form in form view, it asks me for some data that is used in the dLookup. This form (frmResponses) is going to...

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

Its a database that is being used by my company to give to a council, so i would like it to work obviously. The number of questions will never change, neither will the answers or the scores. Thanks for trying to help me

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 put it in the code but it doesn't disable them. However, I think this may be something to do with the fact that the unbound text boxes are locked; 1 is locked so no one can change the value after the calculation has been done and 1 is locked so no one can change a look up value...

Thank you :) Another question regarding the enabling of text boxes, can an unbound text box be added to the code above? I have another text box that is unbound and is used to just do a simple calculation between two text boxes (which are affected by the check box). However, I would like to...

The check boxes is unbound, but it affect more than one text box (this particular one affects two text boxes). And sorry wazz, I meant to put "When I open the form to enter a new record, the default is not checked" which is what I do want. However, when I open the form again to that (or any)...

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

You are a complete genius! Thank you so much! :D

I have tried both suggestions and it still comes up with the error. All I want to do is let the user pick a percentage in a drop down menu and then have them click a button for it to multiply what they have chosen by the site area (which is pulled from a different form by the way) to create a...

Thanks for the post back. I have just tried what you have suggested and, unfortunately, it still creates and error on the same line. And yes, they are the control names.

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

Thank you for that! It seems to work ok now.