Hello Experts..
Im checking out the other side of the tracks here.. always been a Systems Analyst kind of guy. Developers are a touchy and unpredictible lot. I try to give them their space and never poke my finger into their cages. I was sad that Steve Erwin didn't do a spot on Developers before he left us..
Anyway.. Figured I'd be doing pretty good for myself if I could find some assistance here, then back out before I got eaten alive.
MS-Access 2003 w/ Sp1 on Windows XP Pro
Got a pretty table and a form too. The form has a combo box which displays the records associateed with combo box selection. Cannot prevent accidental changes to the records. Want users to VIEW only. NO TOUCHY Da Data. (users is so stewpud)
For editing ..my switchboard has a button which runs a macro to open the table for editing. But when 'viewing' thru the particular form mentioned above, i need the records locked down. No Edits. No Additions. No Deletions.
I've hacked at this for a couple days now. None of the results are what Im after. This has to be an easy fix.. right? ..Christ, I probably sound like a user? Im dead meat.
3 4883 Rabbit 12,516
Recognized Expert Moderator MVP
The problem with the standard switchboard is that it doesn't allow you to open a form in that manner. A work around is to create a copy of that form and set those properties that you listed and open that form instead.
Personally, I prefer to create my own switchboards. I actually didn't know that Access had a switchboard wizard until well after I've been developing for a while.
Thanks Rabbit
When I set 'allow edits', 'allow deletions', 'allow aditions', to NO, I can no longer make a selection from my combo box. It drops down, and I can see the list, but it will not allow me to make a selection.
It makes sense, as these properties are for the form, not the record data populating it. Setting these attributes protects my record data by locking the form into a useless state.
This is one of the undesirable results I achieved in earlier attempts.
Of course I can set the DB to read only, but then I can't edit when needs be.
Perhaps there is something I can do using 'On Dirty'..?
Rabbit 12,516
Recognized Expert Moderator MVP
Thanks Rabbit
When I set 'allow edits', 'allow deletions', 'allow aditions', to NO, I can no longer make a selection from my combo box. It drops down, and I can see the list, but it will not allow me to make a selection.
It makes sense, as the data in the form fields are locked down nice and tight, however, its locked down on the initially displayed record and will not allow me to even make a selection from my combo box. It must be interpreting the selection as an edit.
This is one of the undesirable results I achieved in earlier attempts.
You can set Allow Edits to Yes but lock the rest of the controls individually through the Locked and/or Enabled property. You can select all the controls but the combo box and set all the properties at once.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Dave Smithz |
last post by:
Hi there,
Working on the PHP DB I took over I have just come across a problem. When
the user presses refresh in some circumstances the command they just
performed will be re-performed. In some cases this is very undesirable.
Further example:
There is a PHP page in my web application that has a text box and the
ability to add a note to...
|
by: Vic |
last post by:
Dear All,
I have a database of laboratory records in Access 2000. There is one
form which acts as an interface to input experimetal data. This form
incorporates information from several tables. I have a flag (yes/no
field) indicating whether a particular experiment (one record) is
completed (ie all data belonging to that record is inputted...
|
by: Tom |
last post by:
hello
i have 2 tables linked by a common id. The first table has records
with a specific field with numeric values. eg 3 or 6 or 10 etc. What i
want to happen is when i create a data entry form, i can scroll thru
each record and when a value such as 6 comes along, the second/child
table allows for 6 records to be created based on the same...
|
by: MLH |
last post by:
I have a form frmEditAdminData.
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 "frmEditAdminData", , , , acFormEdit
How can I prevent the addition...
|
by: Daniel Walzenbach |
last post by:
Hi
I am faced with the following problem: I have a page (let’s call this page page1.aspx) containing some TextBoxes and a hyperlink which opens another page (let’s call this page page2.aspx) as a popup using either window.open or window.showModalDialog. Since I want to warn the users of my application when they try to close page1.aspx and...
| |
by: Peter Proost |
last post by:
Hello group,
what would be the best way to do the next thing: I've got a grid form with
about 15000 records, when I double click a row a detail form is opened and
the user can modify and save the record, this all works just fine, then the
user closes the detail form and ofcourse I want to show his modifications in
the grid form, but now my...
|
by: Charles Law |
last post by:
Here's one that should probably have the sub-heading "I'm sure I asked this
once before, but ...".
Two users are both looking at the same data, from a database. One user
changes the data and commits it. How does the other user get the updated
view without polling for changes? Is there some sort of callback mechanism
that can be set up on...
|
by: shriil |
last post by:
Hi
I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night) and the 'employee
name'. There is another table which assigns an ID to the Shifts, i.e.
1,2 and 3 for morn, eve & night shifts respectively. From...
|
by: jbrumbau |
last post by:
Hello,
I have been successfully using a database I've created for several months to populate an equipment list for a project we've been working on. However, the form has recently stopped working for some unknown reason. I've been having a problem recently where one table (Project Info) keeps auto-incrementing when I try to create a new record...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |