Search results

In your tables what data type are the fields "Connector ID" and "Pin ID"?

OK Don't know if the following would help, would changing this line of Code:- If Me.cboCustomerStatusID = 1 Then 'Normal Status to If Me.cboCustomerStatusID.Column(0) = 1 Then 'Normal Status

Are you able to upload a copy of the database with no Confidential data?

Hi John Can you upload the database?

Hi John Have you tried changing the form layout to Candidate - Vacancies?

Would it not be easier to have your Main Form based on Candidate_tbl with the subform based on vacancyCandidate_tble?

Sorry John but you would never allow duplicate records in Candidates_Tbl

John I would suggest that you add the Application date & Determination date to the Subform.

Can you upload a copy of the database?

Hi You do not need Vacancy_tbl_1 or Candidate_tbl_1

1 way would be to have a Form for New records. A search form that lists all existing record. Then a Click event on a specific record to allow edits.

You can Export the data to a Word RTF file

Can you upload a copy of the database?

Private Sub cmdPrintReceipt_Click() Dim response As VbMsgBoxResult response = MsgBox("Print Customer Receipt?", vbYesNo + vbDefaultButton2) If response = vbYes Then DoCmd.OpenReport "rptPrintCustomerReceipt", , , "[ContractNo] = " & Me.ContractNo End If End Sub

Hi Can you upload a copy of the Db?

Hi John Upload what you have so far and we can give you further guidance.

Ok No problem. I would recommend not using split forms are they are very limited.

Hi I could not replicate your problem. I created a new Form named "Delovodnik" and applied conditional Formatting. See attached.

Hi You have just sent a shortcut to the database. I need the actual database in zipped format

Can you upload a zipped copy of the database?