Search results

yea i would do that but if someone adds new job u would have to add more code for every job

hi, i have list box and the source coming form Query. i want when i click on one in list box want it will show [faults] field in textbox from query the field [faults] is a memo can someone help me __________________ David

rich, hello i put isnull in criteria and did not work it does isnull and then i tried isnull([fieldname]) and still does not work do u no what i'm doing wrong can u show me eg

only show one have have nothing value hello, i have a querie, haves jobs information in it and one field called "Date Finished Fixing" i want the querie to only show the ones with out dates put in so if they =nothing i don't no how to do it can someone help

grnzbra, thing is when i choose one from the Combo box it is unhiding other fields and i want the fields to be wre the Combo box is, so i want to have a field hiden behind it and when i choose one from Combo box i want it to make that many textboxs visible i have got the field to...

jkl0, hello i tryed making it unbound and tried me.nameoftextbox.SetFocus me.nameofcombobox.Visible= false comin up with same crap as before You must save the field before you the GoToControl method, or the SetFocus method. execute the GoToControl...

hello, i'm trying to make the combo box hide after i choose one out of combo box, eg: i have in combo box 1,2,3,4,5,6 and when i choose 4 i want it to hide i have tried me.nameofcombobox.Visible = False but does not work because it has the Focus so i tried me.nameoftextbox.SetFocus...

Junkee Brewster, ty for trying to help but i find out how i can do it i just was playing around and got it to work first i made marco to open form and go to new record and then tryed to make it put the client number in after it want to new record i used this code to make...

i wanted it to click on one of clients name from list box and click button to open form "job information on a new record and put the client number in the text box on the new record on form i can't realy make it so i just click on names and it opens form because i have other button on form other...

Hello everyone, i have 2 tables, table one =client detials table two = job information both have field called ClientNumber in them and have Relationships i have a form with list box in it with ClientNumber(hidden), Surname, First name and i have a button and i want when i choose a name of list...

nope but ty for trying all i want is if i click on one of them names in list box and click a button to open form "job information" make new record and put the clients number there all ready on the job information form ty for trying to help ______________ david

hello everyone, i have 2 tables have Relationships with each other and i have a form with a listbox and has the surnames from table1 in it i want a button to open the job information form on new record and i want it to have the client number in it all ready if i click on one...

To all, yes ty so much for your help with this __________ David

Melax29, all the feilds that are yes or no if no the feild next to them to be not use able so u can't put data in them ones plz help and ty for helping me _________ David

Melax29, i did what u said but it still does not do anything i think i might be doing it wrong or something Private Sub Check26__AfterUpdate() If Check26 = -1 Then Case_Detials.Enabled = True Case_Detials.SetFocus Else Case_Detials.Enabled = False End If End Sub it does not do...

lock textbox if ticked NO on other field plz help I'm doing a project for Tafe and i have some yes no questions on my form and a text box next to each one for detials if the answer was no for tick box i want the text box not to be able to write in can someone help me plz ______________ David