Search results

Hi Rod, Took the Is Null out like you said and did come up with a figure. So I have: ContractA: DCount("[EmpKey]","tblEmployees","[StartDate]<#01/05/05#" & " AND [LeftDate] Is Null") ContractB: DCount("[EmpKey]","tblEmployees","(([StartDate] >= #01/05/05#) AND ([StartDate] <=#31/12/05#)) AND...

Am just getting a zero on the count for ContractB ?

Hi, Having a problem expanding this expression: ContractA: DCount("[EmpKey]","tblEmployees","[StartDate]<#01/05/05#" & " AND [LeftDate] Is Null") That works great but when do the expression below says syntax wrong......WHY? ContractB...

So I can create a query that links the ithe sickness record with an interview. Will try and read up

Actually split it up with a sub form and worked in the end.

Hi, Have been developing an Employee DB which includes sickness records and interview information. Have mangaged to sickness records but now I need to link interviews to these specific records which is where I am having a problem. All sickness records are shown on a sub form and I attached a...

Have a staff report that counts all staff and breakdown of job type and job status including percentages but I want to place a criteria on from a control on a form. Have placed it against Department name which then displays just those staff in the department but cannot get it to work against the...

The problem actually came from when I copied the form and removed two controls from it which I needed for editing. This was the problem from using one form for viewing and editing. I think in future I will use two completely seperate forms.

Am sure there is a simple solution to the people that know.....which isn't me! But I have a text box on a report to calculate % of total and don't know how to Round it up or display the total? The Text box is: =([TotalTemp])/([GrandTotal])*100 Tried =Round([TotalTemp])/([GrandTotal])*100 &...

Had some help before from Danny with an earlier problem with Dlookup on my Personal Details form. Problem that I have now is that when I try to edit the details the as well as updating the JobID field in tblEmployees which it is supposed to it is also changing Position and Grade in the tbleJob...

Sorry found out that it isn't the query for the report it is actually the controls on the form as the required field in JobID is not being updated. Apparently the form is fine.

Thanks Ru! I didn't know that. Decided to take the subform off in the end and put controls in it's place as was sure the user's would think they had undone something and they hadn't. maybe when I get better at this I can come up with a different solution.

Hi, Have been trying to create a report for Department Staff. The problem is that I all the staff come out on the report with the same Position and Grade. When I change Position and Grade on one of the employees all the listed employees then have that Position and Grade. I assume that I'm not...

OK Le have seen what you have done now and yes it is an easier implementation than mine. Only been doing this afew months so still learning and wasn't fully aware of how queries could be used but that will help in a lot of areas. Thanx

Sorry, What I did was made the Shift control no longer visible when the form was being edited otherwise the user would try and change the shift. Did manage to solve it using Dlookup on the Shift control: =DLookUp("[shift]","tblshifts","[groupid]=Forms![fmpersonaldetails]![groupid]") Looked...

Is it possible to use a combo box to select and display and OLE object? Have a number of work rosters for different departments and have created a table with the RosterID and Rosters and in Rosters have placed the Excel Spreadsheets. I then placed a combo box onto a form but could only see the...

Hi, Have a main form with subform. Can udo edits on the main form and am trying to do the same for the subform and am having problems. Can someone correct my syntax for me please..........and maybe someday I'll get it! Here's my code below....thanx. Private Sub PDEditUndoBut_Click() On Error...

Thanx le888 that was nearly what I wanted but managed to do it now so that Shift is dependant on GroupID and Shift field is no longer visible so cannot be input. Apparently it is easy when you know how?

Point taken.........changed it ! Thankyou.

Thanks FoFa managed to get the answer from website posted previously and which is nearly the same.