Search results

Coool Wow, nice one rickster!! Awsome stuff, how did you find that?? never seen it or even heard of it before. Its worked a treat though. Thanks dude!! :D :D :D :D :D :D

Thanks for the suggestion Brian but I dont think that would work for what i need. I need to find the second highest number AFTER the first highest. So if there was mutiples of the biggest number your system would not work would it? Also i dont know code!! J Man

Hi again I have used =MAX to find the largest number in a range. BUT... is there a similar way of finding the second or third or fourth (etc) largest number in a range? Thanks

Good call! I must have gone retarded for a moment to miss that one thanks

Hi everyone, What formula should i type into a cell to make it display the biggest value present in a set of numbers across a cell range. Each cell in the cell range(a column) contains just one number. Thanks

Hi guys, I have basic knowledge of microsoft Access and do very little with script and coding. I also design websites and can code in HTML and have good skills in Dreamweaver etc. If I want to create a database driven website is Visual Web Developer 2005 a good software choice?? The way I...

Thanks again Rich

Hi everyone, Is there a simple way of allowing users to press a button on a form that will print all the form data but in a report i have deisgned?? Thanks James

Hi guys, I have created a form based on a query that prompts the user to enter a persons name. Once entered, the persons data appears on the form and some other related data appears in a subform. However, I have found a problem that occurs when a name is entered that doesnt exist on the...

Thanks for the advice and also adding that link on ;) Im not too savvy with script but I will give it a shot! James

Hi everyone I have a database accessed by alot of people and have recently added user level security so that i can monitor who is logged on etc. Another thing i need is the ability to update the design of forms whilst people are on the database. To do this i planned on creating a replica and...

What would this involve? Would I have to split the database? I only want to do whatever it takes to be able to see names of users logged on! Thanks for the help...

Hi everyone I have searched for help on this forum and all over for a while but cannot find the help i need. I have a database stored in my user area on a schools network. Other users around the school access the database by clicking on a shortcut to it found on their start menu. The database...

Each of the tables are updated once at the beginning of each academic year. After that they are only used to view data or added to when a new student joins the school.

Im afraid im not replying to help you with your problem but thought you might be interested in looking at a piece of software called Microsoft Project. It does everything you require and much, much more, including allowing you to transfer your project to other software and systems.

Hi everyone I would appreciate some help redesigning a database structure. Currently the database has a table holding students personal details. Linked to this table with a one-to-many link is a table holding subject reports. Also linked to the student table are two other tables holding prior...

no offence intended, but the description of your problem makes almost no sense to me what so ever!

Hi guys I need some help working out a way to archive records. All i really want is a button on a form that when clicked deletes the record currently displayed on the form from its table and moves it to another table that i will call 'archives'. I think it might have something to do with using...

Hi guys I need some help working out a way to archive records. All i really want is a button on a form that when clicked deletes the record currently displayed on the form from its table and moves it to another table that i will call 'archives'. I think it might have something to do with using...

Hi everyone Is there a way of setting a forms propertie's so that the form always stays 'on top' and visible, even if it isnt the focus. The only example i can think of to explain what i mean it the msn messanger window that you can choose to 'stay on top' even if you click on a window behind...