LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I link a .xls invoice to an access database?

I need the description field in a stock .xls invoice to populate when the
item # has been entered into the item field. I have created the access
database with each item having its own unique ID #.

In the .xls invoice I have Item (101) Description (widget) Quantity (2) and
Cost (.10)

I want to simplify invoicing by only having to enter item # and Qty. The
Description and price should be autopopulated via the information in the
database.

Please Help!

Sincerely Frustrated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link to access database Jack Excel Discussion (Misc queries) 0 June 2nd 09 11:21 PM
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
How do break the link from my excel workbook to a access database. Vernon Excel Discussion (Misc queries) 4 November 17th 07 06:26 AM
Moved database, how do I change link to the database in excel Toastrack Excel Discussion (Misc queries) 0 October 20th 06 09:36 AM
How can I create a customer database to use with an invoice? Brenda L. Carroll Excel Worksheet Functions 1 April 25th 06 07:53 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"