Search results

hey mohammad. thanks for all your help but i'll call upon your skills with another prob. It turns out that the avg currency value that was being calculated on the currency1=currency2 and currency2=currency3 criteria was what was giving the trouble. I only had 2 records in the db and only one...

yes mo. it is Im sorry to be asking for so much help I modified it and placed an unbound txtbox which acts as the search box. there is also a unbound listbox on it the list box shows Id number Surname and Christian name for all records in the table when i type either Id# surname or...

i was having a prob with a search box but i downloaded an example from ythis site which uses a textbox and a list box. MNy problem now is that when the search is done and i click in the box for the record, the data on my form doesnt change the form opens every time with the same record and...

the information that i have is on a form. not a list box. and one more thing pat, what does the _ at the end of some of your lines mean. Im not new to access per say, but i am new to vb. weird right. :cool:

Thanks , one more thing though. was that text box placced on the same form that has the information to display? Did you use any kind of command button. Where does the code go. Does it go to an onclick or on enter event?

One More Criteria i want it to return a string "Different Currency" if all three currencies arent the same. can this be done? Sorry, i meant to ask HOW can this be done? :rolleyes:

i would like to create a search form that searches based on three criterias\ 1. If both Surname and Firstname are entered where firstname's displayed are dependent on the firstname selected 2. Search by firstname only 3. search by surname only. I can create this by using several forms and...

hey thank you. i didnt even think of that. Kinda silly though its like physiscs. If body A and body B are in thermal equilibrium and body B and body C are in thermal equilibrium then body A and body C can automatically be assumed to be in thermal equilibrium. :eek: :D

i have three fields called rates. Each rate value has a corresponding currency value. I have an averge rate box in a querry with all the rates and their corresponding cureeency/ how can i get the query to average the rates only if they all have the same currency denomination. Please help. i...

Sent you the db i sent oit to your mail.

send it to your hotmail? do you mean i should send you a copy of the datatbase through to your hotmail address. Im gona send it through in a sec. Its. 13 mb.

GREAT PROGRESS, last prob all of the fields both in the form and the subformn are locking now. i created another textbox that is unbound and set the focus in the codes behind the onclck event. I want to set the focus to it, which i have been able to do so that the other records can close...

first youd need to create a relationship between your tables. then create a query that has all the informaation from both tables. Like the code you would select from a combo box. ive created a query naed query 1 and a form named modified order so this works. let me know if i hae helped/...

thanks for the reply. i dont get the "cant lock field that has focus" message now so thanks. but the problem now is that only one of the fields in the subform is locking the others dont. this is the code behind the lock button/ Private sub cmd_lock_click() on error goto err_cmd_lock_click...

:) Ihave a form with a subform attached and also a enable form field and disable form fields button. the problem is that the disable form fields button refuses to work correctly. sometimes it disables everything on the main form and only one field on the subform. i get a messsage saying...