Search results

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

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

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

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:

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

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 :)

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

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

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

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

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

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

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

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 :)

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

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

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

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

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

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