[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Marked Finished

Posted on 2011-02-20
4
Medium Priority
?
299 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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 120

Expert Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

649 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