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

[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

[tvssarma]

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

[ricodstar]

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

[tvssarma]

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

[dee-u]

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

[dglienna]

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.

[tvssarma]

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.

[dee-u]

Folks I already did the project.....