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: 11
Default multiple updates to database

I have a database that has Cow numbers in Column B and vaccination dates in
the proceeding 5 columns (C, D, E, F, G)for each cow.
Each week We open this excel VBA based workbook and, using a pivot table
lookup what cows are due for vaccinations. Normally we have to individually
go through the database and enter the vaccination date into what column (C,
D, E, F, or G) it applies. Each column is a different vaccination and each
cow must complete all vaccinations in our program.
I already have a userform with a list box that displays the cow numbers that
we vaccinated that day-what I need to do is be able to enter a date in that
same userform and have it entered in the first empty column in the main
database that corresponds to each cow in the listbox.
I have no idea how to make multiple action proceed from a listbox of
selected items.

Any help would be greatly appreciated-thanks
 
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
Database updates pfdubz Excel Discussion (Misc queries) 2 September 16th 09 11:00 PM
Mulitple updates in database M.Desmond Excel Programming 5 October 10th 08 08:52 PM
Excel Multiple sheet updates Liz Excel Worksheet Functions 1 September 26th 08 08:50 PM
Set up database that updates automatically Qty's entered jcheko Excel Worksheet Functions 0 March 4th 08 07:09 PM
Drawing driven database updates Kennard Excel Discussion (Misc queries) 1 February 13th 06 03:40 AM


All times are GMT +1. The time now is 05:17 AM.

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

About Us

"It's about Microsoft Excel"