Search results

  1. C

    Update totals

    I have a subform on my main form which I use to calculate a total in. I then display the total again in my main form. My problem is that the value is not displayed automatically in my main form. I have to pass the mouse pointer over it before it appears. Does anyone know how to solve this problem?
  2. C

    Month - a simple one

    How can I display the current month on a report. I want to display the name of the month, not the number!
  3. C

    Apostrophes

    I have a button on my 'Enquiry' form which opens up a 'Client' form using a company name typed on the 'Enquiry' form. This works fine until I enter a value with an apostrophe in it e.g When I type 'Callum's' I get the following error: - Syntax error (missing operator) in query expression...
  4. C

    Update Table using query

    I have a TOTAL field in a table which holds a number which is the total of values in another table. I have successfully written a query to obtain the value from my other data ,however, I don't know how to get the result to automatically my TOTAL field. I don't even know if an auto generated...
  5. C

    Clear Date

    How can I clear the contents of a field? This is my code so far but I need to set clear the Target date field when the checkbox is not ticked : - Private Sub Completed_AfterUpdate() If Me!Completed = True Then Target_Date = Date Else 'Want to clear Target_Date here...
  6. C

    Why does this not work?

    I have written code for a command button which I want to use to compose an e-mail using an address from my form. The composer opens OK but I can't get the address to automatically appear in the message. My code is a s follows: - Private Sub E_mail_Click() If Me.Dirty Then DoCmd.RunCommand...
  7. C

    Icons

    Hoe can I lanch my database by clicking on an icon that I have?
  8. C

    Searching using own forms

    I would like to be able to search for a specific person ID in a table called person. However I want to use the person's first name a nd surname as my search criteria. I would like to provide the means for my user to type in the name and for the database to look up the ID and return it. i know...
  9. C

    Choosing people to reference

    I have a database that is used to hold details about enquiries that people make to our company for work to be carried out. I have three main tables:- Enquiry (holds enquiry details such as date, subject, client name), Client (which holds info about who the work is for) and Person (which holds...
  10. C

    Creating new records using from entries

    My database aims at holding details about clients enquiring to our company. I have a form named 'Enquiry' which lets the user add an enquiry record in my 'Enquiry' table. I have a field in my form which takes in the company name. What I want to do is automatically create a record for more...
Back
Top Bottom