Solved

Marked Finished

Posted on 2011-02-20
4
276 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 120

Accepted Solution

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

777 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