I set my form in Design view to Allow Edits but not Additions, and when I switch it to (or open it in) Form view, all the combo and text boxes and buttons disappear (the background color and header are all that's left).
All I want to do is edit existing records through the combo boxes. How can I correct this?
Hi all
At the moment I have a form which links to a table, one of the columns in the table is called "Description" so the user can input a sentence or two. Basically I when I open this form (in Edit Mode as Im using a Switch Board)it will not allow me to edit a current record.
I can edit a record in the tabel but not in the form.... :eek: .. help
Any help would be superb
Cheers
I have a very simple form that is populating fields with records from a number of tables (not queries).
I have found that I cannot edit any of the records from the form. Almost all of these fields are NOT key fields. When I click in the field, it simply selects the text in the field, but does not allow me to alter it (typing does nothing...the cursor just blinks). The same thing happens for blank fields.
I know this is a simple question, but I can't find the answer in help or searching this forum. I know it must be a simple setting (I think) somewhere but I've tried a number of settings in properties/forms.
Thanks,
Kelly
From the mainform "Home" the "Order Details" Form is launched and changed to Design view. Here I cannot edit the "Order Details" form Property Sheet unless the "Home" form is closed.
Why this restriction is enforced?
Hi Guys
I'm trying to create a database application which logs the number of times which i do a certain task.
Is it possible for me to create a button within a form that will increment the value with a particular field by one?
I have searched the net but can't find anything.
Thanks
Matt
I have a form to edit records. When I open the form I am not able to change any of the fields until I edit a date field that has a calendar popup on the "on click" event. After that all of the fields are available for editing. Any ideas??
Thanks,
Pat
I have a button in a form that needs to change the text in a field named idStatus from "Assigned" to "Returned"
I have tried using an expression like this "[Form]![Field]=12" in the OnClick spot but it returned an error. There is no "custom made" wizard for this and my VB skills are lacking.
Once again, thanks! (I know I post alot but this forum is amazing!)
Dear access experts,
I created form based on a query of around 7 tables, all the fields are set to
enabled and edits are allowed; however, access wont allow me to edit any of
the fields in that form! I know that the query is correct because i can flick
through the records and the fileds change.. please help:eek:
Just a general query about the best approach to take for an editing form.
I want to have two separate forms, one for adding a new record (have completed this) and one for choosing and then editing a selected record.
I have seen that people use combo boxes to display a list of records with fields. This seems quite difficult to use. Maybe that's the best way though?
How do you apply an edit button to a selected record in this type of situation? I suppose really I need a box that has a list of records with a little edit button next to each one, or can I do something that launches the edit form as soon as you click on a specific record?
I have a Form that is used for creating entries to fill a table. On the same Form there is also a list that shows everything in the table and a double click on the list will populate the Form with that data. The problem is that "Save Record" command button will not update the table because it thinks it is creating a new record.
The code to populate the form from the list is
Private Sub EmployeeEntryList_DblClick(Cancel As Integer)
Me![Number] = EmployeeEntryList.Column(0)
Me![EmployeeNumber] = EmployeeEntryList.Column(1)
Me![FirstName] = EmployeeEntryList.Column(2)
Me![MiddleInitial] = EmployeeEntryList.Column(3)
Me![LastName] = EmployeeEntryList.Column(4)
Me![Supervisor] = EmployeeEntryList.Column(5)
Me![Group] = EmployeeEntryList.Column(6)
Me![Shift] = EmployeeEntryList.Column(7)
End Sub
how I can make it populate the form if an entry is double clicked and then be able to save a modified version of that record over top the original.
Hello,
I am a relative newby to Access, Can someone please offer a solution to my problem.
I have a DB which lists current order references, I also have a linked spreadsheet from a customer which references their Ref number to our S/order no & Item no.
I have set up the relationships for the common data between both tables.
if I create a Query from either table individually the data can be edited but when a query is created from both sources the data cannot be edited.
this also happens if the spreadsheet is imported to its own DB.
I would really like to create a form which displays both sets of data for editing, marking progress etc.
Can data from linked tables be edited in a form ?
Regards
Andy
Hi All
I'm trying to set up a form to log my clinical placement, and the number of time i undertake a procedure.
I want to have a list of a few procedure(fields) and then button next to each one in a form which will increment the number by one
How do i go about doing so?
I have many forms in my database, three of which completely freeze the database if I edit the slightest thing on them. These forms are all the same, and are unique to any other type of form in my database.
An example of one of the forms is the following:
The form is an "Edit Record" form which allows the user to edit a record directly from a form without going into the table. It is only possible to bring up the edit form by going to the main navigation form that consists of various buttons which a user would press, in this case the user would press the "Edit Record" button. This brings up a unique search form that allows a user to search for a record to edit. The user types their search parameter into the form and once the "search" button is pressed it will bring up the record with all the details in a different form.
Note - The search form is linked to the table where the edit record form is linked to a query.
My problem is this:
I have three buttons on the form; Exit, Cancel & Finish Editing.
All I wanted to do was to ammend the code of the buttons so that "Finish Editing" wouldn't close the form onced pressed and that "Cancel" would simply undo the actions of the user instead of undo and then close the form.
I know exactly how to do the ammendments. But, once completed if you return to the main navigation and click on the "edit" button the search form appears and allows you to type in the search parameters, but once the "Search" button is clicked the search form closes and you are returned to the main navigation where you are unable to click anything in access or even close the programme.
I have produced a table, the records from which have to be selected by individuals for auditing purposes.
I created a second table with individuals initials and passwords. This is linked by the initials to the main table. Records on the main table are returned when the query is run.
At first I could not edit fields in the query but changed the recordset type to Dynaset (inconsistent). I am now able to edit the query fields. However, having created a form based on the query, I am unable to edit the fields in the form. This is the basis that the auditors will use to score so is vital. Have I missed any other switches or techniques?
I have a table fed form that will not accept editing to the filter statement.
Currently the filter is [Dealer Name]='ABC Company'
This is causing a problem because we have multiple locations with the same Dealer Name. They do however, have different Primary Account numbers.
I thought to edit the filter to [Primary Account]=102
However, after I save everything and go back to form view, the filter reverts to the original.
In A2010 I maintain a database originally created in A2003. The original version was locked down tight. In A2010 I struggled to do the same but got there in the end, as well as allowing me a back door way in.
Now I have an unexpected problem - in the object browser (or whatever it's called) on the left hand side I can no longer copy any object. EG, I want to copy a form for safe keeping while I edit the original.
I have a Multi-Item form and would like to do some math and change formatting on some fields depending on content of data in each row. From what I can tell, the on Load even only lets you do something with the first row and does not execute the VBA code for any following row. I don't see any way to trigger the VBA code on a row-by-row basis as the form is being painted.
Any technique to do this or do I have to go to some other form type to do some dynamic formatting?
I have a form that I need to use to add new clients to a table in my database, lets call it tblClients. On this form I have a combo box which, when selected, will drop down with the first and last names of all clients in tblClients, as well as their Client ID. Once you select a client from the drop down menu, it populates all of the fields in the form with that clients info (Client ID, fname, lname, address, phone number, etc. etc.).
I need two other things on this form: one button that will save or modify whatever current record is currently pulled up, and one button that will start the process for entering a new client, so basically it would blank out all of the fields and fill the Client ID field with the current number +1.
As of right now I have the form made and the combo box works, in that I have 3 dummy clients in the tblClients and when I select each client from the combo box it will populate the fields on the form with the info. I'm using some simple VBA on the combo box such as
Me.FirstName = Me.cboBox.Column(1)
and that seems to all work, but the problem is trying to save/modify data to tblClients. The only record in the actual table that gets modified seems to be the first record. For example, if I pull up client with ID #3 and change his address or phone number, what happens when I click to save the changes it takes client ID #3 record, overrides it with client ID #1, and then client ID #3 is the same as client ID #1 except with the old information. I'm not quite sure why this is happening.
I have a form with several subforms within (tabbed subforms). I've used the code:
In the Current event of the parent form -
Code:
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
In the Current event of each of the subforms -
Code: (THIS NEVER WORKS FOR ME - RUNTIME ERROR)
Me.AllowEdits = Me.Parent.AllowEdits
Me.AllowDeletions = Me.Parent.AllowDeletions
Me.AllowAdditions = Me.Parent.AllowAdditions
In the Click event of the button -
Code:
Me.AllowEdits = True
Me.AllowDeletions = True
Me.AllowAdditions = True
So the main form is locked upon opening and unlocked with the click of an unlock button. How to apply this to the subforms as well. They just stayed unlocked the whole time.
So, I hope that i'm just making a simple error, because as far as I know this should work!
I have two tables. (and i'll just simplify it because the other info isn't necessary to aide me!)
tblProduction
ProductionID - Autonumber - PK
ProductionLocation
tblStorage
StorageID - Autonumber - PK
StorageLocation
ProductionID
Now. I have two forms. One is frmProduction and the other is frmProduction_Stored.
A user inputs in the frmProduction form and then has a drop down that determines the "disposition" of the items produced.
Once that disposition is selected it will open up one of three forms(depending on the value selected), in this example it is frmProduction_Stored.
It then opens up that form and fills in tblStorage.ProductionID with tblProduction.ProducitonID. And then the user can fill out the rest of information required for tblStorage.
But, the problem i'm having is that the records are not getting created in tblStorage. I have created the relationship and tried different things and have found out that they do NOT create only IF i have "Enforce Referential Integrity" selected on the reltionships! Otherwise, it creates the records perfectly fine, with the right ProductionID on tblStorage, but then the relationship isn't appropriate.
hmmm
Any ideas how I can fix this problem and make tblStorage create the records, with the right relationship?
Thanks!
My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.
My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....
As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.
Hello,
I've got a somewhat urgent question;
When i'm editing in my database other users can't open the database and when they have the database open i can't edit it.
Is there a possability where i can make it possible to enable me to edit while others are viewing, something like a developers database and a user database that update eachother?
Hi there,
We have a 2003 ms access db that has multiple users 24 hours a day. There are two developers and changes being made all the time to the front end which is on a server.
The ONLY reason we need visual source safe (IF AT ALL...see below) is to be able to make changes even though not in it exclusively. We used to be able to do this with access 97 but not since we upgraded. We get the message: you do not have exclusive access to the database at this time. If you proceed to make chagnes, you may not be able to save them later"
And we never can even if someone is not even in that particular form.
It says: use microsoft visual sourcesafe add-in for microsoft office access"
Is this JUST an addin or do I need the software? I'm not sure what to do and I don't think we need all of the features of the full version.
Could someone advise the best way or where to get what we need?
thanks
Evening all,
I used to program access db's many years ago but it seems that I have forgotten my stuff and need some help.
I have 2 mdb's. One labelled client and one labelled server. They have been copied from an old workgroup network onto a new domain environment, but the problem was the plonker that moved the data did not think about the impact of the database.
Problem I have is when I open the client mdb now, I get the front form but none of the buttons work because it is looking for a network path for the server.mdb which doesn't exist. To add to this I don't know how I can edit the client mdb with the new network path as it removes the bar at the top so that I can't switch into desgin view etc.
Can anyone help?
Thanks in advance,
Abbos
how do i edit a report
i'm new to access
i'm working with this database that will output a report(letter in word document) when the user clicks on a command button
i'd like to edit the letter but i don't know where it's stored.
could someone please show me how to access the report
thanks
I created a database a while back. It was complete to my standards at the time. I split it FE and BE to protect the data.
Since then, I have made several changes on my machine to the user interface and some of the back end tables and queries.
How do I insure that these changes are seen on all the different computers on my network?
They only seem to exist on my personal machine.