Recent content by callumwatson

  1. C

    Update totals

    I finally solved my problem. I had my textboxes on a tab control along with my subforms. However, the tab control was in the header of my form instead of in the details section. I should have noticed such an obvious mistake and I definitely won't make it again. Thanks to everyone who tried to...
  2. C

    Update totals

    Would anyone be willing to take a look at my form if I was to sent them it along with the requirec tables?
  3. C

    Update totals

    I have no events taking place when I move the mouse over the textboxes. All I have is a refernce to the total box on my subform. e.g I have a Valuation total text box on the main form which has the following in it's control source property: =[Valuation subform].[Form]![Text7] Text7 is the...
  4. C

    Update totals

    I tried what you said but the value still isn't displayed automatically. I had a look at the Northwind sample database's Orders form. I see that the totals on it update immediately but I can't find the code which does it. This may be of some help to me if someone could tell me how to find out...
  5. 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?
  6. 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!
  7. C

    Apostrophes

    Thanks a lot for your help. I did the double quote thing and my problem has been fixed. Callum
  8. 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...
  9. C

    Update Table using query

    Why do you not recommend calculated fields? By typing a query into my text box I dont create the value in my table that I would like (which I was then going to used in a report).
  10. 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...
  11. C

    Clear Date

    That worked - should have known or at least guessed that!! Thanks
  12. 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...
  13. C

    Why does this not work?

    It was as easy as that! Thanks for your perseverance. Much appreciated, Cal.
  14. C

    Why does this not work?

    Sorry to ask for more help. I don't quite understand what you mean by 'Try using the SendObject in place of Hyperlink Address'. I have looked at HELP but I still don't know how to apply the code in my situation. I am a new VB programmer and I would really appreciate some elaboration on my...
  15. 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...
See more
Back
Top Bottom