Search results

Hey guys, need some help. I use the following code to auto save a file when I click the x/close on the Excel application. The filename that is saved under is a value from a cell ("E12") in that file. Sub Auto_Close() On Error GoTo errtp: If Application.DisplayAlerts = False Then...

I have a form called “frm_TrainingLog” based on “TrainingLog” table. This form is continuous and tabular – I need to have it this way. In the header of this form I’ve created a listbox called “QuickSearch” which displays staff details i.e. StaffID, Name etc. The mainform and the listbox are...

Hi guys, I have a mainform "frm_CaseReference" and a subform "subfrm_CasesControls". In the main form I have "DOB" field and in the subform I have "DateSlideTaken" and "AgeAtSmear" fields. I want to automatically calculate age in the "AgeAtSmear" from the "DOB" and "DateSlideTaken" but...

Hi Guys, I need to set validation rule on a field. I have done the the below: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.SlideType) Then MsgBox "You have not entered SlideType!", vbExclamation + vbRetryCancel, "Incomplete Form!" Cancel = True Me.SlideType.SetFocus End If...

Hi guys, I am trying to do something but not sure how to code it, I would be grateful if someone can help me. A slide is examined three times by three different members - so you get three results for one slide. If the results from each staff for that slide don’t match then it needs panel...

Hi, I am trying to create a form which involves 3 tables. The 2nd table (CaseRef_Case_Control) is the junction because I needed many-to-many relationship between “CaseReference” and “Cases” tables. All I want to do is automatically fill in the fields in the “CaseRef_Case_Control” table when I...

Hi guys, Lab staffs are required to undergo 3 day training course within every 3 year period. The course options are 1 day course, 2 day course and 3 day course. The course can be taken as: 3 continues days within 3 years 1 day course taken 3 times individually anytime within 3 years 2...

Hi Guys, I need some ideas on designing a database. I send about 300 letters nationally to all senior staffs in NHS to make sure their clinics/staffs are following the correct procedures regarding patient info etc. This review has to be done on annual basis. Every year I would send them a...

I need help big time, can someone plz help. On a order form I want to send emails to everyone who works in that department. Basically when placing an order certain details are enter on the order form (see the attachment) including department, so when the send email button is clicked I want to...

Hi, I am not sure how to design my response form for a survey questionnaire database. At the moment I have "ResponseText" and "CommentText" fields that are used to store answers. The problem is each questions have different type of answers: select one from the list or the user types the...

Hi guys, I need help with setting up my tables and relationship for a questionnaire type of database. Basically there are two questionnaires that are conducted; one is completed on the day of the treatment and another one after the treatment on a later date. Both questionnaires have 13...

I have a subform which disables certain fields based on the value entered. The problem I am having is that when I click on add new record, the form stays in the last state with disabled fields. Basically I want all the field to be enabled when add new record button is clicked. I hope it makes...

Hi guys, just registered, very nice with excellent info forum you have here. I aint that good with databases but am getting there slowly :) I have a problem, was wondering if you guys can help? Here is the prob: I have a button called openSubFrmPanelMembers that loads up a form when it is...