Recent content by Dylan Snyder

thanks ez-friend and gemma- I didn't realize that the code you gave me already swept through the tables and created a denormalized recordset. This is great. Thanks again for all of your help.

Iterating a recordset. Got It. Thanks for all of your help. I'll study up on it over the weekend and hopefully I'll have a good new tool to use.

Thanks for your help, I can't get the code to work on my end, but this certainly points me in the right direction. I have been avoiding this more advanced VBA but it looks like I'm going to have to learn it. Is there a specific name for this or is there a web tutorial that you know of that I can...

I meant to say relates *Data

Unique Problem here and I am all out of answers so any help would be appreciated. I have to create an extract to an Enterprise System that relates date differently than what I am used to in Access. Basically, I have to extract a Parent and Child (one to Many) Table out of Access where(and here...

Unique Problem here and I am all out of answers so any help would be appreciated. I have to create an extract to an Enterprise System that relates date differently than what I am used to in Access. Basically, I have to extract a Parent and Child (one to Many) Table out of Access where(and here...

thanks for your help. now, I just realized that I don't know anything about schemas and getting XML exported files in a certin format. I hunted on the forum, but could not find any good tutorial on getting started. Does anyone know of the top of their head the definitive "exporting XML from...

I found this online - the page says that this code will work for 2003---and it's on the internet so it can't be wrong, right:)? Just thought I'd post this if anyone encounters this thread and has the same problem as I do. http://msdn.microsoft.com/en-us/library/aa221224(office.11).aspx

thanks, It may be time to upgrade. I'll try Gemma-the-husky's idea first, though. The days of our Department being on access are numbered, anyway. I would just allow the user to export using the menu commands, but I always feel scared allowing users to see anything other than the switchboard...

Thanks- I need to structure the data so that one record would span multiple rows- not one record per row like a query would be set up. Is there a way to structure a query so that it would kook like: record 1 field 1 record 1 field 2 record 1 field 3 record 1 field 4 record 2...

We are on 2003

Is there any way to automate the export of an object from Access in XML Format? Is XML Supported in SendObject? tHanks in advance for your help

I have a fairly unique problem, I need to create an extract from Access to update an enterprise system. The format must be text, similar to the following format: 10ASTAR LOGISTICS TOM LEE 111.866.9876543 Where this would be one record. "10" is a field, "A" is a...

Question: When you use SendObject to send an email through outlook, does the email sent use the Read Receipts property if it is set to yes in Outlook? From what I can tell, it does not. Users that have read receipts on their personal emails do not receive them when sending an auto email from...

thanks - wasn't quite sure where to search. thanks!