Search results

Hi LQ... Thanks for replying. The fields are bound to a table. On the form in design view, the 'Address' text box says: DoctorsDetailsTBL.Address and DoctorsDetailsTBL.Telephone. The code I am inserting in the properties, After Update = Me!Address = Me!Addresses this means, Me!Address =...

Hi.. I have a form which has a combo box. The combo box has a drop down menu, with names in it. Once a name is choosen, the related text boxes get updated. E.g..... Text Boxes: 'Name' 'Address' 'Telephone' Combo Box: 'Name' When I pick a name from the combo box the 'Address' and...

Alexandre, thanks for your reply. Could you just let me know if my understandi g is correct... The declarations I understand dbMyDatabase = currentdb() //where currentdb is the name of my database? rDAOMyRecords = dbMyDatabase.OpenRecordset(strMyQuery , dbReadOnly) //what are these 2...

Well.. I'm trying to write an algorithm (for the 1st time!) in VB that will calculate a 'score' for each record in a table, based on values in another table. If I can execute an SQL statement that I know will return a value, I can then assign that value to a variable and do other things to...

Hi.. please please help.....im desperate Knowing that an SQL statement will bring back 1 record only and I only require 1 field value, Can I assign the value of the SQL statement to a variable and if so what is the syntax in VB please. You help will be much appreciated. Thank you in advance...

Hi GaryC.... U are the best. I can't believe you have got it working for me. I have been going mad and having bad days because of this problem. And GaryC.....came and saved the day for me. A Very Big Thankyou...... I owe you one! Lots of kisses...... Thankyou again Ruby

hi I am using this code from an example to complete my search form. If Not IsNothing(Me!ClubName) Then If IsNothing(strWhere) Then strWhere = "[ClubName] Like " & Chr$(34) & Me!ClubName Else strWhere = strWhere & " AND [ClubName] Like " & Chr$(34) &...

hi.. How do i put the OR statement into the code i have pasted above. Please help.....i don't know VB/SQL that well. I am going mad trying to work it out, but no joy so far... PLEASE...ANYONE....IM DESPERATE ruby

hi.. I have set up a search form. It is working fine. But I also have a problem with it. I have a field called "Names" in the search form. At the moment, it is working fine, by looking at one column in the table and finding it. But i also have names in other columns. I want the search to...

Hi.. I am trying to set up a search form. I am looking at an example called "Books.mdb". It has an search example in it. I am understanding parts the search operation and how to go about building my own one. But i need help with some of the code. Below is part of the code for the Search...

Hi.. I have developed a Search form. Search Form: Option group * Premise Code * Practice Code * Partnership Code * Address I have a combo box, that relates to the Option group. E.G. if I pick Premise Code in the option group, the drop down values in the combo box all relate to the premise...

Hi rich thank you for getting back to me. I do actual have a design problem. So please ignore this. Ruby

Hi. I am trying to write a union query and need help. I have a table containing 6 fields Name1,Name2, Name3, Name4, Name5, Name6. I want to produce a single drop-down list of all these names, and don't know how to write the UNION SQL statement for it. Can anyone please help Thank you in...

Hi Rich... When I use your code, it displays all the 4 fields information as rows in the drop down menu for the combo box. eg. name1 name2 name3 name4 ruby max rich harry thats my table.. when I use you code, it displays in the combo box: rubymaxrichharry etc...

Hi (Question) I have a table with 1 column called "Names". Can I design a form which has 2 text boxes which both relate to the "Names" column. So...one text box is called Name1 and the 2nd is called Name2. I want both of these text boxes to write to the column "Names". Can I do this and if...

Hi.. I want a combo box to display a drop down menu with results from 4 columns in one table. The query I have so far is: Select Distinct Name1,Name2,name3,Name4 from DoctorsdetailsTBL. The drop down menu only shows the results from the 'Name1' column and ignores Name2,name3,Name4 columns...

Hi I am trying to setup a search form. I have used the Option Group tool, to create 6 different options. EG. Options 1) Premise Code 2) Partnership Code 3) Practice Code 4) Doctor's Code 5) Doctor's Name 6) Address i have also inserted a Combo box in the search form. Now..what I am trying...

Hi I have setup a table and a form which consists of details of users. Each record has a date assigned to it. Each record is updated after 3 years and a new date is assigned to it. I want to setup a command button, which will by a click bring back the records that need to be reviewed. For...

Kevin... how do I use the input mask... thanks ruby

Liv manto.... could you please tell me more...where shall i put that code and its unfinished, wat am i suppose to put in it... thank you in advance for your help ruby