Search results for query: *

Tried all you suggested and the decided to point it to another control, [MerchantId] ... and guess what? It worked ... although it obviously didnt find a result! So I deleted the [Amount] control and straightaway recreated it ... and it works! Eh? Exactly! Thanks for your suggestions Roy-Vidar...

Hmmn. I've tried these suggestions and now get #Name? error. I'm wondering if the field references on the form have changed in some way ... because it was working ... as were 3 other similar fields. Any ideas?

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

The problem went away, since we resorted to a UNIX based solution (not coded by me) which worked just fine. I therefore never got around to trying out my own suggestion! From an academic point of view though, I would be interested if anybody else managed to make this work. Martin.

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

OK. Why didn't I find this on the Microsoft Site when I first looked? I think I've found the solution ... SQL dates must be formatted as US dates. Check out the link below, which also provides a link to some code to force US dates. http://support.microsoft.com/support/kb/articles/Q208/5/96.ASP...

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

Thanks for the code. I like your use of the DRAFTS folder. The problem is principally though one of creating an HTML formatted e-mail. Perhaps it's easier than I thought. I haven't tried this, but should the text I create in the body of the message actually be the HTML code itself with all the...

No. It's not a report. The e-mail text is being created along the lines of "Thank you for your enquiry ..." and will include a gif logo (or hyperlink back to the website), coloured text and background. To get these features it needs to be formatted as an HTML E-Mail and will be sent...

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