Search results

  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...
  16. C

    Icons

    I don't want a shortcut to my database. I want to use a customised icon - one which I have downloaded from the web! I want my user to be able to click on the icon and launch the DB
  17. C

    Icons

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

    Increasing form length?

    Change to form view. Go down to the very bottom of your form to the form footer bar. Click at the top of this bar when the pointer icon changes and drag down to make the form longer.
  19. 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...
  20. 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...
Back
Top Bottom