Recent content by Del_Piero_3

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

Solution Never mind, solved it.....heres the solution, might help someone else: Private Sub QuickSearch_Click() On Error Resume Next QuickSearch.SetFocus If QuickSearch.Value > 0 Then Me.Filter = "[StaffID]=" & QuickSearch.Value Me.FilterOn = True End If End Sub

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

Raskew thank you very much for the help. It worked like a charm....Anyway below is my code, it may help someone else in future...

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 Pat, thanks for the reply... It is a single course which is duration of 3 days.....staff dont have to do 3 continues days to complete course instead they have the option of spreading the days like: 1 day, 2 continues days, 3 continues days. It doesnt matter which way they decide to complete...

Anyone??? come on big guns.......help me out

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

Can you please pm ur email addy, the databse is about 600kb

On my order form, it doesnt have email address's, so I need a sql (query) that finds every email address in the employees table that work in that department which is selected on the order form.

I've copied and pasted the code into my db, assigned it to click button procedure, changed the fields name etc, but the sql part is different, and I am beginner.