Search results for query: *

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

Hi the senario is this, On the last day of the month i would like a query to be run and the results sent in an email to various people in our company... I have no idea how to get the query into an email and get it sent on the last day of every month, could someone help Many thanks Andy

Hi I'm not too sure if this is possible, basically one a fixed day of the month i'd like the results of a query to be emailed out to certain people in our company. The system we use access for handles rebates i have written several queries that examine rebate period spend against sales...

My thoughts exactly Golom on both counts ;)

maybe try max(Date) , would only return the most recent, or possibly change the date to time then it would only return the MOST recent. Apart from that i'm afraid i can't be of much help i'm usually the one asking for help in this forum ;)

Thanks for all the input , think i've found the problem. One group of users didn't have the permission to delete, just read and write. which would explain why it was locked, however the entire backend was locked and not just the record they were accessing. I've checked all the forms and all...