Solved

Marked Finished

Posted on 2011-02-20
4
256 Views
Last Modified: 2012-08-14
I have an excel spread sheet that has a column with a bunch of different invoice numbers. For everyone of these invoices, I need to have the "Finished" box checked off on the access form. Going through and doing it by hand creates problems, is there a way to automate this process. So that any invoice number in the column is automatically marked "finished" check box in the form (or table)?

What would be the easiest way to do this?
0
Comment
Question by:cansevin
  • 2
  • 2
4 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 34939516
import the excel file to a temp table
file >get external data > import

after importing run an update query

update tableX
inner join temp On tablex.Invoicenumber=temp.invoicenumber
set [finished]=true


or if you want just create a link to the excel file then
run an update query similar to above
0
 

Author Comment

by:cansevin
ID: 34939756
Any chance you can help with with the attached file?

What I need to happen is the any BookingID from Column 1 of the excel sheet, I need to marked the check box "MadeinQuickbooks" in the table "Bookings"
PracticeCMdb.mdb
0
 

Author Comment

by:cansevin
ID: 34939759
Forgot the excel file
InvoiceSheet1.xlsx
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34939814
just follow what  i posted at http:#a34939516
* change the name of tables and name of field
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now