Cannot Edit Forms In Split DB

Feb 24, 2015

I have been creating a db, I have split it and saved it to our company's server. We were getting ready to distribute it and start using it when I noticed something on one of the forms that i wanted to change. When I go into the fe to make the revision, it will only open as "read only". I can save a copy to my desktop and make the changes that i want, but then i cant save this copy back to the server because it wont let me over-write a file that is read only.

View Replies


ADVERTISEMENT

General :: Split Database - Cannot Edit Table Design Despite Snapshot Usage

May 27, 2014

I have a split database made in Access 2007. Each user gets their own copy of the frontend from a script. I wanted to be able to edit the design view of the backend tables even if people were using the database so I made all the forms use snapshot source and only allowed data updates through VBA macro update queries. Having any form open locks the backend source table from being edited. In fact, I've found that just having a normal snapshot query open causes the message "Either an object bound to table 'whatever' is open or another user has the table open. Do you want to open the table as read-only?"

Is there some way to have a table be the source for a form or query, but still have it designable under most circumstances?

Attempted to late-bind a recordset on form load; result was the same:

Code:
Set rs = CurrentDb.OpenRecordset("Select redacted as ft from tblRedacted ", dbOpenSnapshot, dbReadOnly)
Set Me.Recordset = rs
Set rs = Nothing

View 3 Replies View Related

Split Access Database Doesn't Load Records In Form To Edit

Aug 23, 2011

I have an Access 2010 database that I have split. In the database I have a couple tables, forms and two reports. I have entered some data into one of the tables, but when I go to edit the data in the form the next time, there is no data (though I have verified that there is data in the table). Also, there are two reports that can pull the data without any problem.

Why the data wouldn't show up in the form.

View 3 Replies View Related

Forms :: Permit Only 50 Group Leaders To Input / Edit Data On Password Protected Forms

Jul 29, 2015

I am building a very comprehensive Membership Management Database with extremely useful facilities initiated by some 20 or 25 Queries..

The database includes 5 Tables which store data relevant to members, another which stores details of Interest Groups and a 3rd which stores which members are affiliated to which Group or Groups.

Currently the database is accessible only by a very limited number of persons and data can be entered/edited by only one person. The database, using Access 2010, is maintained on a desktop computer and synchronized to a copy on a Cloud.

My requirement is to permit some 50 Group Leaders to input/edit data on a Password protected Group Members Form such that that is the only element of the database that they can access. The Forms would have only 2 fields from which the user would select entries from drop down lists.

My query is ; is such a procedure feasible in principle and would I be correct in assuming that the user would require to have available a copy of Access.

View 7 Replies View Related

Forms :: Combining Split Database Or Easier Way To Update Forms?

Aug 5, 2015

I've split my database into a front end and back end which was relatively easy. I did this so that multiple users can have their own front end. But if I have to go in and change the back end and front end, does that mean I have to remake all the front ends? Right now I'm finding that if I delete my linked tables on the front end and then import them into the back end again and change everything on one screen and then split it again is the only option I know of.

View 6 Replies View Related

Forms :: Edit Data Through Form

Apr 23, 2013

I have a simple data base with 2 tables. One table is the pertinent Employee data. That includes a EmployeeID that I contrived myself with the first 4 letters of the FIRST NAME and the first 3 letters of the LAST NAME.

how to make the program do that automatically when I enter the employee's first and last name.I have a form that sits overtop this table to populate the data. It's got some test date in it now c/w hand and manually calculated EmployeeID.

So now I figured out how to make the program do that calculation automatically. So why when I cruse over the records and tab through the fields and the form shows the new EmployeeID, it doesn't update the table for that field?

View 6 Replies View Related

Forms :: Date Edit / How To Save Changes

Aug 22, 2014

I have a field on a form that when a check box is checked then the date is populate in a AddDate field. The problem is if the user edits that field the changes do not save. Below is some of the code, how do I save the changes?

Code:
Me.AddDate = Date
If Me.Dirty Then 'Save any edits.
Me.Dirty = False

View 7 Replies View Related

Forms :: Autofill Form And Allow To Edit

Nov 9, 2013

I have 2 tables StudySchedule and ExamSchedule.StudySchedule contains the detail information of opening classes of many different periods. I need to create a form that can:

1. let the user choose a period

2. form will generates automatically exam schedules of the opening classes of the chosen using the relevant information in StudySchedule. Those entries will be saved in ExamSchedule.

3. Note that there are 8 fields of the exam schedules generated/counted from some fields of StudySchedule. The 3 other fields of the exam schedules need to be entered by the users. User must also have the ability to edit the generated fields.

View 4 Replies View Related

Forms :: Edit Table Through A Form

Jun 30, 2015

I have been developing a form that will allow me to input, edit and delete data in a table.I have the input, delete, clear, and close command buttons working ok, but I am having trouble getting the edit function to work.

What happens is that I highlight the line in the table (shown on the form as a sub form) click the edit command button, and the field are populated with the current data. I then edit the field that I want, and the add, button, changes to Update. When I go to update I keep getting an error message "Cannot update 'ID'; field not updatable.Below is the code I am using, when I go to the debug the arrow points to the "WHERE ID=" line.

Private Sub cmdAdd_Click()
'when we click on button Add there are two options
'1. for insert
'2. for update
If Me.txtID.Tag & "" = "" Then

[code]...

View 14 Replies View Related

Forms :: Allowing / Locking Edit In A Form

Jul 21, 2013

I'm using Access 2003.I'm trying to create a command for a form that will allow editing or lock all fields, so that records are protected from accidental edits.AllowEdits in the form is set to False by default.I've used the below code to allow a user to unlock the form:

Private Sub cmdEditRecord_Click()
If Me.AllowEdits = False Then
Me.AllowEdits = True
Else
Me.AllowEdits = True
End If
End Sub

And this works without issue.However, I want to create a second button to lock the form again.

Private Sub cmdLockRecord_Click()
If Me.AllowEdits = True Then
Me.AllowEdits = False
Else
Me.AllowEdits = False
End If
End Sub

Seems logical that I should just be able to reverse the true/false but this does nothing!I've also tried the below code:

Private Sub cmdEditRecord_Click()
Me.AllowEdits = Not (Me.AllowEdits)
End Sub

To toggle between editing/locked, with the same results - ie, can switch to editing, but can't then turn it off.

View 5 Replies View Related

Forms :: Edit Button With Navigation Control

Oct 21, 2013

I am working on Data entry form where a user can enter the details in the form and save and go ahead, its a single form in default view. I want to provide an edit button with navigation control in this form only where they can edit their wrong record for update.

View 1 Replies View Related

Forms :: Unable To Edit Records Using Combo Box

Mar 29, 2013

I have setup a ComboBox on a form, Listed the PK of the table as the control source. Inserted the PK and many other field as the row source. When I go to select a record I get the error "control can not be edited, it's bound to a auto number field, "Asset_ID"

View 6 Replies View Related

Forms :: Add / Edit New Record Only Continuous Form?

Mar 27, 2014

I have a continuous form with unbound controls. These controls write new records into a table using rec.addnew

If possible, I would like for the user to only be able to add/edit the new record only and not to edit the continuous form below. When I turn off edits on the form, I only get the new record to show. I found some pages that reference using code like .allowAdditons, .allowEdits and .allowDeletions but unsure of how to implement them since I have more than one control the user is entering data into. I also found another site that says to use a control to determine if the record is writable to: I do have a control that is set to =Date() on the default value.

View 13 Replies View Related

Forms :: Cascading Combo Box To Select Record To Edit

Sep 19, 2013

I am attempting to create an attendance database that needs to be able to be updated if someone calls in sick.

I have created a cascading combo box where you can select a date up to 15 days into the past with the following code in the rowsource for cboDate

Code:
SELECT DISTINCT tblAttendance.dataDate FROM tblAttendance WHERE (((tblAttendance.dataDate)>Date()-15)) ORDER BY tblAttendance.dataDate DESC;

an after update event has been coded to show only employees who have been scheduled for the day

Code:
Private Sub cboDate_AfterUpdate()
On Error Resume Next
Me.cboAgentName.RowSource = "Select tblAttendance.agentName, tblAttendance.attendance,

[Code]....

So basically what i need to do is be able to use the cascading combo boxes to select the date and employee to go to that specific record so i can update the other fields. Currently when i attempt to do this with my current form, it automatically goes to a new record when i select a date and name and doesn't update the existing record.

View 1 Replies View Related

Forms :: Select Record To Edit In Form With Subform

Jan 3, 2014

I have created a form (races) with a subform (yachts in a race) to edit data in joined tables. It seems to be working well but I am having difficulty selecting which record to edit in the main form. I can scroll through the records until i get to the correct race but this won't work well when there are a large number of races to choose from.

I can see that I can use linked forms to select a race from a multi form or datasheet and call up my desired form by a double click on the ID field. This should work but isn't really elegant with users scrolling down a long datasheet to select the race record they want to work with. Is there a better way?

Races are uniquely identified by 3 attributes: SeriesDivision, Date & RaceNumber.I have created an index in the Race table for these 3 fields which forces them to be unique.I would love to create an interactive routine which asks users to select from a list for each of these 3 attributes and then returns the form for editing with the appropriate race record selected or even cascading - users select a SeriesDivision can then choose the valid dates for the selected SeriesDivision and can then select the valid raceNumbers for the selected date

View 1 Replies View Related

Forms :: Capture Users That Create And Edit The Records

Aug 27, 2013

What is the best way to capture the users that modify the records in the database?

Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.

View 5 Replies View Related

Forms :: Combo Box Lookup - Edit Customer Information

Apr 24, 2013

I have a sales form that contains a combo box lookup to tblCUSTOMERS. It allows me to select a previous customer if that person is already entered into the system. If the person is NOT in the system, a form pops up to add the customer into the table.

What I need to know is, if the person IS already in the table BUT their address etc. has changed, what is the best way to get to that record to edit it? I'm THINKING a button with a command to go to that customer's profile.

What is the code to open a form to the customer selected in the drop down.

the customer name field is CUSTID

View 6 Replies View Related

Forms :: Setting Add / Edit Permissions On Form Tabs

Jun 5, 2013

I have an Access 2003 database. I have a form with 5 tabs. I want to prevent some users from editing data on some of the tabs.

I added some logic to the OPEN property of the parent form but it does not work. "Object doesn't support this property or method." What is the correct way of controlling access of the data on the tabs?

In the logic below I first determine the user's permission for each tab. If the user has read-only access they will not be allowed to edit anything on this tab. There are 50 fields on the accounting tab and a subform. If possible, I don't want to have to specify each field individually in the code. Plus there are 5 tabs with numerous fields on each.

BTW: [add designer] is the parent form and [accounting] is the tab.

If DLookup("[permission_studentacct_ReadOnly]", "Users", "Contact_ID = " & Forms![Global]![UserID]) = True Then
Forms![Add Designer].[Accounting].AllowEdits = False
Else
End If

View 3 Replies View Related

Forms :: Ready To Edit Appended Record To A Table

Nov 19, 2014

After running an append query, the form created displays a blank/new record. How can I make the form display and ready to edit the appended record.

View 3 Replies View Related

Forms :: Button To Change Form From View To Edit

Mar 12, 2014

I have created a form in Access 2010 that opens in view only mode. I do this as I do not want data being changed in error. There are times when the user may need to edit some data on the form.

Any way to place an "Edit" button on the form that allows the user to edit the current record? I thought about creating two sepasrate forms, but I really don't want to maintain two of them.

View 1 Replies View Related

Forms :: Use Form To Edit Records In 2 Separate Tables

Apr 2, 2013

I have the logical process, but I just don't know how to put it into code.

I have a form with two boxes HireMovieID and HireCustomerID, with a button HireButton.

The two tables which I have are CustomerInfo and MovieList.

Here's the psuedocode for what I need to happen:

Code:
IF HireMovieID.Genre = "R16"
(IF DOB > Today - 16 years)
Display Error: "Too young"
ELSE Hire()

[Code] ....

I need to somehow make it so that the MovieID is valid, as in, if it doesn't exist then it comes up with an Error MsgBox.

View 4 Replies View Related

Forms :: Edit List Item Missing In Accdr

Aug 9, 2013

I have just finished a 6 month long build of an access 2010 app.I have used the publish wizard to make it publishable. This has made the accdb to an accdr file. No my edit list form don't work when you right click.This seems to be an issue with accdr files.Is there a way to have a button on the form that when clicked does same think as the right click option for edit option selected.

View 3 Replies View Related

Forms :: Cannot Get Edit Access In Popup (Confirmation) Form

Jul 7, 2014

I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table that simply stores that one record temporarily.

So when the user is finished entering their current transaction, I have a Save button that actually just opens a popup form which displays the data they entered into the data entry subform, giving them a chance to verify their entry is accurate. This form has a Save button which runs an append query and a delete query, adding the record to the permanent Transacations table and also clearing the temp table.

The problem I have, I think, is that when the popup form opens, the main form data entry subform still has that record locked as exclusive. I believe this is the case because while I am indeed able to make changes to the fields on the popup form, none of these changes appear in the temp table. In other words, the user is not actually able to use the confirmation pop up form to make any necessary edits to their entry. This makes the form sort of useless!

View 1 Replies View Related

Forms :: Two Split Views On The Same Form?

Jan 16, 2015

Is it possible (haven't found a way yet) to have two "split subforms" on a parent form side-by-side? When I try the multiple rows portion of the split view I created as a subform doesn't appear?

Want to have a form when I have search/filter/select record for table 1 (on the left) and table 2 (on the right) with a means in between to create a relationship which has a few parameters.

View 1 Replies View Related

General :: Securing A Database / Can't Edit Forms / Reports / Queries

Jan 21, 2014

I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc.I'm splitting the database, making an ACCDE for users:

1. I inserted code to disable the bypass key.
2. I inserted code to hide the Quick Access Toolbar (QAT) in the On_Load sub of the form that opens with the DB.
3. Deselect Navigation Pane, Allow Full Menus and Allow Default Shortcut Menus are deselected
4. Then, I use the immediate window to show the QAT, I then create an ACCDE.

How do I link this ACCDE with the original ACCDB? Am I supposed to delete tables from the front end and link the forms/reports to the back end DB?

View 7 Replies View Related

Forms :: Using TempVars For Form Open Criteria - New Or Edit Record

Apr 23, 2014

MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record.

Two sets of forms - One set works perfect but the other will not accept the criteria for New Record

MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work.

Just before the If Then, an invalid use of Null message appears.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved