Replies

actually, now I can generate a report with the videos listed, but now the problem is that for every borrower with more than one video, I get multiple reports. I have tried doing a SELECT DISTINCT in the query SQL but that doesn’t do anything terribly useful.

the problem seems to be that, although each borrower is listed once in the borrower info table, since the child field linking the list of videos to the subform has to be a name to link up the forms and report/subreports, the subreport section writes the name again for each new video listed, and I can’t get the query to stop doing that… And the report doesn’t seem to have any way to stop generating duplicate names, which would probably be the thing I need.

So I have ‘half-way’ solved the problem.

No but I am starting to get some success with using a subreport. just goes to show, ask for help and you start to figure it out…

Have you tried using the Get External Data command in Excel? It will set up an ODBC-type of connection to Access (and other stuff) and has a lot of details on what columns to import, etc. I have done this to import tables from Access into Excel when they are apparently too large to do via File|Import.

A warning, tho: the table you get in Excel will be ‘married’ to the Access table (it will be connected for refreshing data, etc.) — if you don’t want that functionality, you will have to delete the Name Reference in Excel that is created when you Import External Data.

That field is also called ‘Notes’ in the import wizard in Outlook, so it should be mappable in a VB program. I borrowed Helen Feddema’s program for exporting to Outlook from Access and the VB coding you might be able to use should look something like this:

Dim strNotes As String <– in the preliminary declaration of constants

strNotes = Nz(Me![you access field name here]) <– in the mapping loop for applying Access fields to a constant for applying to the Contacts form in Outlook

.Notes = strNotes <– in the loop for porting your Notes in formation into the Contact form field '.Notes' No promises that this will work, however — I have not been able to get the .Company form field to accept data.

If you need more information on Helen Feddema's code, let me know.

That field is also called ‘Notes’ in the import wizard in Outlook, so it should be mappable in a VB program. I borrowed Helen Feddema’s program for exporting to Outlook from Access and the VB coding you might be able to use should look something like this:

Dim strNotes As String <– in the preliminary declaration of constants

strNotes = Nz(Me![you access field name here]) <– in the mapping loop for applying Access fields to a constant for applying to the Contacts form in Outlook

.Notes = strNotes <– in the loop for porting your Notes in formation into the Contact form field '.Notes' No promises that this will work, however — I have not been able to get the .Company form field to accept data.

If you need more information on Helen Feddema's code, let me know.

I found out how to unregister the dll and ocx files, or at least knock them out of Outlook, so that problem is fixed.

your method for posting an access record to a public folder does work — thanks! i’d still like to be able to map directly to a public folder without the navigation step, but at least i can get most of the job done.

i take it from your response that you have implemented this in a way to do batch transfers… how do you deal with making lots of duplicate records in the public folder? I am really looking for a way to synchronize the public folder with an access table, or at least chack for duplicate records before posting, etc.

also, i find that invoking the PickFolder command switches over to Outlook, so I put in a SendKeys alt-tab command to switch back over to access to complete the VB module.

anyhow, thanks again for the code snippet.

I got those files in a package from this article:

http://exchange.devx.com/upload/free/featu…9900/rb9900.asp

It is very informative, but I had trouble getting it to implement. When I installed it, there was a new tab in the folders | properties dlgbx but it had the nice little effect of freezing outlook when accessing it. anyhow, if you try it and don’t get it to work, you can uninstall it via the COM Add-In in Outlook.

What I really need is a way to programmically find a sub-folder (Contacts folder) in a public folder on the Exchange Server. The code I always find is

Set fldContacts = nms.GetDefaultFolder(olFolderContacts)
Set itms = fldContacts.Items

Which is fine for porting Access data to the default Contacts folder in my Inbox, but that is *not* what I want to do. I noticed that the folder I am trying to get to has this path reference:

HHSC ContactsCRCGLocal Kids Chairs, and that *looks* like a UNC path. Now to place the path reference in the VBA code… actually, I haven’t tried it yet. Another problem is getting the Contacts field in Outlook to take data from the same field in Access, but one step at a time…

I figured this out on my own. Thanks tho!

thanks — it worked. kind of a strange little program.

nope. this is a company machine and they have, for some reason, determined that users cannot change their resolution. but i think mine is set at 1260×1400 or whatever is close to that.