Search results

  1. A

    Copying an Access form into Word

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

    Ordering a subform

    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?
  3. A

    Hyperlinks to Lotus Notes

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

    Data Type Mismatch for Criteria in a Date field

    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?
  5. A

    Ghost fields in my form

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

    Run-time error 2448

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

    Updating a control from a subform

    I have a textbox control on the form New Friend Input Form Version 7 called LastContactDate. I have a subform of this called Meetings which captures the details of contacts with the friend. What I'm trying to do is when I enter a new meeting date-that this automatically updates the...
  8. A

    Creating a form for a Junction/Intersection Table

    I'm trying to create a form that will enter information into a junction table. I have a many-to-many relationship between two tables: Events and Contacts. The purpose of this form is to assign people in the Contacts table to a particular event. Ideally, I would like to be able to see an event...
Top Bottom