Search results

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

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

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

I'm missing a bit of experience dealing with this query. It's very simple. I'm selecting log activities from COMLOG. However I only want the most recent DateStamp entry of each Cust_FK entry listed. Because there are more logactivities, there are more/identical Cust_FK values. Would I first...

Hello, Can anybody see what I'm doing wrong here. I have the following query SELECT Contacts.Cust_FK, Contacts.ContactNr, Contacts.FirstLastName FROM Contacts WHERE (Forms.ComLogDetail.Cust_FK=Contacts.Cust_FK) ORDER BY Contacts.ContactNr; The "Forms.ComLogDetail.Cust_FK" part should render...

Hello, From a subform I'm opening a popup form to a new record. Except the new record must insert the CustFK value. Right now its just filtering the record set. How can I insert the CustID value in the DoCmd.GoToRecord , , acNewRec form?? see VBA code below. Dim stDocName As String Dim...

Hello, I am trying to run a macro on doubleclick in a subform (dataview) that will open the same record in a popup form (tabular). I've enter in the macro Where Condition the following statement to only show the record I doubleclicked on in the popup. The only problem is it's asking me for a...

(sorry I accedentally posted this one on query list. It should be here). I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc. In all reports I have entered a text label with date control source...

I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc. In all reports I have entered a text label with date control source stating "=[Enter start date:]" to have the start date parameter value printed...

Does anyone have an idea how I could include variables I input in a query to that of a report header? I have a date stamp in a query. In that query I entered the BETWEEN [ENTER START DATE:] AND [ENTER END DATE] paramater. In the ensuing report this query is based on I would like to include in...

I've got two tables. 1) Financials 2)Candidates I've got a form for "Candidates" with a subform "Financials" In the subform I'm trying to create an event procedure in field "Status" 'after change' that will Dlookup a value in the Candidates table (ConsultFee) and divide that value by 4 and place...

Hi, I'm having a problem I just can't seem to solve. I've created a query that includes a join query as well. When I run the query it displays the data correctly so no problem here. But as soon as I want to create a report based on that query I get the following error when trying to run the...