Data stored in form

hi,

On 28.01.2010 22:47, Linq Adams via AccessMonster.com wrote:
Ah, come on John! I wanted to see how big a hole Stefan would dig for himself
trying to get out of his statement that yes, forms can store data!
This is way to easy: Using a self-modifing code behind module... Not
nice to see, but possible to do so

mfG
-- stefan --

On Thu, 28 Jan 2010 13:34:02 -0800, Peter
wrote:

Well, the form name is "Customer Information."

Under the form properties window, data tab, the record source is "Customer
Information"

In that case select Tools... Options... and check the "Hidden Objects" and
"System Objects" checkboxes. I'm not sure where these options are in 2007, but
they're somewhere behind the Office "medallion" button.

Then look in the Tables and Queries window and see if there is an object named
"Customer Information".

I'll gladly take your database and migrate it to SQL/Server free of charge if
there isn't *some* object (other than the form) of that name.
--

John W. Vinson [MVP]

Duh!

/bangs head against wall

That was it! Thanks everyone!

"Bob Quintal" wrote:

=?Utf-8?B?UGV0ZXI=?= wrote in
:

Well, the form name is "Customer Information."

Under the form properties window, data tab, the record source is
"Customer Information"

I'm pretty confused by the situation.

Peter

Access is quite happy to allow a form, a report, and a view (either a
table or a query) have the same name.

If you cannot see either a table or query with this name, check the
Tools-Options-View-Hidden Objects box to see it.

Bob

"John W. Vinson" wrote:

On Thu, 28 Jan 2010 12:12:05 -0800, Peter
wrote:

Thanks for answering.

It really looks like this form is storing the data. When I
right click the top left corner of the form screen (from design
mode) and select 'Datasheet View', it is populated with all of
the data that is in each of the 10,000 records that display at
the bottom of the form.

It just seems like such an odd way of doing, and when I tried
upsizing, the table and data was never added to the newly
created SQL database.

I had tried the upsizing wizard yesterday and this is how I
began to discover this.

I'm absolutely and unequivocally certain that the data is NOT
stored in the form. Access simply doesn't *do* that!

Open the form in design view. View its Properties. What is in the
form's "Recordsource" property?
--

John W. Vinson [MVP]
.




--
Bob Quintal

PA is y I've altered my email address.
.

"Rob Parker" wrote in
:

First, and most importantly: forms do NOT store data.

While correct technically, it's possible for displayed data to
actually be in the form, e.g., in the RowSource of a combo/listbox.
That's not what's going on here, and I think it's almost always a
mistake for RowSources of combo/listboxes to be anything other than
SQL strings or callback functions, it is certainly the case that
there can be data stored there.

All that said, it's clearly not what's going on in this case.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/