Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import invoice data into Access
I am in the preliminary stages of trying to figure out a way to get purchase order data out of an accounting program and into an Access database. The Access database has multiple tables that contain all of the necesary information for a purchase (ex. Voucher, Item details, vendors, etc). I am...- sdannerr
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Use tabel Create Date to name Archive copy
I am looking for a way to copy a table and give it a name containing the date the table was created. Can someone help me figure out the code necessary to do this. Here's some more background... I have a table called CurrentData which contains the most recent upload of data from our G/L...- sdannerr
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Line Numbering with Sub Reports
I am trying to add line numbering to a report that contains 4 subreports. Is it possible to do this with Access 2000? I need the line numbering to continue sequentially from one subreport to the next.- sdannerr
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
Query Access data using Excel via ODBC
I am having difficulties with querying data from Access 2000 using Microsoft Excel. We use security on all of our databases which I think might be part of the problem. When I go to create a query in Excel I am told that it cannot connect to the table. A few tables work fine but not all which...
