Search results

  1. Jaymin

    Lost with form design

    Hi all, I need a little help with form design, I have several forms where i enter information eg. a enter staff form, delete staff form. is the best way to have a seperate form to add staff and a seperate form to edit/delete the staff, or should i just have the one form that does the both. or...
  2. Jaymin

    remove list item from combo box after use

    RainLover, Thankyou for a quick reply, I will have to try it tomorrow, bed time form now.
  3. Jaymin

    remove list item from combo box after use

    Hi can anyone tell me if it is possible to remove an list item from a combo box list after it has been used. What I am trying to do is use a combo box that has a list of questions, after the user selects a question from the combo box list and answers the question when they reselect the combo box...
  4. Jaymin

    counting items in combo box

    Thank you Some and Monty251, for your reply. But after having a further thought on the matter,I remembered a thread http://www.accessforums.net/forms/change-filter-cascading-combo-box-25322.html that would cover what I was looking for Jaymin :confused:
  5. Jaymin

    counting items in combo box

    Hi all, Hope someone can put me straight, i have a form that has three cascading combo boxs, plus a subform. the third combo has a list of questions, and you put your answer in the txt box in the subform. What has to happen is that the combo box has a number of questions and each has to be...
  6. Jaymin

    subform data not visiable when transfer back to main form

    Hi Pat, Thank you for your reply, I think that i am going about this wrong, my relationship table was incorrect i have fixed that so i do not have to have the form in the way it was set up, thank you sorry for wasteing your time have a safe and happy festive season Peter :)
  7. Jaymin

    subform data not visiable when transfer back to main form

    I do not know if this is normal, or there is something wrong. I have a simple form with a subform, the main form has a drop down box which i select a name from the selected list, then i enter the subform it has one txt box which i enter data, i tab, and the focus is on a button on the main form...
  8. Jaymin

    goto a form from a subform when in error

    must have had a brain snap, all i did to fix this was to add "me.undo" and everything worked fine Peter
  9. Jaymin

    goto a form from a subform when in error

    Hi all, I have a form with two cascading combo boxes and a subform with a txt box, after you enter data into the cascading combo boxes the focus goes to the txt box in the subform, the data that is entered into the subform comes from serial numbers from two sets of clothing only four numbers, if...
  10. Jaymin

    resetting a txt box contents after error

    Re: resetting a txt box contense after error RainLover and Bob fitz, Thanks for your help Peter
  11. Jaymin

    resetting a txt box contents after error

    i have a txt box which is a required field, i have a dlookup to check if this data has already been entered, if not it continues on if it has the focus is reset to that txt box, but the entered data is still able to be seen, is there a way of removing this data so the txt box is clear, i cannot...
  12. Jaymin

    Getting the computer user name

    Galaxiom, Thank you for your help and time, also a quick responce. Peter
  13. Jaymin

    Getting the computer user name

    Jdraw and Galaxiom, Thank you for your replies. Galaxiom can you show me how to program what you have suggested Peter
  14. Jaymin

    Getting the computer user name

    Hope someone can help me, i want to get access to tell me who has loged onto the computer, i know in excel there is a code GetXLUserName this gives you there login name, Peter :)
  15. Jaymin

    Trouble with deleting a record with vba

    joeKra, The code you gave me works just find, i would like to thank you very much for you time and effort in helping me with this. Peter
  16. Jaymin

    Trouble with deleting a record with vba

    Thanks JoeKra, I have attached the form, basically i have two cascading combo boxes, the first selects the station, the second you select the staff at that station, this is achieved by the staff combo being filtered by the first station combo box. I have three buttons, one to close the form...
  17. Jaymin

    Trouble with deleting a record with vba

    Hope you can help,i know this should be simple but it is bugging me, I have a form with a two cacading combo boxes, i have a button to delete the record, filtered by the second combo box. i use DoCmd.RunCommand acCmdDeleteRecord when the button is clicked. it delets a record but not the one...
  18. Jaymin

    how to tab to a buttom on the main form a afterupdate event from a subform combo box

    sorry i did not know about cross posting will not do it again, John big booty i have read that post but i cannot get it to work. I would assume that i should use "me.parent!controlname" to get a afterupdate to point from a combo box on the subform to a button that is located on the main form...
  19. Jaymin

    how to tab to a buttom on the main form a afterupdate event from a subform combo box

    I have a form with a subform, when i finish entering the data of the last combo box of the subform i would like to have it tab to the exit button on the main form, it sounds easy but i am having alot of trouble doing it, can anyone suggest something for me please. I have looked at the syntax for...
  20. Jaymin

    cascading combo box subform data filter

    Rain lover, Thanks for you reply, i did not describe what was going on properly, and yes that is how i have done it, what i want to happen is when i requery the combo box after creating a record, is to filter that item from the list so instead of 4 choices there would be only three, till no more...
Back
Top Bottom