PDA

View Full Version : Anybody know Access Database?



Harddrive7
02-22-2006, 04:24 PM
I've just completed a database using MS Access and I'm having a bit of a problem. I would like to attach a spreadsheet to this database. Is this not possible?

The Database is an order form and I would like to add a button somewhere that when selected, will go straight to excel to a spreadsheet for tracking purposes.

Does this make any sense? Is this possible?

Kat
02-23-2006, 03:56 PM
Man, I don't have a clue, but have you tried Microsoft Office Access Help? I've found it to be fairly useful at times.

Is this at all helpful?:

You can add a Microsoft Office Spreadsheet Component to a data access page to provide some of the same capabilities you have in a Microsoft Excel worksheet. You can enter values, add formulas, apply filters, and so on. Use the procedure below to create a spreadsheet in which you enter raw data, or into which you import data from a Web page or text file. If within the spreadsheet you want to use data from other controls on the data access page, you need to refer to those controls in the appropriate spreadsheet cells.

1. In Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) of a data access page, click Toolbox on the toolbar.
2. In the toolbox (toolbox: A set of tools that is available in Design view to add controls to a form, report, or data access page. The toolset available in page Design view is different from the toolset available in form and report Design view.), click the Office Spreadsheet tool .
3. Click the data access page where you want the upper-left corner of the control to be.
4. Click inside the control to activate the spreadsheet.
5. Right-click inside the control, and then click Commands and Options.
6. Using the Commands and Options dialog box, customize the appearance and behavior of the spreadsheet.

For more help on designing and using a spreadsheet, click Help on the spreadsheet toolbar. If the toolbar is not visible, select the Toolbar check box on the Workbook tab of the Commands and Options dialog box.

Harddrive7
02-24-2006, 11:20 AM
Thank you, that was very helpful.

Kat
02-24-2006, 01:07 PM
Yay, I was helpful at something I'm clueless about!