Search results

I give up. Please help. I need to perform a query that will give me records for a range of dates and for the same hours (like a work shift) each day. My table has both a time and date field. I have been successful at querying the records for the given dates, but when I try to limit by time of...

Good day, I have a pretty good idea how to do this but I am having some problems with the nitty gritty stuff. I have a query that sorts out which records I want to email. I have a report that is tied to the query. As it stands now, the report shows all of the records based on this query...

Good day, I have a pretty good idea how to do this but I am having some problems with the nitty gritty stuff. I have a query that sorts out which records I want to email. I have a report that is tied to the query. As it stands now, the report shows all of the records based on this query. What...

Private Sub Command280_Click() newnotes.SetFocus notes = CurrentUser() & Now() & newnotes.Text & notes.OldValue End Sub The above code shows the gist of what I want. The newnotes memo field is unbound, and the notes field is locked. If I could format the text the way I wish, it would look...

G'Day All, Problem with my last database has come back to haunt me. I am using the following code to autofill a form based on an unbound combo box. Me.RecordsetClone.Finfirst "[Employee_ Number] = '" & Me![Combo18] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark Works beautifully when there is...

Good evening, I need to copy a field value from a child subform to its parent form. The field in question is [Employee Number]. Subform is called [Caller Details] and form [call record]. Thanks, I'm stuck, I know this should not be hard...