Search results

.text didnt work but the answer from from wh00t worked thanks a lot to both of you for your help

I have a problem. a user selects a values in an cascading combo. when he reaches the last one he clicks on select. this gives him an msg box telling the code of the last combo. what i am trying to do is to give him an error if there is nothing in the last combo. i.e it is blank which means the...

how do i add an object in the object browser? problem i get an error saying method not found in form. i checked the object browser and it was not in there how d add one

This is probably a silly question. Does anybody know how i would increment the alphabet. so from a to b etc

Thanks for the help pat. THe problem is i have atleast 69000 records. the combo box does not display all of these. what i want to do is to let the user enter the value in a text and then check it against a query to see that it exists. the code above does not seem to do that. is there another...

thanks a lot the help is really appreciated

soory mate i understand the code. but do i have to declare txtcode and code before this code.

i have a text where the user enetrs a code. what i need to do is to check that the code he has entered is correct by checking it with the codes that are held in a query. ho would go about doing that.

Didnt work mate still does the whole routine before falling down.

Problem is that it does jump to the error function immediately, instead it carries out the import command then generates an error. import: 'Show the Open common dialog box CommonDialog2.ShowSave 'Return the path and file name selected or 'Return an empty string if the user...

How can i make the grey button colourful with a label on it. So it would be a red label with exit written in the middle.

Thank for your help . i used the Nz option

I ahve a calculation on my form that is formed by data in the form and subform. I have a total value at the end that adds together all the values. I do not have to enter of the values as they are not compulsory. the problem arises as i cannot a total displayed because one of the values is...

COmbo Box. I have solved the problem anyway so thanks for offer of help.

I have this peice of code in my database. rstUser.moveLast. i dont wnt it to fgo to the last record i need it to goto the record i will select. how would i go about doing that.

Tahnks a lot that solved the problem

I would like to create an addition in my form how would i do that. I have some subform that have numeric values filled in them. I want to transfer these down the page and update as more values are added in the form. I have three subforms with different sets of numeric values. Each will be...

I am very dunb when it comes to vb so i would appreciate this code being deciphered. i am gussing it takes a value and adds it somewhere. Option Compare Database Private Sub SelectSRO_Click() Dim SRO As String Dim currentRec As Long [Form_Add Claim].FLT_CODE_FLT_CODE_ID = Me!SearchComp.Value...

i think i have it working. you have to create a query with the details for the combo box as the combo serches a query.

Probably a silly question but what does control mean in the code below. 'Event runs after the SearchAssembly Control is Updated 'Requeries the Control named Component (Possibly a Combo or List Box Me![Component].Requery What i am basically trying to ask is where oes the control come from