Search results

Set OlApp = CreateObject("Outlook.Application") is indeed the solution!!! Also, for those who may foolishly copy my code, I needed to delete the line Set olAcct = ol.Account because it was not possible to set an object to "Outlook" itself. There is joy in Mudville tonight! George

Thanks for the reply. This is where I started. I took some old guru's advice and tried that for no change. It will shortly disappear. This I will try. SWMBO calls. Will report when back. g

SOLVED: Cannot set Outlook SendUsingAccount A client wants to e-mail newsletters using a non-default Outlook account. The code below does everything the client needs except setting the SendUsingAccount. In debug I can see that the correct account is assigned, yet all of my testing results in...

Thanks for the reply. I'll try to be clearer. First, what happens in the AfterUpdate event is irrelevant. It calculates a To Do list for tasks that are scheduled based on the DOB. What matters: the subform is to collect data on a newborn. It appears in a page in a tab control. The...

In ACC2010: A subform has a control for date of birth with an AfterUpdate Event. When the date picker is used to populate the control the user must either click outside the control or press the tab key to trigger the control's AfterUpdate event. This event runs some calculations, the results of...

fwiw, the error I encountered was due to the Access requirement of parentheses in a complex set of JOIN statements. Hardly optimal and precludes copy & paste from MySQL for similar queries. g

About the same in both, and I consider myself above average in each. I've developed apps in Access on contract as well as websites using PHP and MySQL. I was just puzzled by the error I got in Access after pasting in a statement that worked nicely in MySQL. So clearly they are not equivalent...

I'm using Access to develop reports on a MySQL database. My first step has been to get the query right using MySQL's Query Browser. On occasion, a copy and paste of the SQL statement will generate an error in Access. Can you recommend a good resource for understanding the differences between...

Boyd, Many thanks for the link. I'll add it to my future reference bag of tricks. g

Boyd, I'd very much like to see an example. All the wheels I try to invent seem to have sharp corners. George

A 'side' db is an interesting idea - I'll see what I can do with it. Modifying table properties isn't feasible because the number of fields may vary. I also have no experience with Cross Tab queries so I'll save that for another day. But thanks for the good idea. g

Thanks for your reply. And here I was manipulating the table definition in an effort to eliminate the number of table deletions and creations I had been doing! No way around either limitation, then, I guess? g

In ACC2007: I have an application where one of the tables can have a variable structure. I have been successful up til now using DROP COLUMN for all the fields, then using ADD COLUMN to create the new structure. (There are procedures elsewhere that deal with the changed structure. The...

The answer: leave the Answer field as plain text and feed it to the browser control via a temp file. Gee, that was fun! g

I've now got an ActiveX browser control reading a temporary file with the field's contents. Yet text with HTML tags is not yet formatted. And the tags show as tags. I remain stumped. g

Thanks for the reply. Anything that'll help me focus my search? File name? Form name? I've searched here on "memo html" with no real success, nor does a broader search on "access memo html" seem to get me closer. I don't mind code, and for a once-per-semester db, bloat will be ok. I've...

In ACC2007: I have imported a CSV file that contains a field (Answer) which contains text and may also include HTML tags. [The file is a download of online final exams's results. I've set up the db to grade the responses without seeing the students' names.] The answer field is a memo...

Well, a wheel has been invented. Just not sure how round it is. The module attached is intended to be run from Word 2007, probably in Normal.dotm. It assumes a Word document containing just the code output of an Access database documenter report for Modules, Forms, Reports and, for Queries...

It looks like my wheel remains to be invented. I'll have to deconstruct Larson's code to get at a module's procedures. But it's a start. Of course, I can compare an application to itself, which does work. To get a standalone procedure it'll take a bit of work. George

Fantastic! I'm now off to btab-world to read more. Many thanks. George