Search results

Hi.. I have a parameter query which brings up a dialog box prompting the user to insert a number (relating to the number of years the user wants to see data about). The dialog box has a OK and Cancel button on it. The OK button works fine. But the Cancel button does not...it returns an...

sorry submitted this wrongly. [This message has been edited by rupes_mahal (edited 10-19-2001).]

Hi... I have a table which consists of patients details. Each record has a date field which is recorded when a patient is ill. What I need to do is to write a query which returns records which are 3 years old from the present date. When I click on a command button....I want all the 3 year...

Hi.. I have a form which has command buttons and fields in it. When I end the data in field 1 and press Return key on keyboard, it then goes to a command button, but I don't want it to go there. I want it to go to the next field below it. How do I do this? please help.. Thankyou in advance...

Hi.. What I am trying to do is this: I have a form which has details of Doctors, such name, address, doctors code, etc. I want a command button to open up a Mircosoft Word Document called "LetterHead". On the document, I want the Doctors Name, address and doctors Code to be pasted straight...

Hi... This thread relates to an old thread i pasted up early. i am sorry for pasting this thread and not carrying on with the past thread, but I am desparate need of help. old thread: http://www.access-programmers.co.uk/ubb/Forum7/HTML/002128.html Relating back to the above thread. i...

hi... i have 3 fields... [ReferenceNo] [PremiseCode] [Supercedes] I have to work out [Supercedes] field. The code I have within [Supercedes] field is..... Dim varA as Variant varA = Me!PremiseCode If(IsNull(varA)) then Supercedes = 0 Else Supercedes = Dlookup("[ReferenceNo]"...

hi.. I am trying to lookup values from another field according to the what is typed into the form. Code used: Private Sub SIscore_Click() Dim varX As Variant Dim var As Variant var = Me!Bodysys ('bodysys is the field on the form where the user inserts code) If var = BodySysCode Then...

Hi... Im running this code: Private Sub SIscore_Click() Dim strSQL As String strSQL = "SELECT Bodysys from cal " _ & "WHERE Clin1sub = 'hello'" Me!SIscore = strSQL End Sub What I want this code to do is to bring the 'Bodysys' back to thw SIscore field. But I am getting an error...

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

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