Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Vlookup on embedded excel sheet in access form

Status
Not open for further replies.
mudstuffin

mudstuffin

Technical User
Sep 7, 2001
92
GB

Hello.

I have a form (Form1) in an access 97 db, and I have embedded an excel sheet in the form (OLEUnbound14).

In the sheet I have a range of data (DRangeNames)

I want to be able to perform a vlookup on the data range to look for the string "greg" for example, or the contents of the text0 textbox contents...?

How do I do this in VBA in my access form...?

Thanks.

mudstuffin
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
149
Xavierparkash
Xavierparkash
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
363
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
239
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
195
TrekBiker
TrekBiker
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
100
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top