Copy your SQL from the access database and get Vb to run it using the ado command object. Then have a look at the output in a flexgrid. You might find that the actual data does not look exactly as you thought because access does a fairly good job of making it look good.
Once you have the data, you can write your form around it. Matt Real Name wrote: >I did a table in Access then a query to do the totals. Then in VB 6 I >ran the VB application wizard. It says that it will import tables and >queries. It did a good job of making a form out of my table, but its >drop-down box only had the table and no query. Anyone know what to do? > > > > > > > >'// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [email protected] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] >'// ======================================================= > >Yahoo! Groups Links > > > > > > > > > '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
