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

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

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

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

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

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

hi all i can do simple additions in access but i have been asked to calculate fields in different tables all i need to do is i have 2 tables in my database Table 1:main_database Table 2:Security 2_3 and i have in table 1 got 1 field called Estimated security value and in table 2 i have...

hi i have 2 tables with corresponding forms called Form 1: main database Form 2: customer 2 form 1 has a primary key field called: Case id (autonumbered) form 2 has also a primary key field called: Case id (nuimber) i have a check box on the FORM1 to open FORM2, but what i want to do is...