Search results

  1. V

    Error messages on unbound text

    Ok, what are you using WScript for and is it absolutely necessary? And what is the order of WScript in the list of references? That tells me what priority it has. Show me a screenshot of your references. If you can, you can send me your front end and tell me which form is the problem form and...
  2. V

    Create hyperlink to open Access form

    It was clear as mud! All of what has been suggested is meant to be automated. It's now down to you to research the ideas, start developing the process in code, ask specific questions and we can only quide you. The Outlook option would be best served in an appropriate Outlook VBA forum.
  3. V

    DCount function in subform

    I'm pleased that you searched before posting. :)
  4. V

    Pulling in data from another table

    Good job dbarton! For completeness, I would advise that you use the full reference to the form: =DSum("LABnum","tblTOTALS","[StartDate]>=[Forms]![FormName]![txtFDate] And [EndDate]<=[Forms]![FormName]![txtTDate]") With regards the limitation you mentioned, what do you mean by partial months...
  5. V

    Form Totals..

    #Name error indicates that reference is incorrect. What you need to do is use the Expression Builder to find the subform control.
  6. V

    update query not working

    Fyi, pbaldy gives a brief on this topic: http://www.baldyweb.com/ImmediateWindow.htm
  7. V

    Print Label Format Problem

    The subreport is a columnar report. Open the report in design view and on the ribbon look for the Columns button. Clicking on it will take you to a dialog box where you setup the columns. You can of course try one of the label formats, but I'm not sure if it would work.
  8. V

    DateDiff Function

    That wasn't a negative comment Dick ;) She definitely knows how to keep you busy. I wonder how many dbs you have now.
  9. V

    DateDiff Function

    Slowly but surely. Not until your wife wants another recipe db for summer dishes :D
  10. V

    Print Label Format Problem

    See attached and have a look at rptLabels.
  11. V

    Print Label Format Problem

    Yes, send a 2003 version and ensure that the navigation pane is visible. My laptop that has 2010 died on me yesterday so I'm fixing it at the mo.
  12. V

    little help with queries

    MarkK, I was also thinking that it's a one-to-one relationship but the mention of "10, 20, 30 numbers" and the LEFT JOIN made me think that it might be a one-to-many relationship and just not properly explained.
  13. V

    DateDiff Function

    If you think about it in simple terms you will get it. Let's say you want to find your real age, i.e. the difference in years between your date of birth and today. You would enter the following (where 19/07/1930 is your date of birth): DateDiff("yyyy", #19/07/1930#, Date()) ... which will...
  14. V

    little help with queries

    SantoR, give some examples with data. Show us some sample data in TableA and some sample data in TableB.
  15. V

    Report to save as Excel file

    GinaWhipp could be right but since you mentioned that you can export to Excel via the ribbon have you also tried DoCmd.TransferSpreadsheet ?
  16. V

    MsCal AfterUpdate

    Useful information for those reading this thread DennisOJensen! I'm sure that JamesJoey has learnt something new as well ;) By the way, MSCAL.ocx returns a Date type - I've just had a Typename() check. It only makes sense for it to return such a type, it being a calendar. However, it still...
  17. V

    Form Totals..

    Good, putting it in the footer is the way it should be done. How do you refer to it? DSum() isn't necessary in this case but it's another (slower) way.
  18. V

    Is it Just Me ?

    For me when it comes to household chores I get it done quicker when I'm hungry. But as for development work I don't do so well when I'm hungry or tired. I'm not as old as you grandpa so I'm not in a position to make any comments on age related habits ;)
  19. V

    Show Image. txt xlsx file in Continuous subform

    I've been going through some old threads so here's how you do it... 1. You will need an extra field in your table: Record ID ... other fields ... FileExt --------- --- --- --- ------- 1 jpg 2 xlsx 3...
  20. V

    you cant disable a control while it has focus

    Just like the error message says really. Comment out that code line and it won't error there.
Back
Top Bottom