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!

OLE object, Excel worksheet

Status
Not open for further replies.
commanderrico

commanderrico

Technical User
Jul 21, 2003
23
US
What I have is a table with fields, DATE:, PART:, CAST LOT:, SHIFT:, WORKSHEET:. The Worksheet field is an OLE object and I want it to be a specific Excel worksheet that I have created. Now I want that worksheet to be the default object for each record when a new one is created. to make things more interesting, I have created a form so the user can enter the information, however, the worksheet opens on the form and it is not available to edit. Is there a way, from the form, to create a new record with the worksheet open to edit? And then if I want to create a new record the next one will open the same way, default worksheet, ready to edit?

Thanks,
Rico
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
116
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
OLE Active Barcode Control
Replies
1
Views
82
strongm
strongm
DeRochier
  • Locked
  • Question
Bound Object Frame Blank
Replies
1
Views
117
DeRochier
DeRochier
SnayJ
  • Locked
  • Question
Continuous Form - Object Background color based on Criteria 1
2
Replies
21
Views
311
SnayJ
SnayJ
Latoya
  • Locked
  • Question
ListBox in Excel
Replies
1
Views
74
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top