Search results

I have a search form with 2 combo boxes, the second combo box is a nested combo box of the first. In the top combo the user selects fruit, meat, or pastry. In the second combo box the user would select types of fruit or meat etc. I have a search button that changes the record source of the...

Hi I have a procedure which creates a new contract for an employee in the Contracts table (tbl_Contracts) After some fields have been set a form appears in which the user will enter the Start Date of the new contract. This is done by the code... DoCmd.OpenForm...

Hi I'm testing the gathering data via email feature. So, I've created a very simple table (tbl_Person) with just 3 fields... Person_ID Person_Name Hair_Colour_ID Ive created another table (tbl_Hair_Colour) with just 2 fields... Hair_Colour_ID Hair_Colour I've joined them in...

Hi I have a really simple piece of code that enables or disables 3 controls depending on the state of a checkbox. This was working fine until I applied conditional formatting to these controls. Could it be that the conditional formatting could be re-enabling the controls even when the code...

Hi I’d like to gather data via email and tried to use the built in functionality of 2010 to use Outlook. I selected the table that I’d like users to complete but it presents fields in the form as text boxes that require a number to be entered that ought to be combo boxes with meaningful lists...

Hi I have a table for Status Values... ID Status Value Preceeding_Status_ID 26 CV Received 0 27 Invited for Interview 26, 29 28 Rejected at Shortlisting 26 29 Interviewed 27 30 Rejected after Interview 29 31 Contract Offered 29, 32 32 Contract Accepted with Conditions 31 33 Contract Accepted...

I have 2 tables... Department Team The team table has a field (foreign key) for the Department that the team is part of. Department_ID Department_Name Team_ID Team_Name Department_ID (FK) The department is entered via a Combo Box on the form. This works fine. The Team is also entered...

I have a form which takes its data from a query. When that form is activated I would like the form to requery its data. I am using the OnActivate event but for some strange reason, the form isn't picking up the new record that is definitely there when I just run the query itself...

How do I suppress the #Error from the (New) record line in a datasheet ? Thank you in advance.

Can someone please tell me what is wrong with this before I throw this laptop out of the window... Cur_Candidate_Status = DLookup("Candidate_Status_Long", "qry_Candidate_Status2", "Candidate_ID = " & Forms![splitform_RRARs_Approved]![frm_Candidates].Form!txt_Candidate_ID) The Form names are...

I have a form that sits on a tab control. When I select the tab I would like the form and all the controls that sit on that form to requery, but what is the best Event to use in which to add the requery code ? Ive tried Form... Activate Got Focus On Current ...but none of them seem to work.

Hi I have a query which takes its criteria from a control on a SINGLE FORM and it works fine. If I then edit the query so it takes the criteria from a SPLIT FORM it no longer works. Does anyone know why this might be the case ?

Hi I have a Single Form and a Datasheet on a form which hold the same data. I sometimes need to filter the datasheet and select a record and then have the Single Form jump to that record. This isn't working using ... DoCmd.GoToRecord , , acGoTo, Selected_Candidate ...so I want to return...

Hi I'm adding a record to a table and then I want to be able to see that record in the Datasheet form but its not there. I have to select the datasheet and then click refresh for it to appear. I've tried refresh and requery but nothing seems to work...

Hi I have a table of staff with (for simplicity)... Spot_ID (this is the Staff ID) Full_Name Initial_Start_Date and other stuff... The 'Initial Start Date' is the start date of the staff member's very first contract using this Dlookup...

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

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

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

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