Recent content by aproctorpe001

I have created a large/content-rich/formatted form in Access and wish to copy it to Word so I can send it out as an attachment to an email to gather necessary input data. Is there anyway of doing this as I really don't want to have to manually create a replica of the form in Word.

I'm trying to order a subform by a date field. I've tried setting the Order By property in the Form's properties to the field but this does not seem to do anything. Any pointers?

Thanks-Sorry but still having problems. That seems to work on it own but the proble seems to be becuse I have 2 levels of subforms. The main form is Employees, the subform is Contacts and the second subform is Meetings. The control that needs to be updated is in the first Subform(Contacts)and...

I can't get the expression to work. Seems to be complaining about the dot operator '.HTH' at the end of the expression. Any ideas?

I have a control on a form that contains email addresses. I've set the field as a hyperlink data type and what I want to do is to be able to click the address and automatically open up my mail file with a new memo with the 'To:' field populated. I've used the following piece of code: Dim...

I have a query where I'm tried to find the most recent meeting date between an employee and a client. I've tried using the Max function in the Criteria field but I'm getting 'Data Type Mismatch Error' and I'm unsure why?

Sorry Rich, let me explain what I'm trying to do. I have a one to many relationship between Contacts and Meetings(A Contact can have many meetings). In the Contacts table I have a field :LastContactDte which stores the date when the Contact last met with one of our employees. I then have a...

Unfortunately, this run-time error has reared its ugly head again-can anyone tell me why this keeps happenning and is there anything else I can try to remedy it?

Cheers-the query generated by the wizard still contained the fields-thanks for the help

I removed a number of fields from my form and subsequently removed the underlying fields in the table they were bound to. However, when i open the form I'm asked to enter parameter values for the fields I had deleted. There is no other reference to the fields within the form such as in a...

Thanks-worked a treat

Won't that mean the compiler won't recognise the text box field on the parent form?

I have subform(Meetings) nested in a subform(Contacts) nested in a main form(Employees). I am trying to update the field LastContactDate on the Contacts subform when a meeting has been added on the Meetings subform. The field updates but when I try to switch to next employee I get this error...

Sorry-slight problem I used the following code: Me.Parent.[LastContactDate] = Me.[MeetingDate] with the After_Insert event but I'm getting run-time errors when I try to cycle through parent records. The runtime error is 2448-You can't assign a value to this object and possible causes are...

Cheers guys-sorry, should have mentioned that the main form I was referencing was a subform aswell.Much appreciated.