Simple part of a VB Project, Working with ADO to create a table

Hello,
Im looking for someone to help on a very simple part of a project, Its a access database with a VB front end, the interface is up and running fine but part of the interface needs to allow the user to select a parameter (event name) which then needs to select all the appropriate form the db and create a new table in the access db. For someone who undrestands VB this would be quite simple but as im working on other projects (primarly interface design) I havent got time to work on this, I would be willing to pay someone to do thso, if your interested let me know by posting a message asap, as i said its only a small part in a much bigger project so would be quite simple, if anyones interested ill post the forms and db..
Many thanks
sean

Quote:

---

Originally Posted by ricodstar

Hello,
Im looking for someone to help on a very simple part of a project, Its a access database with a VB front end, the interface is up and running fine but part of the interface needs to allow the user to select a parameter (event name) which then needs to select all the appropriate form the db and create a new table in the access db. For someone who undrestands VB this would be quite simple but as im working on other projects (primarly interface design) I havent got time to work on this, I would be willing to pay someone to do thso, if your interested let me know by posting a message asap, as i said its only a small part in a much bigger project so would be quite simple, if anyones interested ill post the forms and db..
Many thanks
sean

---

This requires ADOX I think it would be interesting. Why dont you post some details

Ok heres some of the details and in the folder is the db, id be very grateful for any suggesions..

Specification for BIBS

I need to have a form which has a combo box which displays a list of all events in events table (alpha order)

When an event is selected (dbl clicked or a cmd button is pressed) a query needs to run which displays all the details of an event and the details of those people booked onto that event. (query-event) show all details but the VB needs to make it specific to an event.

This then needs to be put into a new table in the access db called EventDetails,

I also need the code to delete the table so when it is all put together it will run as follows:

• User selects the appropriate event from a drop down list
• User clicks a command button
• the previous version of the table EventDetails is deleted
• the query runs and the new details are contained within the table
• a mail merge in initialised
• the user selects yes to mail merge
• user prints
• user exits word

Just give me some time to go about it. Otherwise, I can give you a small tutorial on ADOX, if that's what you need

I'm interested, I could charge minimum but with the privilege of adding to my resume that I did such project....

I could do the mailmerge without requiring WORD, by using a Rich Text Box. I have sample code that merges fields aready. PM me if you are interested.

Ricodstar,
I am sorry I sat on your prog for long I was busy. I will give you a working example by tuesday or wenesday. since I am still busy. Just bear with me.

Folks I already did the project.....