Recent content by claddagh

Autonumber Ok thanks, I`ll have a search and see if i can find anything. thanks for the advice Max

Hi guys, Just a quick one ( I think ) I have a table which already has an autonumber ( the id field ) But I need to create another field also with an auto generated number which will generate reference number which i need to start at a pre-defined number. The problem is, im not allowed to use...

Looks Good Thanks for that. Looks like itll do the job. I`ll test and get back to you. Max

Hi Guys, Just a quick request for a bit of help. Tries a few things but didnt work. I have a form which has an employee start date. What I need to do is work out the holiday entitlement of each emplyee. The math behine this is, if they have been here less than a year, we do the following. 20...

Works now ghudson, did what you said, called the function, as names in the above post, and now that i have done that it works a treat. Thanks for pointing me in the right direction. Max

Confused. ghudson, I thought the module WAS the function, guess i was wrong. I`ll have a look through my books and see what they say about calling functions. Thanks for the advice.. Max [UPDATE] The code is as below Option Compare Database Function mcr_archive_data() On Error GoTo...

Should work Colin, Looking into what you have said, that looks as though it should work fine. I`ll have to test to see if this would be the case, but I dont see why not. Thanks for the info Max

Works Andrew, Thanks for that, it works a treat. Im not sure about the re-query thing though, as I wouldn`t want the archive but reset to no, even if they cancelled. I`ll look into that more, and see what the users want..... Thankyou once again, Max

Hi guys, Just a quick one I`m hoping you can help me with. I am just about to start a new DB, but there are a few things I need to sort before i start. I am working with a quotation system etc which will require the use of unique IDs... eg 000123 then 000124 etc, this bit is not a...

Switchboard Modest, I too myself am not too keen on the switchboard, I find it a little bit on the limited side, but not being that clued up on access, I have no choice at the min, as its easy to implemet and use mainly. Once I have the knowledge and the time, the first thing to go will be...

Os Modest, We are only using the windows OS at the min here anyway, so that shouldn`t be a problem. Thanks for the heads up

Another Prob ghudson, Still looking into the above, but i`ll test that later.. At the min, back to the archiving prob i had. That code you gave me works a treat, but when i assign the switchboard button to run code, then module name. When I run the form switchboard, and press the button to...

Thats what I was thinking Ken, Thats kind of what I was thinking, and now I have thought about it a bit more, it would make sense, as This could also tie up reference numbers, on all tables, so that I would always have a unique reference number...... If anyone else has a though, please let me...

Solution ?? For anyone else with this problem, I have found a post on another forum ( I know, sorry guys ) that seems as though it will fix this problem ( Link provided ) Not mine, so this guy must get all credit...

Hello all, Im trying to distribute my program using access runtime. ( which I have ) But I cant find the Packaging Wizard that I need to create a distribution file. Im sure I have the developer extension, as I have the Full Blown office 2k3 pro. In my old office 2000 developer, this wasnt a...