Search results

This is the code I am using Private Sub cmd_Stop_Click() Finish.Value = Time() 'Finish.Enabled = False Worked.SetFocus Worked.Value = DateDiff("n", [Start], [Finish]) End Sub Private Sub Command10_Click() Start.Value = Time() 'Start.Enabled =...

Hi All I have a Form = Form1 I have a Subform = Sub1 In Sub1 I have four Fields: Name, Work, Mobile, Email The Name field is always populated. In Form1 I have a Memo field which I need to populate by concatenating the four Fields from Sub1. All clear so far? The Project: an...

Hi All Here is my code that works apart from the fact when a new record is added it gets added at the bottom of the combo box. How can I sort the combobox please? Private Sub cboSearch_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Family_ID] = "...

I have a main form - frmMain I have a subform - frmSub I am populating two fields on frmMain from fields on frmSub. The code that is nearly working is this: Private Sub cmdUpdate_Click() Dim Name1 As String Dim Name2 As String Dim Children As String Name1 =...

Hi Again, I'm still stuck after too many hours trying different things. Still needing help please. I have my main form frmFamily which includes Family Surname, Phone details, address, and so on. I have a subform frmIndividual Subform which I am wanting to use to list all the individual first...

Hi all, I am creating a database with two tables: tblFamily and tblIndividual. I need to populate a field in tblFamily - 'Names' - with names from tblIndividual. I have a form - frmFamily - with the sub form - frmIndividual. In sub form frmIndividual I have fields Name (text), Adult1...

Hi All, my name is Gene and I live in Wanganui, New Zealand. I 'play' in Access but find myself requiring help with certain aspects. I'n one of those place now, so I'll post another thread somewhere and seek your expert feedback. Thanks for the welcome.:D