Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » OLE Excel Files embedded in Access
Richard has attended:
Access VBA course
Is there a way to extract Excel files embedded into a field as a OLE binary as a stand alone file.
Hi Richard, thanks for your query. This tool may be of use:
http://www.lebans.com/oletodisk.htm
Hope this helps,
Anthony
Wed 6 Jun 2012: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
If you wish to calculate the time between two date fields, this can be done in a number of ways:
1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.
The basic syntax to get the number of days between two dates is:
=[One Date Field] - [Another Date Field]
You can also use one of the following functions:
=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields
=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.
Another function is the DateDiff() function.
It uses an argument to determine how the time interval is measured. For example:
=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.
Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
