Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 9th, 2004, 12:00 AM
Authorized User
 
Join Date: Feb 2004
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to chacquard
Default "Object Required" message

Hi,

I've been working on a form that contains a subform. The fields in the main form are EvendId, EventName, Date, time, place, etc.. These fields cannot be edited (locked = yes and activated = no)

In the subform the fields are EventId, TicketNo, Qty, Section, Row, Seat,etc...
I use this subform to see the list of tickets for the event and to add new tickets. When I open my form, the focus goes to the last record. Then, if I want to close the form or undo, I have a "Object Required" message by Microsoft Access. I double checked all of my fields. They all allow null value or an empty string.

The form and subform allow additions, edits and deletions.

I don't know where to look anymore... please help me... :(

Chantal

(Sorry if some of the terms are not right, I use a french version of Access)

 
Old February 9th, 2004, 10:24 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Do you have code in the event handlers that run when the form closes? Have you spelt EventId consistently across the database and code, it's not in your post?

--

Joe
 
Old February 9th, 2004, 12:50 PM
Authorized User
 
Join Date: Feb 2004
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to chacquard
Default

Hi Joe,

There is no code in the Close Event, besides the docmd.close, and yes, i spelt the EventId consistently across the database and code.

Chantal






Similar Threads
Thread Thread Starter Forum Replies Last Post
Object required jpaul VB Databases Basics 5 November 14th, 2007 12:10 PM
object required Request RoniR ASP.NET 1.0 and 1.1 Basics 3 January 8th, 2007 06:53 AM
object required alitoday Classic ASP Components 1 December 28th, 2004 01:17 AM
object required shoakat Classic ASP Databases 7 November 23rd, 2004 07:38 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.