Recent content by pleeson

Thanks all, I have tried all the above in turn with no luck. God, This sort of works but gives a value of 1 to the Project_Order no matter which record you move up. Thus you end up with records with the same value of 1. Ian, I get an error on yours but I am looking into that. It could be that...

I think this may be impossible but I am hoping it isn't :) Have any of come across a way to Manually order a continuous form. The way I would see it working is to have a column in the table called sort_order and two buttons on the form called move up and move down. Once clicked the sort_order...

This is some code from a DB I have written. Sorry if the code is a bit messy but this will work. The code below applies to two buttons on top of each other. doorrefass and doorrefdesc. Doorrefass is initially visible and when press sorts the column I place in the code. In this case Door_Refs...

Hi, I have a DB which is an Access 2002 FE and SQL BE. The DB consists of Door schedules for different buildings so doors can repeat for each floor so I need a repeat function that copies a main Schedule to a new record and all the underlying records of that particular record to the new record...

I don't know if you have found a solution to this but try looking up 'mousehook' in google. or go here http://www.lebans.com/mousewheelonoff.htm This involves some VB code (I can post if needed) and a dll file that goes in the winnt folder. I have been using this for a while now it works a...

Hi all, I am after some help with my form/database. The attached file is a screenshot which may give a better idea of what I am trying to achieve. Currently I have three tables that I have set up to solve this problem. JOBS, CONTACTS, and JOBS_CONTACTS_LINK. I have set up a query that pulls...