Search results

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

Sorted Stehen, Thats exactly what I needed. Thanks Max

Hi guys, I have already a database functioning how I want it ( which is basically an installations and costings database ) I have now been asked to create a database that can do things like marketing reports, sales costings and advertising tracking etc etc. The thing is, if the customer...

Hi All, Just a quick one. I have access 2003 installed, which I use to make systems ( doh ) Anyway, I have just installed Access Runtime on the same machine so that I can test my databases on the runtime version to make sure that all works ok. However, I have installed several times now, but...

Fixed MS didnt say squat about this. Anyway, I have found a lway round this. I have made the Input mask as follows; not ideal but does work. >&&&&&&&;;_ This way they can put in the require postcode if it is under 7 chars long. e.g. M1 1NH I have just put a note beside the field in the...

Will try this ghudson, Once again, thanks for the help. Will try this out later and let you know how it went. The thing that still confuses me is the reference to c:\ Different machines have differnt install drives, some are c:\ some are F:\ and some are G:\ God knows why this was done, but I...