Solved Hello!.. In need of some assistance. Access Form VBA code

[KCollins]

Hello helpful community,
I was wonderful if you could provide some assistance. I have a access database with a form and macros included. I have membership data that requires to be exported into its own folder. Is there a VBA code that can be created to have members exported into it's own separate folder based off the "MEMBER ID". I provided below a sample file. Thank you so much for your help

MEMBER ID	LAST NAME	FIRST NAME	DOB
111111111	DOE	JOHN	1/11/1111
222222222	DOE	JANE	2/22/2222
333333333	DOE	JILL	3/33/3333
444444444	DOE	JOSEPH	4/44/4444

 

[moke123]

Not sure I understand your question. Data normally resides in a table. What exactly do you want to export to a folder?

 

[KCollins]

So sorry for the confusion, I would like to use a VBA code to export a file from my access database to a specific folder. For example the folders I have on my desktop are titled by "MEMBER I". I would like members with that same member ID to be exported to excel in that "MEMBER ID" folder that matches the member ID in the access database table.

 

[CJ_London]

Sounds like you need to use the transferspreadsheet method

DoCmd.TransferSpreadsheet method (Access)

Office VBA reference topic

docs.microsoft.com

 

[KCollins]

Got it thank you so much for your help

 

[KCollins]

Hello Pat, the solution provided in the previous thread was the answer to my question. I was able to successfully export the file. Thank you

 

[CJ_London]

think this is a language issue - OP meant previous post - postcount is only 4, all on this thread