I have created forms that allow me non-read-only access (I can add and
modify existing records) with no problem. There is a point where you are
asked what access level you desire on the form. You state that you did
not set this. What did you chose for this question?
Open your form for editing.
With the form open, open the form navigator.
In the form navigator, right click on the main form and choose properties.
Click on the Data tab.
Does it say that you can edit/add, etc.... the data?
Check this for each contained form if required.
Robert Adkins wrote:
I am testing the feasability of using Base for building an
inexpensive roll-my-own data/invetory tracking system and I seem to be
running into a snag.
I have created a very basic two table DB consisting of Vendors and
Salespeople that work at the various vendors.
So far, the tables work fine, joining them together in a Query
worked fine as well.
The problem is creating the forms.
I built a Query consisting of most of the fields from both tables
and added buttons for next, previous, create additional records, save
the current record and also delete the visible record.
This was performed using the wizard form creation and during that
process, I did not choose any of the options specifically stating that
the form would be unable to add/change records.
After saving the form, closing the editing window and then
reopening the form in order to start adding in records, I am provided
with a (Read-Only) message at the top of the screen and I am only able
to view the few records that I have previously added to the DB.
At first, I figured that there might be a problem with the
construction of the tables, since my rough construction would allow
for the creation of multiple copies of the Vendor company name. (I
know, bad design.) So, I created another Query, this time consisting
of just the Vendor information and created another form for that Query.
I created this new form using both the explicit "This form is to be
used for New Data Entry only" (It won't show existing data) and the
second option which will show all existing records and provide options
to deny the changing of records or the entry of new records.
In all cases, I am unable to use the Forms to enter new data into
the tables. None of the buttons, besides the Previous/Next buttons
will function within the form itself or in the toolbar at the bottom
of the Form window.
Am I missing something or is that a currently broken piece of Base?
Thanks for any answers,
Robert Adkins
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
