Search results

hi I have a little bit of code that uses a DLookup to prevent users from entering duplicate values, as below: Private Sub groupIDFK_BeforeUpdate(Cancel As Integer) justchosen = Me.groupIDFK previouschosen = DLookup("groupIDFK", "jun_groupevent"...

Hi I know this problem has been posted by others in this forum, but I can't seem to get the solutions working. I have a button on a form that triggers a gotorecord acnext code. When it gets to the end of the recordset, I would like the user to be brought back to the first record. I have tried...

Hi I have a form containing a subform. The form is based on a query. I would like it so that (1) if the user enters the form and the query returns no records, a warning appears and they are returned to the switchboard; and (2) if the query returns record(s), the user can cycle through the...

Hello I am having a problem with an append query. I want my database to create a single new record in a table using values from another. I guess an append query is used for this. I have this so far: INSERT INTO jun_waitingevent ( waitinglistevent_ID, offdate, waitinglistIDFK, patientIDFK )...

Hi Many thanks in advance I have a form with 3 subforms on tabs. On the individualtreatment subform, the user can enter a date as a startdate for therapy. The user is then asked if they want to remove the patient from the appropriate waiting list (triggered in the after update). The idea is...

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

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

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

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

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

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

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

I have the following code to go to a record from a list box. Option Compare Database Private Sub List15_DblClick(Cancel As Integer) 'Requires reference to DOA 3.6 Dim db As DAO.Database Dim rst As DAO.Recordset DoCmd.OpenForm "mainform" Set rst = Forms!mainform.Recordset.Clone...

Hi, I am writing a database which will be on more than one computer. I want to be able to import/export any modifications that the user has made to/from a floppy disk/ flash drive or a file on the hard drive. I want this done from two buttons on the switchboard (an import and an export button)...

Here is the problem: I have a form where the user selects a value from an unbound list box. The selected value is used to filter records. The results are shown on a second, Main Form. The filter is applied through VB which was generated through a wizard. On the second form, there is a print...

Hi, I am setting up a simple database of clinical psychologist supervisors that includes fields like which theoretical approach they take. The users of this database will want to select different criteria, and then show all the supervisors that fulfil this criteria. At present, I have a...