Recent content by arobbo

Your a star Remou !!! worked like a dream Many thanks everyone for your input !!!

Hey guys I've got a temp table that I want to organise by three headings. terms, Special Offers and Contracts Thing is i need to show all the data in the able and just bring the relevent one to the top. I'm using a web page to display the data but is an access database and hopefully the...

changed the name of form .... still get same error message

tried that , still getting same error message ... :(

sorry didn't want to post the whole lot .... please find it below <% Dim adoCon 'Holds the Database Connection Object Dim rsStaff_Sickness 'Holds the recordset for the records in the database Dim strSQL 'Holds the SQL query for the database Set adoCon =...

the bit that runs that function is as follows <input type =checkbox name = halfDay onClick="checkBox()"> rest of HTML hasn't been changed,

Hi , the code below is working fine at home but when i host it on the company intranet it produces a runtime error, could it be an issue of browser compatibility, i'm not sure what version of IE we are running at work , but can anyone see anything in the code below that might classicly cause a...

you little beauty much appreciated ;)

hi , afraid my javascript is quite basic (when i was at uni many years ago it appears i didn't pay enough attention ) i'm trying to do something very simple but getting no where fast ... basically if a check box is ticked i want it to change the value to 0.5 and if it is unticked to run a...

Hi , i've got a simple web (ASP) front end connecting with an access database , can insert , update and delete records no problems but when i try to view a linked table that is linked its not so happy , anyone know if i would need to open a second ado connection for the database i want it to...

in the UK we use postcodes to determine the exact address, i've got the postcodes of all of our ecommerce orders and want to plot a scatter graph to see where the main proportion of our orders are from ....

Hi everyone, anyone got any idea of any good programs or something i can add on to an access database that will calculate the distance between two postcodes ? Cheers Andy

Anyone got any ideas of how i could round up the values of a calculated field in a query. Basically i pull some fields out of an external database do a calculation on them and want the outputted figure to be in pounds only and not pounds and pence or 1392.348835583 Can anyone help?

Thanks for your help guys almost there i think, i'm afraid my VB isn't very good at all. The Docmd.SendObject seems perfect. i was thinking something like If date() = 31/12/2005 OR etc etc Then Docmd.SendObject ......... but where abouts would i put this code so that it would always run?

any ideas what sort of VB code you'd write to activate the query on the last day of the month ??