Non Editable Queries
Nov 3, 2006What will cause the results of a query to be uneditable? One to many relationships?
Sometimes they are editable, sometimes I get that fantastic *ding whenever I try to edit the results of a query...
Thank you!
ADVERTISEMENT
Make A Checkbox Editable On A Non-editable Form??
Dec 28, 2004i have a form that doesn't allow edits... but i also have an 'inactive' check box.. how can i allow this to be editable.. without the rest of the form editable? thanks.
View 3 Replies View RelatedNon Editable Query
May 15, 2007Hi mates!
I want my query to be displayed only and no one can add/edit/delete. How can I do this?
thanks
mithani
Editable Form
Jun 30, 2005Hi. I created a form to be used for editing records. It displays ALL records in a "Files" table that match the BoxNo entered on a previous form. The record source is a query which has a relationship between the tblBoxes (one) and tblFiles (many). The records are showing in the form correctly but it will not allow me to edit.
I have set the allow edit, addition, deletion properties of the form to YES, and data entry to NO. Fields are not locked, and they have active tab stops. I also tried using VBA and set the datamode to edit.
Help please!?!
DJP
Not-editable Combo
Oct 24, 2005how can i make the combo like the user cannot enter the vales into that?
i want the user to only select the values from combo.He should not be able to enter values into it.
Editable Textbox Creation
Jan 16, 2006I have a continous form bound to a query which also has a group by function. Is it possible to create an editable bounded textbox because Access is giving a message saying recordset not updatable.
View 2 Replies View RelatedLooking For An Editable Varient Of DLookUp
Feb 16, 2006I've been using DLookUp in controls on forms, for instance, the control source would be:
=DLookUp("[BookPrice]","[BookBeltInfo]","[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]")
I'd like to put some sort of direct SQL statement into the control source so that the displayed value is directly editable. I.e., the user can type in the control to directly change the value in the proper field. As it now stands, the user is told, "Control can't be edited; it's bound to the expression..." How can I get something like:
SELECT [BookBeltInfo].[BookPrice]
FROM [BookBeltInfo]
WHERE [BookBeltInfo].[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]
to display directly so that the user can edit the field through the control in the form?
Can't Seem To Add Any Editable Text Boxes
Aug 31, 2006Hi
I have a form which retrieves and lists data from a query.
I need to add 2 textboxes on the end, which allow a user to add comments about the particular record, which are then saved directy to the database.
Unfortunately, the query has joins in it so it is impossible to have the data directly linked to a particular record in the database as per the following detail:
http://www.access-programmers.co.uk/forums/showthread.php?t=61901&highlight=query+multiple+source+update
So, any ideas about how to go about this? Ideally, it all needs to e on the same form.
Thanks.
Populating An Editable Text Box
Sep 22, 2004I have a complex problem:
I have a form that displays the result of a query in a listbox (lst_dp_results).
Upon selecting a result in the listbox other data about the selected record is displayed on the same form in listboxes
Code:Private Sub lst_dp_results_AfterUpdate() With Me.lst_dp_productname .RowSource = _ "Select M_Paint.Product_Name FROM M_Paint " & _ "WHERE M_Paint.Catalogue_Code = '" & Me.lst_dp_results & "'"End Sub
As all these fields are listboxes displaying a single value based on the "rowsource" string, they are not editable.
I will like to have these as textboxes instead of list boxes but I guess textboxes do not have anything like 'rowsource'...
Can anyone suggest some method to display value from a field in a textboxt AND be able to edit it??
What Feilds Should Be Editable From Website?
May 10, 2005Hi every body. I have an access database that u can see the tables and their reletionship in the link i posted.
I would like to web enable this db and would like to get some suggetion on what fields should i allow to be edited and what records should i put delete option for? In order to keep the refrential integerity of the acces db.i be happy to get some feed back from u guys.Thanks
http://i5.photobucket.com/albums/y180/method007/dbreletionship.jpg
Editable Default Value From Lookup Module
May 22, 2006I'm still learning here, so please don't get annoyed if I don't know what I'm talking about.
I have a Module that I created that looks up a value in a table.. It is shown below.
Public Function DescLookup()
DescLookup = DLookup("[Projdescription]", "ProjDescTable", "[OrderN] = [Forms]![Production]![ProjIncList]")
End Function
I want this to be the default value for a field, however I want the field to be editable and I will later have a button that calls on an update query that will update the field with whatever changes are made to the Text Box, however when I set DescLookup() as the default value of the text box, it will not let me edit the text box in the form.
Am I describing this correctly? Can anyone help?
How To Make Fields In Form Non-editable
Mar 6, 2007Hi,
how do i make the fields in my form uneditable(cannot delete or add but can copy a field from form), i tried setting the properties..allow additions deletions by setting it to no, but even then when i open the form and when data is dispalyed , if i go jus delete (say address field)a field it just gets deletd,
i tried locking the fields too!..nothing worked,
so how do i do this,?
p.s IF i set allow edits to No then i am not able to copy the field (say name has to be copied and pasted into another application or something) how could this be accomplished.
tried setting it in VBA as formname.form.allowdeletions=false , still no luck!
Pls help!
Thanks!
Combo Box Determines Editable Record
May 10, 2007I have a combo box on a form where the form record source is a query with criteria consisting of the value of the combo box, and the combo box row source being all the values in the table for the field I want to select (EMP_NAME). I know about using requery in the AfterUpdate event, but despite that, none of the display fields ever have any values showing for the record I select. Any help at all would be appreciated.
I'm working with Access 2003, btw.
Steve
(aka sgmunson)
(860) 741-7600
Forms :: Allowing Editable Data
May 29, 2014The first relates to the fact that in the crosstab is a field that is set to Yes/No. It appears as a textbox with a value (0 or 1) in it. I want to replace this with a tickbox but when run neither the textbox nor the tickbox will allow any changes. Is it possible to set this to be editable? I cannot see how this would relate back to the actual data table but if it is possible then this should become clearer.
The second issue relates to the fact that the crosstab obviously creates the number of columns in relationship to the maximum number of values of the relevant field. So, I have a field that can have values from 1 to 15 but in most cases the actual value runs no further than 9 and 10. So for those records where the maximum number is not being used I want the unused tickboxes NOT to appear. Again, is this possible.
In connection with the second, if I have (as I do) this group of 15, which is in fact made up of 3 groups ranging from 1-8, 1-4 and 1-3. So number 8 may not be required in the first group and numbers 3 and 4 in the second. I would prefer there not to be a strange gap between the datasets when run. Is it possible to set up a continuous form so that all the potential boxes are in place, that I run code on load that puts the values in from the query, hiding the end tickboxes and so collecting the groups together - then allowing the changes to be detected through code and re-assigned to the table?
Editable Form With Select Query
Dec 17, 2013I have a form with split view and data it taken from different table using join query, is there any way i can add edit form data and original table data gets changed.
View 2 Replies View RelatedMaking Access 2000 Forms, Non Editable
Jul 17, 2006Could anyone out there tell me if it is possible to make the output on an Access form read only.
I want to be able to input information as records, but when it is saved I don't want it be able to be altered.
Mainly I am saving recipes on a form, and I don't want my children to be able to add anything to a record once it has been saved.
Thanks in advance
Ken
General :: Calculated Field Editable On Form?
Jun 20, 2013So i have a Calculated field in a table which is an expiration date. It adds two years to another field. Both field are on a Form. make the calculated field editable because some of the expiry dates are not necessarily 2 years. How do i change this?? do i need to like code it? i have no clue how to even start.
View 1 Replies View RelatedAccess Subform With Additional Field But Not Editable
Nov 16, 2014I created an instructor form with a sub form table on the bottom - [pic at the bottom] I would like to add columns in the subform from the instructor_info subform but it should not be editable, just display it as per the column relationship key, and the relationship key for the 2 tables (instructor_info & course_table) is course_id.
Course Table
- Course Date (instead of Course)
- Course Location
- Station Demo
- No. of Teachings
- Hours Taught
Instructor Teaching Info Table
- Instructor ID
- Alone
- Course
- Course Date
- No. of Teachings
- Course Type
- Notes
Setting A Field To Editable Based On Windows Login
Dec 18, 2006I have a field within a form, which I want all the users of the database to see, but I only want it to be editable if your windows logon name is one of the following:
kleaves
jbloggs
Jsmith
I know I can use the environ variable - environ ("username") and I think I should set this code under the properties of this field possibly the on click setting. Can anyone help?
The reason why I want to do it by Windows logon as this form is widely used by many people and there is no logging into the form at startup. I currently have set the changing of this field to be recorded in a historical view, But I still need to restrict the entry to this field.
Forms :: Possible To Make Pass Through Table Editable After Filter It?
Jan 8, 2015So what I have created is a form with 4 combo boxes which filters a subform with a click button by running a sql query.It was working great yesterday but then when I made the subform a pass through query it seems to no longer run (or just runs so slow it takes a large amount of time to query). To get a better sense of what I'm talking about I basically have a button and inside of the button it takes this query template:
SQL = "SELECT * FROM queryname WHERE 1=1"
concats with if statements to the end of the Where clause with the values in the combo box and then sets
subFormName.Form.RecordSource = SQL
how I can get this table to query...Also, for my second question, is it possible to make this pass through table editable after I filter it?
How To Make Autocomplete Form With Editable Subform Underneath
Apr 18, 2012I am making a library database which would be used in a school. I need to make a form which allows me to type in the persons id number then the persons profile will come up automatically then underneath there will be the persons book loans in a subform which i dont know how to do ...
So the top bit will have the persons details like personid, surname, first name, tutor group and then below there would b a subform with fields in from two different tables like from the book table there will be author surname, author firstname, bookname then from the loan table there will be the date the book was loaned field
The subform would also have to let me edit it so that i can add new loans or remove loans which i also dont know how to do but i was thinking if i had to add new records of the book would the subform have to autocomplete too? to save time typing all the details of the book
so so far i have made the tables added some test data and made relationships between the tables
a person can have many loans
a book can have one loan
I think there is something to do with queries to make this whole thing work but I am totally lost what i have to do, I've been reading some forum posts which are similar about autocomplete forms which i have done but it wont work when i do it with the problem I have.
Forms :: Locked Checkbox To Make Form Fields Not Editable
Apr 3, 2013I am using Access 2010 and I have my tables hidden in the navigation pane (I don't have any concerns about users finding the tables to make edits), however I am looking to "lock" all fields on a form once a user saves the record. The concern is that when they go to enter a new record they may end up on a previous record and overwrite the information. My thought was to create a checkbox on the table that I can edit each week to lock records. At that point, what type of code can I create or use that will lock records on the form?
View 2 Replies View RelatedNon-Editable Fields And Auto Completing Fields
Jun 28, 2006Hello all,
First post :) found some great tips on here. Anyway here is my story and question.
I am new to Access development. I know what I want to do, I just can not find a way of doing it :( .
1) I would like my form to only be editable when an edit button is clicked. I am not sure if I can do this on a form level or if I have to change each individual part. Any ideas?
2) I capture some clients details, title, first name and last name. I then need to merge the above 3 fields into one to create a 'policies in the name of' field. Is this posisble? I have tried using the initial value expression but am having no luck. Any ideas?
Thanks all :)
Queries :: Unable To Open Or Design Queries From Older Access Files
Jan 1, 2014Im trying to work on an db in Access 2007 that was migrated from Access 2003 (in fact its been migrated several times starting from Access 97). It executes and runs with no problems in both versions.
The problem is when trying to open some queries (not all) - Access is unable to open the query in design mode and gives me this error :
" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
However, as I cant open it - I cant check it. Im pretty sure none of the fields have invalid characters (they do have spaces) and Im not sure how long is too long....
Queries :: Running Multiple Queries To 1 Excel File With Different Tabs For Each Query
Jul 18, 2013I'm using Access 2003 and excel 2003.
We currently manually run 5 different queries then copy and paste this data into 5 separate tabs on 1 workbook, I'm trying to automate some of this process if possible.
I am trying to use the 'transferspreadsheet' action within a macro to run a query and post it into a template excel file, using this code:
Trasfer Type Export
Spreadsheet Type Excel 8-10
Table Name (query Name)
FIle Name (FIle location)
Has field names No
Range Blank
----
This does seem to work and puts the data on a new tab on the specified workbook.
However I have a few questions:
1. Can you specify which query gets put onto which tab in excel? The tabs have different fixed names.
2. Can you specify which Cell the data gets pasted into to? As each tab has a set of headers and titles which need to remain.i.e would need to get query 1 to start in cell A4.
3. How would you expand the above out so that it runs all 5 queries, would you just add in multiple transfer spreadsheet actions in the same macro?
Queries :: Method For Combining Crosstab Queries With Same Criteria From Multiple Fields?
Dec 2, 2014I have 3 cross tab queries that are completely identical with the exception of the field that they pivot. Each field is searching for the same values just in different columns, with the end goal being to get the sum of the values for each pivoted column. I'm wondering rather than having 3 almost identical queries is there a way to use a crosstab to sum the values from each of the three fields rather that having 3 queries which then have to be aggregated in a fourth?
QUERY1
Code:
TRANSFORM
IIf(Count(PT_LEVEL.UNIT) Is Null,0,Count(PT_LEVEL.UNIT)) AS CountOfUNIT
SELECT
PT_LEVEL.INF_YEAR,
PT_LEVEL.INF_MONTH,
PT_LEVEL.UNIT
[code]...