My form will prompt the user for Part Number.
In the table the records look like this:
PartNumber CreateDate LastSerialNumber
1 1/1/2011 1
1 1/1/2011 10
1 1/1/2011 20
I need the vba code to return the record with the '20'. In this table there are many different part numbers, dates, and serial numbers. I need the record with the last serial number used for that part number and most recent date.
I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
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:
this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management.
Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…