Search results

Hi I have an intermediate/junction table that records the status of a job candidate and the date that the status was reached. The logic is that the most recent date/time is the current status. So, I'd like to build a query and then pass this to a field in the Candidate table. The...

None of my field names have spaces - I just wrote them like that above just for speed.

I'm not a novice to database design but I've never created a Crosstab query before. These products are just a percentage of an employees wage - that's it. Effectively, its just one product from each pension provider. I have a table of Pension Providers which just has 3 fields Pension...

Ive maybe made it complicated by giving a bad example. The products are pensions that an employee can pay into. There are 3 pension providers, lets say they are provider A, B and C. Each pension PRODUCT is a percentage of the employees annual salary, 10%, 15% and 20% respectively. The...

See my last paragraph in my original post...

Hi, I am just using this as a simple example for something more complex (relating to pension providers) that I want to model. I have a number of products, lets (for ease) call them... Bucket Hammer Screwdriver I can buy those products from one or more suppliers. Each supplier can supply me...

OK, everyone is measured on 3 types of metrics... Technical Skills Professional Qualifications Behaviours All 3 are quite different. Technical Skills are ranked as Unaware Aware Familiar Proficient Expert Behaviours (or the demonstration of them) are measured as Self Others Organisation And...

I think I’ve maybe not explained myself clearly. The baseline expected metrics are set by a central team and these are not captured by the person performing the assessment. When a persons role is entered into a form via a combo box, a sub form should be populated with all the attributes that...

Hi I am trying to capture a team member’s performance against particular attributes, let’s say they are Speed, Strength and Agility – each scored from 1 to 10. The baseline expected figure for each team member is dependent on their Role, so I have modelled this as shown in the attachment. The...

Hi I have two sub forms in a main form... A Candidate Single Form A Candidate Datasheet Form When a new record is entered or an existing record is updated in either of the sub forms, I'd like the other sub form to immediately refresh to show the new record or changes. I've tried these...

Good to see another ex Corps member on here Mike60Smart. Ex 4 Div, Herford, Germany myself

Hi, There is a chance that someone who is already on the MasterStaffList (an existing member of staff) table will be a candidate for a new role and will be the successful candidate and therefore, their record needs to be updated with the data of the new role. I just need to figure out how to...

I have a database that tracks a candidate through a company’s recruitment process. When the Candidate’s status is changed to ‘Contract Accepted’ I want them to appear on a ‘Master Staff List’. Once they are on that list there is a lot more data that will be added to the staff member’s record...

I have a query that lists the status of an order and the date that the status was reached. When I use the MAX in Group By on the Date field it is still returning all the records. ID Status Date 1 Received 1/5/2018 2 Processed 3/5/2018 3 Shipped...

Hi I think I figured it out. I had a field (called Full_Name) linked to a Control on a form which also had a Sub called Full_Name. I THINK that was the problem but Ive also learnt some good practices from this. Thanks guys Al

Thanks Bob I get an error when I run the Compile (see attachment). I have used the On Change as this seems like the most obvious as I want the contents of a text box to change when I change the content of a combo box. Im not using the before update function. Would you recommend an other...

Hi Spike I can find the Tools Menu in the VBA Window but I dont see an option for Compile. Allan

Hi Alan Thanks for this. I dont get an error number, just the message that I put in the attachment. Al

Hi Alan, Its happening when I change two Combo Boxes... Private Sub cbo_Postcode1_Change() txt_Town_City.Value = cbo_Postcode1.Column(2) txt_County.Value = cbo_Postcode1.Column(3) End Sub Private Sub cbo_Title_Change() txt_Gender.Value = cbo_Title.Column(2) End Sub

Hi I have all of a sudden and for no apparent or obvious reason, begun to get an annoying error in my database. Can anyone help ?