Search results

Hi I have a form with three subforms. The three subforms are on 3 different tabs. I am trying to get it so that when the user enters data on a particular subform, focus is set to another control a different subform on a different page. I have got this so far...

thanks yet again Bob You are clearly some kind of King of Access

thanks Bob, but the same problem occurs. Adding a discharged date checks the check box, but deleting a discharged date does not uncheck the checkbox. Any ideas? cheers

Hello I have a bit of a problem. I have a table with three fields: referraldate (date formate), dischargeddate (date format) and discharged (checkbox). I am trying to write some code in the OnChange event of the dischargeddate. I want to get it so that if a discharge date is present the...

thanks to all. it was a mistake with syntax. you are all very generous with your time. thanks again

Thanks to both of you, I have tried all your suggestions, and now it is coming up with a different error: run-time error '5' Invalid procedure call or argument this is what i have Private Sub Form_Load() If Me.discharged = True Then Me.timeinservice = DateDiff(d...

thanks for your promt reply I have tried the following code in the forms OnLoad event Private Sub Form_Load() If discharged <> 0 Then timeinservice = DateDiff(d, [dischargeddate], [referraldate]) Else timeinservice = DateDiff(d, [referraldate], Date) End If End Sub but...

Hi, I have seen that there are lots of threads about working out the difference between two dates, but I think my question is a little different. I have a form, on which their are 3 fields, Referral Date ("referraldate", 23/07/2007), Discharged (yes/no field) and discharge date...

thanks again. my first problem was caused by repeating the same bit of code twice after the end if. I have stuck the code in the before update property of the subform, and this seems to do the trick. cheers for you advice

thanks for your really quick reply. Unfortunately, I still have a problem though. I am a total beginner with VBA and have manage to cobble together this: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Response As Integer Response = MsgBox("Do you wish to save the changes that you have...

Hello, Once again I would be grateful for any help or advice... Is there a way of creating a message box appear that asks the user if they want to accept or reject the changes that they have made on a record from a form? I would like this to appear only if the current record has been changed -...

Hello Many thanks in advance for any help you are able to give. I am creating a database for work. I work in service in the NHS. The purpose of the database is to track patients' history in the service, and to be able to see their current status. In the service, patients can have group...

thank you very much!

Hi I am pretty stuck on this on. It is probably simple. I am suspect I am just a little thick. I have a form with a subform attached. I am trying to lock only certain fields on the subform. The idea being that the user selects a number from a pull down menu, and then the rest of the fields are...

An exam for what? Databases are really not my area. I occasionally dip into them every year or so, so I really am a novice. I have tried searching on forums, but I am such a novice that I don't know exactly what to search for.

Thought it might be helpful if I attached what I have done so far.

Hi I am stuck. I am trying to make a database for work. It is to keep track of what happens to patients in the service for which I work. I want to be able to see what the current status is of a patient, as well as their history in the service. A patient may have had individual treatment(s)...

thank you very much... it works!

Hello I foolishly said I would develop a database for work, and I have been trying to teach myself and have become stuck. I am trying to build a database of patients and treatments that they have received in the service in which I work. Each patient can have many treatments, and each treatment...

thanks for your prompt reply. unfortunately that does not work - comes up with an error saying that it is not a string. ID is the primary key (autonumber) I am not very good a computers. Please help.