Update quantity field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm doing an inventory of a whole bunch of CD's that aren't in any order. After messing with excel and having my eyes go crazy from searching for duplicate values, I've decided to transfer it over to an access database. I'm trying to not have to go and type them all in and then delete the superfluous records, then updating the quantity field. What are the commands used for accomplishing this task? I can figure out VBA, but I just get lost sometimes when trying to pick and choose from the commands. I know that I'll have to write the code (or run the macro) on the Lost Focus part of the Event on the properties, but I just don't know the commands used.

Thanks for the help
 
-----Original Message-----
I'm doing an inventory of a whole bunch of CD's that
Click to expand...
aren't in any order. After messing with excel and having
my eyes go crazy from searching for duplicate values, I've
decided to transfer it over to an access database. I'm
trying to not have to go and type them all in and then
delete the superfluous records, then updating the quantity
field. What are the commands used for accomplishing this
task? I can figure out VBA, but I just get lost sometimes
when trying to pick and choose from the commands. I know
that I'll have to write the code (or run the macro) on the
Lost Focus part of the Event on the properties, but I just
don't know the commands used.
Thanks for the help
.
Click to expand...
Hi bbalzar,

I recommend using the excel data|filter|advanced filter to
filter out duplicates before importing data into an access
table.

Luck
Jonathan
 
Back
Top