Search results

I have posted a couple of times about a loop I am trying to create to populate Outlook appointments, the loop is working but my record selection is not. I have posted the whole code below, but have highlighted the bits that are causing problems The purpose of the code is to create an appointment...

Hi I have a form for creating jobs with a subform allowing employees to be allocated to the job. the main form captures appointment times, dates duration etc. I have some vba code which will put the appointments into Outlook, however I have been asked to expand on this and create an...

Speakers Below is the code I am using to create the appointment. I have highlighted the bit I want to rerun for each employee allocated to a job Private Sub btnAddApptToOutlook_Click() 'On Error GoTo ErrHandle Dim olNS As Object Dim olApptFldr As Object ' Save the Current...

Good Morning I am using some code from Accesstips to create an appointment in Outlook, using information from my form JobNumber. Now I have been asked to allocate employees to jobs and also create the same appointment in outlook for each employee allocated to job as a seperate appointment. I...

Finally cracked it with Me.ProjectID = DLookup("[ProjectID]", "tblSalesDetails", "SalesID = " & DMax("[SalesID]", "tblSalesDetails")) Thanks for the help and pointing me to the fact the criteria didnt have a condition. Richard

I am looking for the code to return the field value for the record with the largest SALESID, however what it is returning is the field value for the record with a SALESID of 110, when it should be the record with a SALESID value of 23651 Thanks Richard

I have the following code in the on click event of a commad button I am looking to duplicate the majority of the last record using this command button(further similar lines of code not shown). The problem I am encountering is that the Field SalesID is an autonumber field and is at 23650 as a...

Hi I have two queries, one captures the last test date, formatted at the minute as a 'general number' using Format([Field],"0") on a piece of plant and the other captures the interval between tests on same piece of plant When I add a spcific number to either field in my joining query they act...

Sorry for the delay, but have been consumed with month end and then salaries Would I join the three tables in one query with the Project ID in the sales and labour tables linked to the project ID in the Project Table. Or would I do this in two queries?? How would this then be filtered in the...

This now works, thank you However I now have the problem that I receive a row for every project, not just ones with values in, this makes the report 56 pages long rather than 1 or 2. I have put the VBA code below in as an event to stop irrelevant rows appearing, however it does not remove the...

Hi I have a report which shows sales, labour costs etc by date and project number. The main report summarises the labour cost by project and I have a sub report summarising Sales values by project, which then links to the main report on the Project ID. The problem I have is that we may have...

Thanks to everyone for their contributions, I used Stopher's version as it was the shortest piece of code and it worked perfectly Richard

Hi Following a recent post I have created a piece of code to put vbcrlf between various fields to create an address field in a report, however a line is created for each field whether blank or not. If I no not want to have the blank lines, is an IIf(IsNull() statement for each field the best...

I have got the activation of Office out of the way and I am still getting the error. So have removed Chr() from the query and used vbCrLf in VBA on the format event of the report, report now works. Thanks for the help on the question

Short answer to your questions - No I tried with the '+' changed to & - same error I tried a new query as your suggestion with Chr$(10) and also Chr. I have even used the Function selector within the 'expression builder' and even then I get the error message. I have just noticed that the Office...

Thanks for the reply, however when the query runs it now prompts me for the 'field' vbcrlf Revised Expression below, any further help appreciated SiteAddress: [Name] & [vbcrlf] & [Address1] & [vbcrlf] & [Address2] & [vbcrlf] & [Address3] & [vbcrlf] & [Town] & [vbcrlf] &...

The company I work for have recently upgraded PC's to Office 2010 from 2003. I am getting some errors in my database which I am dealing with one at a time. The latest is when I run a particular report I am receiving an error saying Undefined function 'Chr' in expression Below is the...

I have been trying to create a command button on a form that sends a task in outlook to another colleague. I have searched forums and have some code that works for the most part, the only part not working is setting the reminder. I have attached the code and would like some feedback as to why...

Hi I have a subform which is shown in Continuous Forms view. I have a control called PaintPrice which has an after update event where I need to check if value in the PaintID control is the max, if this is so then I wish to move to other controls. The problem I am having is selecting the...

many thanks Richard:)