Recent content by gregtriplett

Looks like I placed this in the wrong section of this forum. Thanks for the feedback. I've re-submitted under the VBA section of the forum.... I'm a newbie to this forum..

I've got 3 tables. One for "products", one for "customers", and one that shows which products go with each customer. This 3rd table is called "product_to_customer" table. I'd like to create a form that provides a simple user interface where the user enters a customer name and a product name. If...

I've got 3 tables. One for "products", one for "customers", and one that shows which products go with each customer. This 3rd table is called "product_to_customer" table. I'd like to create a form that provides a simple user interface where the user enters a customer name and a product name...

Thanks very much. This looks like it might be adaptable to my needs. In my case I need to automatically increment the file name (number) each time I do the export so I basically create a running log. Thanks again...

Wow, thanks for the quick response. Unfortunately I'm not much of a VBA guy yet - I'd sure like to be however - so I'm not sure I fully understand the statement: strData = "Whatever and however you get it here". Rather than trying to train me in VBA, although if you have the time and energy...

Have you had any luck figuring this out? I'm trying to do a similar thing. In my case I'm trying to export a record to a log file such that each time I do this export it gets appended to the log file. Do you have any thoughts on this?