Search results

Yep sorry....new to this forum business!

Hi, Have two controls GroupID and Shift which are linked with Criteria: SELECT tblShifts.Shift, tblShifts.GroupID FROM tblShifts WHERE (((tblShifts.GroupID)=[Forms]![fmPersonalDetails]![GroupID])); Have two other controls which are Position and Grade with same type of link. Problem is When I...

Searched again and found a wsite with screenshots and explanation which was quite useful: http://www.meadinkent.co.uk/aquerychoose.htm Didn't realise the count actually seperated the different values and gave a total of each. I was trying to seperate them myself. Well it's taken me since 7am...

Yep tried that......but my knowledge of Access is even less basic and I cannot seem to grasp building the query properly. Here is the SQL that doesn't work: SELECT tblEmployees.Job_Status, Sum(tblEmployees.Job_Status) AS SumOfJob_Status, Sum(tblEmployees.Job_Status) AS SumOfJob_Status1...

Hi, Brand new to this! And have been trying all morning! Have a field in a table called Job_Status which can have three values: Permanent = 1 Temporary = 2 Probationary = 3 All I wanted to do was create a query that showd me the totals of all employees plus the number of perm,temp and...

Very new to VB and Access. Have two Dlookup controls (fields that I believe are called controls on forms) which are Postion and Grade. I don't really understand the workings but I believe because they are unbound I cannot undo edit on these two controls. Is there a workaround to this such as...

Hi my second post! Very new to VB and Access and am creating a HR database for work. Have created a Personal Details form and on click allows edits. Am using Dlookup fields for 'Position' and 'Grade' which sit under two text boxes on the Personal details form and are displayed when the Edit...

Hiya Just wanted to say.....sorted it!! Spoke to someone and they said about placing an SQL statement on the form itself. Did that and changed it a bit and it works!!! Thanks for your help anyway.I'm sure I'll be back with more.

Hi Rec, Still not working. Could it be that the PayrollNumber Field on the two different forms have the same name??? Is strLinkCriteria = "PayrollNumber ......pointing to the Employee Intro Initial Form and '" & myPayrollNoField & "'" ...... pointing to the Record in Personal Details It...

Fair enough no offence taken. Not getting any error messages just not linking to the correct record. The name of the Payroll Number field is PayrollNumber. Form names are: fmEmployeeIntro which includes the button linking to the fmPersonalDetails. Did try something else but code is as below if...

Hi, Tried it but couldn't get it to work.....must be me! Have attached my test DB if that helps.

Hi, Quite new to Access and am developing an HR database for work. Have a EmployeeIntro form with standard employee information including the Payroll Number which is the primary key. The Employee Intro Form includes a button with a link to Personal Details which holds all employee information...