Search results

Hi i want to develop a very basic 1 table database that has a list of contacts in, (i can do this part) i need then to find a way to do searches on this database from a webpage, the search should have a text field and a dropdown to show the available fields to search and the a search button...

Hi i have all of that working now, so thanks very much for that, but is there a way that i can enter a name into a field where someone has left that field blank so for instance if in region i had a drop down box with the south, north etc but the person that filled out a record left that field...

hi any chance of an example as i am realy new to this. thanks for the reply regards chris

Hi i need to create a weekly report showing the amount of records entered into the database and the value and also need to sort that by region the fields i have are Enquiry recieved date Region Value i also need to create the same report for monthly everytime i create a report based...

ok thanks guys the code cant change for now as it is referenced by alot of other code i have, so i will need to put it in brackets. i made this database when i didnt have a clue of the concept that i should use in access, but there are alot of people using the database so it will be a major...

all of the code Private Sub Co_ordinator_email_address_AfterUpdate() If Me.mortgage_co - ordinator.Value = "name" Then Me.caption = "name@email.com" ElseIf Me.mortgage_co - ordinator.Value = "name1" Then Me.Caption = "name1@email.com" ElseIf Me.mortgage_co - ordinator.Value = "name2" Then...

i have a word in the code i am trying to write that has a - character in it (ie co-ordinator) and when i type in the code it spaces the word out like this co - ordinator the code i have typed so far is If Me.mortgage_co-ordinator.Value = "name" Then Me. but as soon as i hit the enter key...

allow a user to override a calculated field Hi all i have a field called commitment fee and it has a calculation of =-IIf([Type of finance]="Term Loan",-([Total amount requested]*0.015),-([Total amount requested]*0.01)) but i want to allow a user to enter a manual amount of money into the...

thanks again solved another issue regards chris

hi i have looked through access 2000 and dont see onCurrent command, is this a command for later versions like xp and 2003. or am i just being blind i have done a screenshot of the properties box i have in 2000 thanks chris

thanks guys go it to work i am quite new to access and will probably be asking many more questions chris

thanks but how do i specify a blank entry ? as a blank cell is not equal to 0 is it

Below is the code that i have made to grey out certain options when you pick certain names in a field the only issue i have is when i want to look at records already completed, ie if combo box 2 says residential, it should not be greyed out but when i am scrolling through the completed records...

hi all i have created a database but didnt insert any default value at the begining and now i have blank cells in the table rather than £0.00 how would i go about querying the blank cells and then populating them with 0.00 thanks in advance chris

sorted Thanks Guys the code was =IIf([Initial valuation]<>0,([Total amount requested]+[text3])/[Initial valuation],"") all working nice thanks very much, new to access chris

hi i have a text field in with this calculation =([Total amount requested]+[text3])/[Initial valuation] it displays a div/0 error which i want to remove, i know i need to put this calcualtion in an iif statement but whenever i try and make the formula it never works =iif([Total amount...

docmd i use an event procedure on the "on open" of the form do to this open your form and double click the square between the 2 rulers this will bring up the form properties window, select the all tab and scroll to find On open, once you have done that click the ... on the right of on open...

i have a database form with a field called commitment fee in that field is a calculation =-IIf([Type of finance]="Term Loan",([Total amount requested]*0.015),-([Total amount requested]*0.01)) But sometimes i want to be able to override this and input a different value like 0.00 if the amount...

update hi ill try and explain a bit better i have 2 tables Main_database_fields and Security_ 2_3 in Main_database_fields i have a field called Estimated_security_value and on Security_ 2_3 i have two fields called Sec2_estimated_value Sec3_estimated_value i basically need to add the...

main_database form i have a field called coordinators this field has a list of coordinators in a drop down box and i also have a field called coordinatorsEmail what i am trying to do is when the coordinators field has a name in it i want to tell the email field to input a certain email...