Recent content by geoB

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