Search results

  1. R

    Happy Birthday Selena

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

    The option button

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

    primary key

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

    The option button

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

    Text hovering over Textbox

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

    How as the forum helped you, and Who has influenced you the most!

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

    How as the forum helped you, and Who has influenced you the most!

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

    How as the forum helped you, and Who has influenced you the most!

    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?........
  9. R

    How as the forum helped you, and Who has influenced you the most!

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

    Text hovering over Textbox

    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!.... :)...
  11. R

    Text hovering over Textbox

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

    Sendkey {End} - not working for me

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

    blank combo boxes used for form selection

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

    Only one option

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

    Sendkey {End} - not working for me

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

    DCount syntax problem

    Glad to hear you got it sorted out.
  17. R

    DCount syntax problem

    Hi Stretch Sorry to hear you're still having problems - Without a copy of the DB it is impossible to test the SQL, but some things I have noticed... The SQL ..HAVING (((tblEmployees.LeftDate) Is Null))... part of the statement restricts the recordset to employees that have not left yet (which...
  18. R

    Tests

    I had a go at these and agree with Pat, some of the questions/answers were a bit dodgy to say the least! Got 90% or better in every one of the tests - both Fundamental and Expert... Come on Uncle Gizmo - bear your soul, and your score! You know you want to! :-) Rod
  19. R

    DCount syntax problem

    Hi Stretch I think your problem may lie in the ...AND [LeftDate] is Null statement. To test this idea, delete this part and see if you get a value returned, if it does, then try using ...AND ISNull([LeftDate]) instead. Access can be very "picky" when using Null. HTH Rod
  20. R

    One event two IF statements

    Bob's solution That was class! - I really liked that... The reason for posting is that the original post did not say why it would work - and because of that I think it has been dismissed. Option boxes (and the like) store their current state as 0 or -1 (True or False) and as such would apply...
Top Bottom