I have a form frmEditAdminDat a.
Its AllowAdditions property is set to No. I thought this meant
the form could not be opened in a manner that allowed the
appending of new records to its source table. But that is
untrue. I open the form from code this way:
DoCmd.OpenForm "frmEditAdminDa ta", , , , acFormEdit
How can I prevent the addition of records to the source
table of a form in Access 97? 2 1480
MLH wrote: I have a form frmEditAdminDat a.
Its AllowAdditions property is set to No. I thought this meant the form could not be opened in a manner that allowed the appending of new records to its source table. But that is untrue. I open the form from code this way:
DoCmd.OpenForm "frmEditAdminDa ta", , , , acFormEdit
How can I prevent the addition of records to the source table of a form in Access 97?
You do this (as the developer of the app) by NOT putting the acFormEdit argument
into the OpenForm statement. There are several ways to override the default
AllowAdditions property setting. You have discovered one of them.
If you want to give an MDB file to others and let them make design changes to it
then there is nothing you can do to prevent edits to a table. If you give them
an MDE and/or implement User Level Security then you have some control over who
can do what.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
<snip>
A very neat an succinct point. Thxvery much. You do this (as the developer of the app) by NOT putting the acFormEdit argument into the OpenForm statement. There are several ways to override the default AllowAdditio ns property setting. You have discovered one of them.
If you want to give an MDB file to others and let them make design changes to it then there is nothing you can do to prevent edits to a table. If you give them an MDE and/or implement User Level Security then you have some control over who can do what. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Iain Miller |
last post by:
Struggling a bit here & would be grateful for any help.
I have a table which has a list of people in it. Each person has a unique ID
automatically allocated by Access but also belongs to one of 5 Groups - call
them A to E. I'd like to generate a further automatic reference number based
on something like Group/Unique ID so when I create a new record Access
creates the Unique ID & I then enter in the group and then Access combines
the two...
|
by: Catherine Jo Morgan |
last post by:
Can I set it up so that a certain combination of fields can't contain the
same entries, on another record? e.g. a combination of
FirstName/LastName/address? Or FirstName/LastName/phone? Or
FirstName/LastName/email?
Or is it possible to allow this but to throw up an alert message? Warning
that this person is probably already in the database? TIA
|
by: DH |
last post by:
I have a VERY basic question about figuring database size. I've inherited a
database which is generally similar to this basic one:
Item, Red, Blue, Green, Yellow
(text), (int),(int),(int),(int)
box, 1,0,0,2
hat, 0,0,0,1
car, 3,0,0,0
This format leads to a lot of zeros in the rows which take up a lot of
|
by: Robert |
last post by:
I would like to know why Access tables are updated immediately upon being
changed (in table view or forms view). It seems to me that, at least with a
single record form, that Access could have been designed so that there would
be no permament change to the table unless specified explicity by the user.
I am aware that you can program around it with unbound fields.
I would like to know WHY it was done this way. If you know why it was done...
|
by: Randy |
last post by:
I want to set up a table where I can enter dates that will prevent data
entry of Dates in the Main table.
I have done this in Approach by linking two tables and setting up a
validation formula IsBlank (Date.Date). After staff enter dates in the
detail table it will prevent dates in the Main table.
How can I do that in Access?
| |
by: Aspnot |
last post by:
Background:
I have a data entry form that is bound to a DataSet. This DataSet contains
9 tables and the form displays data from each table in textboxes, not a
DataGrid. One of the tables in the ParentTable and the rest are children.
For Example:
The form shows the Customer and their most recently added Contact (in
textboxes, not in a DataGrid). When I click the Add button on the form, I
enumerate through all of the DataTables in the...
|
by: filbennett |
last post by:
Hi Everyone,
I'm generally unfamiliar with Access form design, but have programmed
Cold Fusion applications for a couple of years.
I'd like to build a data entry form in Access that allows the
following.
First, the data schema: Three tables are involved. The first is a
PERSONS table which has two fields, SSNUMBER (primary key), and NAME.
|
by: kev |
last post by:
Hi all,
I have created a database for equipments. I have a form to register the
equipment meaning filling in all the particulars (ID, serial, type,
location etc). I have two buttons at the end of the form which is
submit and cancel. After i have clicked submit, the information is
stored directly into my corresponding database table. My problem here
is i need to retrieve back the information submitted to display all the
data that the...
|
by: DWHTHS |
last post by:
Hello, I am quite new to access, but seem to be getting there now. I am producing a database, and I want to make a data entry form that is not bound to a table, as I do not want half completed records to be saved to the database.
I have used a append query for where I have information going into one table, and this worked great.
What I am trying to do now though, is have a data entry form for a main table 1, as well as another table 2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |