Search results

Thanks but i cant use code. im pretty sure there was a very easy way!

I have a form which I need to make read only. On Access 98 it used to ask how I wanted to open and view the form in edit mode or view. I cant find this option in 2003 anyone got a quick answer? Many Thanks

thanks, anyone want to expand on this as i havent a clue! each time i use the time stamp tool i want to have another column display the time an hour in advance i.e column One,TIME Now 11:23 & column Two time delivery to be completed 12:23 Any help is appreciated as this is used in a hospital...

Hi, ive searched the forums for this but cant find anywhere. how can i add one hour onto a time stamp please. many thanks:confused:

read this, the answer is here http://www.access-programmers.co.uk/forums/showthread.php?t=105289&highlight=samzie

cant get it to work on 2000, anyone have any ideas?

it works! whooooooooooooooooooohooooooooooooooooooooo! yessssssssssssssssssssssssssssssssssssssssssssssssssss! rockman is god! i'll start work on the database tommorow! i'll keep you informed how it goes! YES! YES! YES!

i paste the text in, press enter and the cursor moves back to the original box, i press enter again and it moves to the name field and so on. anyone else tried this?

the form doesnt move the text into the fields for me. i think there must be something wrong with the code. you are right rockman. the information is always in the same format everytime. information is collected from text fields on a specialist database then transfered onto outlook...

http://lazybase.com/ :D

Hi Rockman, Thanks very much for the post and the code you produced for me but it goes beyond my current knowlege of access. I've tried for an hour to replicate what you posted but I must be missing something. Would it be possible to make me a small db with the code you have made so I can have...

thanks i'd be really greatfull Samzie

Sadly no, we use a shared drive to keep the access file in. this shared file is only accessable by a few people for data protection. we are bound by the data protection act and we have to ensure that very few people can access the information we generate. for instance. if you had a daughter...

thanks very much, kieth i really wish its was that simple, perhaps i should eleaberate a little. we have around fifty wards who email requests for patients records to a medical records library. they each can send around 10 requests per day each. none of the wards have access. the cost of each...

Hi all, I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same. name ***** Date of birth **/***** consultant ****** ward BLA ****** Is it possible to copy and paste all the information in one go from the email...

Thanks Razorking, i was looking for a few idea's or pointers anything would be an advantage really. samzie

I'm trying to decide if its worth making a database to get rid of paperwork and excel sheets for an annual leave database. Currently it takes twenty minutes to do all the calculations and paperwork for each holiday. In fact its a nightmare, I spend more time colouring in annual leave calenders...

ken, you can marry my eldest daughter, i will give you ten thousand sheep and my grandads war medals. your name will go down in data protection act history. im not sure why that worked but many thanks yipeeeee!

could someone please help me. ive tried all sorts of things and now im loosing the will to live. under the data protection act i have 40 days to produce requested files in a hospital. the problem is that my little database that has been working away for 2 years is not capable of flagging up any...

ive tried all day to find an answer to this problem. if anyone could help i'd appreaciate it. it would mean a lot to a good cause because it helps identify pateints on a hospital system faster. many thanks.