Unclear Data Entry Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used wizard to design me a form that pulls from several tables. I wanted
the form to be a data entry form so I went to the form's properties and put
Yes under data entry. However, when I open the form it still shows all of the
information in the tables. I have done this with other databases and it has
never been a problem. Please help!
 
Tandy said:
I used wizard to design me a form that pulls from several tables. I
wanted the form to be a data entry form so I went to the form's
properties and put Yes under data entry. However, when I open the
form it still shows all of the information in the tables. I have done
this with other databases and it has never been a problem. Please
help!
Click to expand...

Are you sure you saved the form with its Data Entry property set to Yes?
Does this happen when you open the form by double-clicking it in the
database window, or only when you open it from code? If from code,
please post the line of code that opens the form.
 
Dirk,

Hello again! I went and double checked my Data Entry property was set
to Yes and it was. This happens when I open the form by double clicking it in
the database window. I do not know how to open it from code. Thank you for
your help. I can't seem to thank you enough.
 
Tandy said:
Dirk,

Hello again! I went and double checked my Data Entry property
was set to Yes and it was. This happens when I open the form by
double clicking it in the database window. I do not know how to open
it from code. Thank you for your help. I can't seem to thank you
enough.
Click to expand...

Sure you can -- consider it done. <g>

As for this form, could it be that what you are seeing is a subform on
the main form you're opening? The only other possibility I can think of
at the moment is that there could be some code in one of the form's
events that is changing the Data Entry property. Does the form have any
code in its module?
 
Dirk,

No, I never added a subform into the main form. I looked at my form's
properties under events and there were no event procedures. I also looked in
it module and there were no codes. I also went back and tried doing this with
an old database and found out that I hadn't actually done it before.
Oppps.That's OK though. I'm already working around it. I guess I will let you
slide on this one. ;)
Thanks!
 
Tandy said:
Dirk,

No, I never added a subform into the main form. I looked at my
form's properties under events and there were no event procedures. I
also looked in it module and there were no codes. I also went back
and tried doing this with an old database and found out that I hadn't
actually done it before. Oppps.That's OK though. I'm already working
around it. I guess I will let you slide on this one. ;)
Click to expand...

No, you really shouldn't let it slide. The Data Entry property should
be respected, and I've never heard of an exception. Please post all the
properties from the Data tab of the form's design-view property sheet.
Or else, export the form and its recordsource tables into a new
database, compact that database, compress it using a zip utility, and
send the zip file to me at the address you get by removing NO SPAM from
the reply address of this message (or, if you can't see that address,
you can get my e-mail address from my web site).
 
Dirk,

Here are the properties from the Data tab of the form's design-view
property sheet:

Record Source: SELECT [Employees Table].[Employee ID], [Employees
Table].[Last Name], [Employees Table].[First Name], [Employees Table].[Middle
Initial], [Employees Table].[Social Security Number], [Employees
Table].[HCE], [Annual Salaries Table].[Salary Year], [Annual Salaries
Table].[Annual Salary] FROM [Annual Salaries Table] INNER JOIN [Employees
Table] ON [Annual Salaries Table].[Employee ID]=[Employees Table].[Employee
ID];
Filter: Blank
Order By: Blank
Allow Edits, Filters, Additions, Deletions: Yes
Data Entry: Yes
Record Type: Dynaset
Record locks: No locks

Sorry, I don't feel comfortable transferring anything over the internet. But
thank you for your help.
 
Tandy said:
Dirk,

Here are the properties from the Data tab of the form's
design-view property sheet:

Record Source: SELECT [Employees Table].[Employee ID], [Employees
Table].[Last Name], [Employees Table].[First Name], [Employees
Table].[Middle Initial], [Employees Table].[Social Security Number],
[Employees Table].[HCE], [Annual Salaries Table].[Salary Year],
[Annual Salaries Table].[Annual Salary] FROM [Annual Salaries Table]
INNER JOIN [Employees Table] ON [Annual Salaries Table].[Employee
ID]=[Employees Table].[Employee ID];
Filter: Blank
Order By: Blank
Allow Edits, Filters, Additions, Deletions: Yes
Data Entry: Yes
Record Type: Dynaset
Record locks: No locks
Click to expand...

Unfortunately, I don't see anything there that would explain your
problem.
Sorry, I don't feel comfortable transferring anything over the
internet.
Click to expand...

Not even dummy, test data? Suit yourself. I can't explain or fix the
problem with the information available to me, and I don't know what else
to have you check.
But thank you for your help.
Click to expand...

You're welcome.
 
Back
Top