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 Replies
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 RelatedEditable 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
Non 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
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!
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 RelatedHow 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 RelatedSelect Form Record Set By More Than One Query
Mar 15, 2006Hi,
I don't quite know if I am heading down a blind alley here. I want to filter a form to show a subset of the records via a toggle button. Click again and you go back to the full record set.
The form is based on a query and the filter is to be based on a copy of the query with several criteria and sorts added. This will result in a record set of active projects comprising about 20% of all records (65 out of 253). The sorting sets the record order to match the main management report and so the Planner can update the active records by navigating through the record set rather than having to search for each record using the Find button.
If what I am trying to do is not the way to achieve the desired result, I'd be grateful for any pointers elsewhere.
Regards,
Keith.
Select All By Default For Query From Form.
May 11, 2006Hey Folks,
I have a form with five combo boxes on it and one button, when each combo box has an option set and I hit the button, it runs a query which looks up the values of the form items and gives me my chosen information.
However, if these fields are: FirstName, Surname, State, Town and Road, and I want to only select on 4, 3, 2 or 1 of these - it gives me nothing.
So how do i specify that if the combo box is left blank just to select all.
So by putting data only into FirstName, say Eric, it will select ALL Surnames, states, towns and roads where the firstname is Eric.
Form To Select Fields For Query
Sep 14, 2006I have written code to write a query with parameters set from selections made in a multiselect list box on a form.
I now want to add a check box for possible fields to include in the query and put these on the bottom of my form to allow users to select which fields they want to be displayed in the query result.
Can anyone advise how I can do this?
Many thanks,
Gary
Select Multiple Criteria For Query On A Form
Oct 14, 2005I was searching through here looking for a solution to the following problem:
I am building a Capacity database for work. The requirements require that users be able to sort by numerous criteria (Forecast Date, Portfolio, Market, Bucket, Month), all from a simple form that will spit out the results. Rather than creating unique queries for each combination of criteria(way too many!) or creating the SQL text in VBA, I played around until I came up with the following(which may have been done already, but I can't find it on here, so I'm not claiming to be brilliant...LOL). I have dropdowns on my form for each sort criteria-(Forecast Date, Portfolio, Market, Bucket, Month)
Then I created a query and for each criteria, I put this in:
Like (IIf(IsNull([Forms]![frmWAOFAdjustments]![Bucket]),"*",[Forms]![frmWAOFAdjustments]![Bucket]))
So if the user leaves a dropdown blank, the query simply brings back all the results from that field (Like *).
The text in bold is simply replaced with the dropdown name for each segmentation criteria. Next to each dropdown is a button that clears the dropdown box and requeries the listbox with the results(in case the user doesn't want to remove a criteria. This makes running searches for a specific number of accounts easy for the user and easy on me..lol.
Hopefully this can help someone out with a similar problem. I have learned so much from this forum, I just wanted to give something back. If anyone has any questions on this, just let me know.
Cannot Get Query To Work With My Date Select Form
Jan 5, 2006With the imense help of some of the people in this forum, I have scraped together a nice little database.
There is one function, however, which is not working.
I have a query that should run from a form I have created. The form has multiple criteria and all seem to be working except for the date fields... "First Order" and "Last Order".
The way I have it set up is that I have a table of dates. The form has a list box of the dates (first of the month, for 4 years).
The source data in the form reads: SELECT [TDateSelect].[StartDates] FROM TDateSelect ORDER BY [TDateSelect].[StartDates]; (for each of the 2 "minimum" dates)
and SELECT [TDateSelect].[EndDates] FROM TDateSelect ORDER BY [TDateSelect].[EndDates]; (for each of the 2 "max" dates)
The user is allowed to select a date range for the first order and the last order. (4 dates altogether).
The form looks fine.
In the query, I have set the criteria for the last date as:
Between [Forms]![FSetOtherCriteria].[MinLast] And [Forms]![FSetOtherCriteria].[MaxLast]
When I run the query (even with a wide date range) I get no results. When I remove the dates from the query, or enter the limits manually, the query works like a dream.
Any ideas???
Select All Query Fields For Main Form?
Sep 13, 2013I have a table with about 3800 records and about 150 fields. It also has 4 tables with related data that each have only one field. I am going to create a query to base my from from. Should I just take the star * and get all the fields for each table or should i manually specify them. There are only about 5 fields out of the 150 that I dont need and I need to see the rest.
View 13 Replies View RelatedQuery For Populating A Form Based On Different Select Criteria
Feb 20, 2006Hi all,
I have a query which populates a form called EditPatientFrm, which asks the user to enter the patient UniqueID in order to pull up the record they want to edit from the TblPatient. However, I want the user to now be able to input just one of three criteria in order to pull up the record to be edited:
UniqueID
ChartNumber
PatientLastName and PatientFirstName (two fields)
since they may not have the UniqueID readily available to them.
Can anyone show me how to do this? I have tried to find answer to this one under queries and forms- no avail. Sure it's a simple thing...
thanks!
vrpres
Select Record In Split Form Query Result
Mar 25, 2008I have searched and search and I can't find the answer to this question when I thought it would be simple. Hopefully you can put me out of my misery!
I have a access 2007 split form with a series of search boxes and a query result window. Enter info into one or more of the search boxes, click search and you get the matching results in the query window below. That works fine but I want to work with the results of the query, how can I do this?
I was looking for the user to be able to select a record and then click a command button to open that record in a form. Or in another instance select a record in the result window, have the current from close and have the primary key passed to a another form which I use to open the split form.
I just can't see how to do it but I expect there are several ways. Happy to use VBA but my experience is with Excel VBA so I'm still getting used to the objects.
Thanks in advance!
Running A Query Based On A Select Record In The Form
Jun 13, 2006Hi,
I have a query that I would like to run from a form. I have created the button and the query, but want to add in a clause that will use the user selected record / field as the criteria for the query when its run.
Got any examples of code I could have a play with
I am struggling here so need any help I can get!!
Cheers
Paul
Queries :: Form To Select Which Fields Show In Query
Oct 8, 2013 I want to create form with 10 checkbox, each checkbox is linked to a field "name, Address, TelephoneNumber, BuissinessName" I would like to know if it is possible for the user to check the box and then the field will show in query. if only name is check then only name will show in the query.
I have tried using [Forms]![Formname]![CheckboxName] as criteria but this didn't work it when I had more then one checkbox and when the one check box was not checked nothing showed in the forms.
Queries :: Combo Box On Form That Passes Criteria To Simple Select Query
Sep 22, 2014I have a combo box on my form that passes criteria to a simple select query. There are four possible selections to make from the combo box. For some reason, when I select the first option on the list the query runs perfectly. However, if I select the second, third or fourth option from the combo box, the query returns no records, even though I know there are records in my table which should be returned.
View 5 Replies View RelatedQueries :: Form To Select Parameter - Causing New Field In Query Design
Jun 16, 2015I have a query with multiple fields that is being run off of 3 parameters (linked for selection in a form). The problem is, I wanted to enable a select all feature, so I included a "Or ... Is Null" part in my criteria section, so that when nothing is selected, the query/report returns all records.
Okay so the problem is whenever I run the query with nothing selected for the parameter and then return to design view for the query, a new field has been created in the query design, titled with the expression I use to pull the parameter value from the form. This is frustrating because then that is causing errors in another report I run that pulls values from that query.
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!
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??