Basic stuff with Access

[jrlocke]

Hey guys. I'm working in VBA with Microsoft Access to create a program that will be able to draw up quote estimations. Basically, a user will be able to select he features he/she wants and at the end, it will produce a little report with a cost estimation. I'm having two major problems.

1) I was wondering if there is a way I can create a grid on one of the tabs that will populate itself with information from the database. It would be a pain to have to create a text box and input box for each selection on each tab, since in one of the tabs, there are over 20+ selections. I'm trying to save time, as I have to have this done by Friday morning.

2) My second problem is, the program is a form with multiple tabs at the top. I need a way to implement a next button that will change between tabs. Any suggestions?

Thanks in advance!

P.S. I know I'm not being totally specific, I'm really rushed on time. If you need a specific question answered, I'll be watching this post like a hawk, so I should reply within seconds. Thanks again.

[Hack]

Access VBA.

I think your questions/issues will have a better audience with the VBA folks as opposed to the reports folks so I'm moving this to Office Automation.

[RobDog888]

In Access' toolbox you can add a Microsoft Data Grid Control to it if you have VB6 also installed. If not You might be able to load the VB runtime redistributable files to get it.

[jrlocke]

Hmmmm. No VB6, but I will try the runtime files. Thanks again.

Anyone have an idea for switching tabs?

[RobDog888]

Option Compare Database
 
Private Sub Form_Load()
    TabCtl0.Pages.Item(1).SetFocus 'clicks the 2nd tab
End Sub

[salvelinus]

You might be able to do a subform on a tab (if you can, never tried it) that would give you enough of what you need from the grid, depending on what you need.