MS Access - Why the need for Visual Basic?
February 26, 2004 - 8:53am — tbailey
I am wondering why Microsoft would make their MS Access need the programming skills of Visual Basic to perform, seemingly, a simple function?
I had my tracking database set-up in MS Excel but wanted more functionality and an input page (forms), for ease of use, but the simple task of subtracting one DATE from another DATE (something easily possible within Excel) is some drawn-out VB script.
Is there an easier way?
Similar
- Microsoft Social Networking Patent Application on Peer-to-Patent
- NPR interview with Bill Gates on the Microsoft Vancouver dev center
- Game console dilemma - Xbox 360 or Sony Playstation 3
- Media appearance: Is Microsoft doing enough to reinvent itself? on Business News Network
- Microsoft Canada opening software dev center in Vancouver (commentary)
Postings and comments are owned by their authors. What Boris says here doesn't necessarily apply anywhere else. You can subscribe by email if RSS isn't your bag, baby.
Comments
DateDiff()
DateDiff is the function you want... it's not a long script...
Or youo could do it in the SQL statement of a query... depends on what you want.
By the way... what are you tracking? Mammals?
Thanks, I'll look into that t
Thanks, I'll look into that though it sounds over my head since I have no programing experience. BTW - I'm tracking correspondense.
ie: Inbound Date, Date Due, Days Given (Due Date minus Inbound Date), Actual Sent Date, and Overdue (Actual Sent Date minus Date Due).
Is this not terribly complex?