General :: How To Disable / Prevent Overwrite Option In Window From Being Selected
Sep 8, 2013
Creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table in the database using Save As --> Access 2007, selecting the database and target table, clicking save as, and then selecting 'Append' from the subsequent popup.
What I want to know is: Is it possible to disable/otherwise prevent the 'Overwrite' option in this window from being selected? Can I make the table or database in such a way that data can only be added, not edited or deleted?
I'm looking for VBA code.Basically I have a drop down with 3 options on a form but need it to pull up a window to input depending on which option is selected. One selection of the options if selected will not require the input of data, as it can just input a set value or be left blank (haven't totally figured how I want to display it). With all this I will need it to display on a form in a certain format, in which I would like the drop down value displayed with the data inputted, though with the one option without data just would display drop down value.
I use Access 2007.I have a db split in FE(forms, queries, vbcode) & BE(tables only).I want users not to be able to view or explore the tables, the queries, the form design and details, in both Ends.Unfortunately, even disabling via VB code the menus, the db window, the tool & status bars, they appear and are accessible to the users (it only works in a non-split db, turned to an accde).
How can I disable any view on forms, queries, vbcode and tables details and data to users, in both FE and BE and only allow them to add data through specific form?
I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?
I linked table rawdata from a database called competitor from a ODBC Database. I run a query with to make a table with a criteria where it retrieves roughly 10 columns with 719,000 rows. And it gives me this error.
(Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.
I asked the creator of the database and they said the database grows automatically and it was created with the same Access version as i am using to run the query.
Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.
I was hoping someone knows how to disable the ability for users to gain access to the properties window.
When viewing a form (or any object), one can usually right click, click on the corner of the form, or a few other actions and gain access to the properties option. If selected, the properties window is displayed with all the object's properties.
Is there a way to NOT allow the users to select this option? i.e. to disable this option from the menu list?
I have a Access database that is used as the user interface for general users but the data is stored in SQL. My client has asked that general users be able to see only selected fields in the table. This means that they must only use the form to view records and not be able to get to the table.
How do I disable the the Window Unhide in the MDE?
Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?
I have a database that uses a switchboard with a close button that runs several instructions before it exits. The problem is that some users have access to the database window and I need to prevent them from closing the database by hitting the X in the upper right.
I have a Print button on a form, which actually prints off a report for the user. Some of them seem to be trying File-->Print, which actually just prints the form instead of the report and no matter how many times I've told them to use the Print button, they seem incapable of remembering.
Is there a way to turn off the File-->Print option ?
Hi, Newbie needing a shove in the right direction. My option group will be confusing for a user because it defaults to the Male selection of the Male / Female option. In other words, as the user views the form to scroll through the records, the option button will always be at the Male selection, regardless of what was originally selected to update the table field. Is it possible to hide the option group once it has been used to input that record, or, have it display the correct selection for that particular record?
Hi every body . I got a a form and sub form. I want to disable sub form untill the user finishes selecting values from combo box drop downboxes. I be happy if some one show me how to do this.
On my form I have an option group with 4 radio buttons. Depending on the button selected certain fields become visible. This works all fine. Problem is though that I don't know how to store the selected value. At the moment, every time you open the form you have to select the same button to see the info stored in the fields that become visible. I guess that I'll have to somehow store the value for the selected buttons in the table. But How? Do I refer to the frame and store the value corresponding to the number of button (1, 2, 3 or 4) or do I store the balue for each button seperately? I've played with it for too long now and cannot find the golden tip. Please advice.
I have a database where new products are entered into it. Over time there are revisions that are made to these products and to capture this, a drop down box has been added that allows the user inputting the product to select the current revision number of this product.I also have another form which shows the product serial numbers, and then a bunch of fields relating to revision numbers (a check box for each), this can be used by field technicians who can locate older models and tick off a revision when they have updated a product to this specification.
What I am hoping to do is that when the user initially enters in a product and selects the revision number of it, the other form will automatically update (the check boxes) up to and including this revision... so for example if a product is being entered and is up to revision 5 - the check boxes under this serial number on the 'revision' form will all be checked automatically (Revision 1, Revision 2, Revision 3, Revision 4, and Revision 5 check boxes).
I have a Combo Box bound which gets its values from a table (T_Users).
The Combo Box displays the Users 'Initials' [Column 1], but the Bound Column [Column 2] is that of the Users 'ID' (which is used when a record is edited or a new record added).
What I want to be able to do is when the user clicks the Combo Box, and the drop down list 'drops down' the options, I want them to not only see the 'Initials' but also selected other columns - BUT - when the option is selected I just want the 'Initials' to be displayed in the Combo Box.
Code: So, Normal > | ABC |
Dropped Down > | ABC | -------------------------------------------- | ABC (Annabel Carcus, Big Company Ltd.) | | JB (Joe Bloggs, Medium Company Ltd.) | | FS (Fred Smith, Little Company Ltd.) |
I'm building a workCube reservation system and I've been tasked to have it work kind of like an airplane seat reservation system. I've laid out my form with option buttons representing the location of each available space. (space1, space2, space3...space16)
My desired outcome is to be able to select a date from a calendar popup and have the options buttons react to that date if they have been reserved. (change color and indicate "reserved").I've tried to create the form based on a query which represents the "booked" table.
Tables:
Employee (k)empID emplyeeName
Space (k)spaceID space
Booked (k)spaceID (k)empID (k)bookdate
Some rules a space can be booked by any ONE employee on any day.How can I get any and all of the option buttons to react if there is a reservation in place on the day indicated by the calendar?
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
I have set up a database that each user will put on their own computer, as it builds a running list made specifically for that user of chosen items to be exported to Excel, and because the remote locations have issues when accessing a shared network.
The db verifies the network user ID against a table to allow it to open. This to prevent any unauthorized user from accessing, and if db was copied or forwarded, only authorized users could see the data.
If the user is not on the list, it advises "Not an Authorized User", then exits Access. (I disabled the shift on opening, hid navigation bar, etc.) When further testing this security, I realized that even though users can access only the forms that I allowed, if they were to open another Access db, they could link or import the main table.
So all of my security precautions are for naught, as anyone with access to the db could see the confidential data. Even if they were not valid users, they could still get to the data if they knew how to import from another db. Is there any way to lock down the main table, so that it cannot be exported? Or be imported into another database?
On Microsoft Access 2010, I am creating a database project for a DJ booking system (not for professional use) and wondered how you can stop double booking from occurring that would provide you with an error message that I could personalize.
My current booking file looks like this:
Booking ID - Primary Key Customer ID (Linked to customer table) Venue ID (Linked to venue table) Date Booked Set Up Time Start Time Finish Time Party Type Discount Code
At the moment I have the date booked as Indexed (No Duplicates) however this gives me a long error message that I can not personalise.
If you are to sell a db. What have people done to stop one person copying it to their mates.
I have a way in which they send me their name,lastname and email. I then have a separate db that genertates a code based on a maths calculation. The users db does same calc. Then a comparison is done. if they match the code they entered goes green. if codes not right it goes red.
I also have macro that swap tables round when run. so by default its limted to 10 records. When swapped its unlimted.
I just cant link the 2 functions. Ideally some way it will see the green code and then run the macro to swap tables to a full db.
Then the customer has a full db and is also tied to their name etc...
Is there away in which I can protect an access 2007 database modification with a password.I'm doing this because I would like to prevent my client from modifying or having acces to the database's back end system (db), I would just like him to use forms and nothing else.
