Search results

Ok, I'm partway there...at least in understanding. I created a dummy database that uses time() instead of the now() function to autofill. In doing so, I can limit the records to the time I want. That being said, i already have over 17,000 records created with the Now() function and would kind...

Thanks for your detailed reply. Unfortunately it doesn't work for me. I tried to cut and paste the query parameters: Between #7:20:00 AM# And #3:30:00 PM# and I had no results (should be plenty). I changed the query parameters to >#7:00:00 AM# just to try and limit the records but this time...

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

I think your best bet is to use concatenation. Set the hyperlink as a locked field and load the following to the after update event on the field [billno field] me.hyperlink = "f:/files/shared/wp8/"& me.[billno field].text & ".wpd"

After a bit of research today I found some code that I will be able to modify for my purposes. I'm not familiar with word mail merge but it doesn't sound like a bad idea either. I was able to find the gist of what I wanted and that is the ability to loop through a recordset and be able to do...

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

Looks like I posted this to forms by accident...sorry...Al

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

thanks alot... the spacing and stuff I was ok, it was the carriage return that I wasn't aware of. I'm not surprised that it was something relatively simple. Bolding the text is not that important, but if anyone else has any ideas...

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

Thank you thank you thank you. Something so basic, works like a charm... Al

Yes, I suppose I could ask users to do this, however, not a practical solution. When something is enterred in one field, I wish the field to be auto filled.

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