Search results

Thanks Jack.....it worked.

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

RASKEW... u are a darling....thankyou so much...brilliant. Another small question please....The window which pops up asking to input the NumYears......Can I change the top of the window which says at the moment: Enter Parameter Value Can I change that...if so How do i change it...

Jack... please could you expain the code you have inserted above.....what does it do..? I inserted the code and I am getting records which are more than 3 years old. For example: today date = 06/10/2001 records retrieved by the query are dated between: 01/02/1996 - 05/10/1998 I only...

hi... anyone please help with the above problem...I am so struck... thankyou ruby

yea I did set the reference....but I keep getting the error message as above. It highlights the following line: Set oApp = CreateObject("Word.Application") I think it has something to do with CreateObject..... Please help.. thankyou ruby

Rich... It brings back records which are 3 years old by year.....I need to bring back records which are 3 years old from the present date. For example....i click on the cmdbutton and its brings back 2records dated: 1) 05/10/1998 2) 05/10/1998 Today's date is 05/10/2001. Minus 3 years from...

Jwindon... Thankyou for your help.. I have inserted your code and changed it according to my form. But I keep getting a error message: ActiveX component can't create object. I don't know what this means and why it keeps appearing... Please help

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

Thankyou Peter....it has worked..

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

Pat... thankyou for gettign back to me.. You say that i should consider using DMAx(), could you please help me out here, as to how to use it within my problem... thankyou in advance Ruby

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 Charityg... Thankyou for your reply and your advise is helping me very much. I now think I am on the way of developing it further. Thanku again Ruby

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 Mike... Thank you for responding. Could you please help me code this using DLookup. I have not used DLookup before. Ruby