Recent content by tbcwarrior

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