Search results

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!

I have to make a form that extracts out to multiple buyers for our company. What I have been doing in the past is making the form based off of a table with a record for each buyer along with the email address. There would be a button for each record and the user would click on the button...

I want to be able to export a query from Access via a button on a form. I know how to use the transfer... to do it but I want it to run exactly the same for the user as if he or she had selected Export from the File Menu -e.g. the user is prompted for the save location Does anyone know the...

Yes, which made it puzzling. Did a compact and repair and now it's working properly. Weird. thanks for the help.

I have made a simple updateable form based from one table. When I set the form to dynaset or dynaset(inconsistent updates) and get back into the form, the form only allows the addition of new records, despite the fact that Data entry is turned off. When I set it to snapshot, it shows all...

I'm automating my database and using a transfer text module in the macros to export CSV files. Everything is great except that, in the CSV files, the date adds the time at the end automatically. I am running these transfer text modules to export both queries and tables. The format for both the...