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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.