Search results for query: *

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

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

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

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?

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

Help !!! i have a database which has a back end (tables) and then many users accessing it through a three different databases. Front end databases... My problem is with multi user access. When someones got it open no one else can do anything. I've looked at the advanced options in Access...

having a few troubles with validation rules and the expression builder. basically i've got a form with a drop down box and a button, if nothing has been selected i would like an error message to pop up, so far i've had no joy with the validation rules for the combo box, anyone got any ideas...

Does anyone know of a good way to have a button that exits access. The exit application button leaves access still open, i'd like a button that when clicked exits access. Anyone got any ideas ? Cheers Andy

hi the senario is such , some of our suppliers form part of groups and when calculating the total spend with each manufacturer i need to sum the invoice amounts based on a man_Code for a given time period. Now if i want to add a second table named associate suppliers which has the man_Code i...

Hi i've got a simple query that pulls data from two tables and displays the Distinct() manufacturer_names , date_from and Date_To i'm using this to populate a list box but i want to use all three fields in a calculation on a further form. I was thinking if i could add a field from the query...

This might be very simple, i've read a lot about DDBMS but am unsure whether you can make a database built in access able to have multiusers using it at the same time... anyone got any advice/ideas cheers Andy

Hi i read in a book that "any query expressed using a HAVING clause can always be reqritten without the HAVING clause" any clues as to how you could re write it e.g. would you need to use a subquery etc ... my book doesn't elaborate. basically i can't use the HAVING clause as the aggregate...

hi basically i'm trying to display the purchase order of the last order in a given time frame, i'm finding that using max(order_Date) isn't working , is there a way i can use max(order_Date) in my where clause or something like Where (order_Date) is the greatest ???? anyone got any ideas

is there an easy way to display the result of a query only to do decimal places where the query has a calculation in it without using a form..... senario.... i've got a query that calculates a percentage and i would like to present it to two decimal places..... anyone got any ideas??

hi i'm trying to find any easy way to customise the search button you can add to a form. Basically i would like to always default to search in one field and always search any part of the field. Anyone got any ideas of an easy way to do it i don't want to rewrite the search function in VB...

i posted this earlier in another forum , wasn't sure if i was actually posting in the correct forum for the problem, appologies for double posting, just wasn't sure which forum to post it in"" Further to my earlier problems which i thought had been resolved, i'm still experiencing order errors...

Further to my earlier problems which i thought had been resolved, i'm still experiencing order errors with records being displaid in my subform..... i don't really understand how it is currently ordering my records but its not the way i want them ordered. Is there a possibillity that the...