Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nvr
  • Content: Threads
  • Order by date
  1. nvr

    DLookup Criteria #Error

    I wish to make one field (target field) on a form use a DLookup based on criteria from another field (source field)on the same form. I did have it working, but now it seems to #Error all the time. I cant for the life of me work out what i have changed. On the form, the target field is NoOfTerms...
  2. nvr

    Report Page Length Different On Publish To MS Word

    I have a report which looks and prints correctly in Access. When I use Publish to Word from the tool bar, the resultant output (in MSWORD) puts the footer onto a new page. So my report uses up twice as many pages as it ought to. The strange thing is that it did once work correctly. Any pointers...
  3. nvr

    SQL Date Behaviour and Regional Settings

    My Regional Settings are English (United Kingdom) with short dates set to dd/mm/yy and long dates set to dd mmmm yy. In code, when I execute an SQL with a WHERE MyDate = #09/10/00# (the English format dd/mm/yy) is seems to believe that I am using the American format (mm/dd/yy). Is there a...
  4. nvr

    Sending HTML Formated E-Mail Using Outlook

    I need to send out a whole bunch of e-mails on a regular basis. I'm OK with using DoCmd.SendObject to get them into Outlook, but I'm unsure how to go about constructing the required mail as an HTML formatted e-mail (not an attachment). Any pointers before I kick off in the wrong direction...

Part and Inventory Search

Back
Top