Recent content by Rod D

Many happy returns Sel :) Hope you have a fantastic day. Regards Rod

Hi Peter Sorry for not replying sooner - I've been away. What I had in mind was storing the state of the option group in the table as an integer (1-4 say) and have the option buttons labels have the Good, Fair, Poor, Unknown text. That way, whenn you scroll through the records, the option boxes...

To add to Ken's thought. You can add an index to fields that are not a PK and set them to "No Duplicates". There will be a small performance overhead in maintaining the index, but for most apps this is not worth considering - you do get the bonus that retrieving and sorting on these fields are...

An option group is as close as you will get Peter The closest you can get to what you have asked for is to create an option group. Look in the toolbox. Assuming you have the wizard enabled, it will guide you through creating it. What it will do is allow you to create as many buttons/radio...

Sam I will have a think on this over the weekend. Monday is a holiday over here, so will be away from the machine, but will try and post back on Tuesday. I have some ideas, but want to test them first... Regards Rod

Like what you have - playful with a latent warning of potential malice....:)

Like "Gasping, wheezing, out of breath, slowly expiring....Kitty" Only joking!

Another thing Sel, you changed your avatar to those "adorable" kitties, but left the "Hissy Kitty" tag line - surely this needs to change to something equally cute?........

Careful Sel - this will get racist.....

It's a pleasaure - I hope it is of value. I was off reading "War and Peace" (both literally and figuratively) in the 'Cooler......haven't read a spat like that for a long time - and who said it would'nt get de-railed?...........oops - sorry - I'm doing it now...Butting right out!.... :)...

Hi Sam I have some ideas here, but can you confirm the following please: 1) The field labels that you have are currently in the form's header section - this is where they should be for a continuous form. 2) You would like a single text box that gives information for the current field...

OK - Plan "B" I tried your code and noticed that if the field contents were highlighted, the focus stayed on the button - not the memo field. I ended up changing the {End} to {F2} (edit field) and it worked, so give it a go. I THINK the reason is because the {End} key is being treated as a "go...

Hi Stretch Look in Martin Green's examples - http://www.fontstuff.com/access/acctut19.htm Does everything you ask for...........and more! Hope this helps Regards Rod

Have a look at this link http://www.access-programmers.co.uk/forums/showthread.php?t=104581 I posted an example in this thread (you will have to go almost to the bottom to find it...) where an option group was assigned differing values depending on which button was pressed. There is nothing...

Hi Dave Try SendKeys "{End}",True which will force the keystroke through. Just a thought... Regards Rod