Report Problem

[Carl via AccessMonster.com]

I have an issues with my Microsft Access Database. It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers. We have 11 computers in our
office. Each computer has Microsoft Access 97, 200, XP, and 2004 on each
computer. We recently compacted all of our databases into one database.

My question is, is there a way to excract our information from the new
databases back into an excel spreadsheets? We have Microsoft Excel 97, 200,
XP, and 2004 on each computer. I wanna bring the data from Microosft Access
databases into the spreadsheet. I also, want to scroll up the report in the
Access Database Program.

Thank you,
Tony

 

[Guest]

I have an issues with my Microsft Access Database. It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers. We have 11 computers in our
office. Each computer has Microsoft Access 97, 200, XP, and 2004 on each
computer. We recently compacted all of our databases into one database.

My question is, is there a way to excract our information from the new
databases back into an excel spreadsheets? We have Microsoft Excel 97, 200,
XP, and 2004 on each computer. I wanna bring the data from Microosft Access
databases into the spreadsheet. I also, want to scroll up the report in the
Access Database Program.

You can right-click a table, click Export, and select an Excel file format
to extract the table to Excel. If you want to do a more automated approach
that loops through tables and does this automatically, you'd need to use some
code. Put this code in a coomand button's On Click event:
Dim tbl As TableDef
For Each tbl In CurrentDb.TableDefs
If Left$(tbl.Name, 4) <> "msys" Then
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
tbl.Name, "c:\" & tbl.Name & ".xls"
End If
Next

I'm not sure what you mean by "I also, want to scroll up the report in the
Access Database Program."

Barry