Recent content by pretoria

Hi, Question does anyone know how to send an email that picks up the default outlook template. Once sent to outlook I want my current html template to show my company address etc. My current code is simple and just pops up to a new email with nothing in it. If IsNull(Me.Email) Then MsgBox...

problem solved. for those of you interested. Me.Counter = Nz(DMax("Counter","COMLOG","Cust_FK=" & Me.Cust_FK),0) + 1

I received notice from someone that I don't need to use a query in vba. Perhaps someone can give me some insight I have in my COMLOG table Cust_FK Counter 1_______ 1 1_______ 2 1_______ 3 1_______ 4 2_______ 1 2_______ 2 2_______ 3 The result I want to return for Cust_FK=1 is 5...

Hi, I'm trying something in VBA and I'm not sure if its possible. I'm trying to add an event before insert and set a counter field to a value result of a query (LastCounterValue) and add on 1. Is this possible? Additionally, the query must be run on the current form Cust_FK field. How would I...

Scott Gem, I've finally sovled it in a slightly different way. I made a third query with just Fullname and ContactID and joined that to the LastLogQuery2. In my report I just included the field Fullname. Thanks for you help, you made me think more critically for a logical solution.

You're right. I'm not comparing anything. wrong choice of words. I already have the firstname and lastname fields in my report (queried from LastLogQuery2). The simple object I'm trying to achieve is combining the firstname lastname fields in my report. I was hoping I could do that by placing...

Okay, then should I be comparing the ContactID rendered in the LastLogQuery2 to the original table where ContactID resides namely "Contacts" table? is this enough information? p.s. LastLogQuery2 is a join between records from three tables. Companies Contacts CallHistory

I know the first part works because it works with my forms, its the where statement that's not delivering. I'm wondering whether I can at all do this in a report?

-------------------------------------------------------------------------- I am trying to combine firstname and lastname in a listbox on a report. It seems to work for my forms but I haven't gotten it work yet for a report. Can someone take a look at my WHERE statement to see what I'm doing...

I am trying to combine firstname and lastname in a listbox on a report. It seems to work for my forms but I haven't gotten it work yet for a report. Can someone take a look at my WHERE statement to see what I'm doing wrong. The report is based on the LastLogQuery2 I have the following sql...

Jon K is the man. Thanks for extended effort!

Jon K, Ok. I've also added your LogID field. the table now looks like this. LogID CustLogID Cust_FK DateStamp TimeStamp Log 1 1 1 10-01-05 10:23 bla bla 2 2 1 10-01-05 12:23 bla bla...

You're right. I forgot to mention I have an additional TimeStamp field next to the DateStamp field which would make it unique. How would I sql these two queries you mention?

yes, but that returns only one record. I need the most recent entry of each group of Cust_FK's. any ideas?

A quick example of my table would be this. But I only want it to return the most recent entry for each Cust_FK LogID DateStamp Cust_FK LogActivity 1 30/06/2005 1 text. bla bla bla 2 28/06/2005 1 text. bla bla bla 1 30/06/2005 1 text. bla bla bla 2...