Edit Previous Entries Using Form - Odd...
Jun 14, 2005
I'm working on a pre-existing form. When I open the form, I am able to enter new data and this data gets stored in the database fine. If I close that form and reopen it, I cannot view past entries or edit them. I know of a property (Allow Additions, Allow Edits, Allow Delete) which can change this behaviour, but these seem to do nothing for this form. I have them all set on yes and it behaves as I've described. Ideally, I would like to allow edits of previous data.
I thought maybe the SQL query controlling the data wasn't returning any entries, therefore no entries would be displayed. So I saved the query and opened it up to see how many entries it did find. And it found all that it should have, so I know that the SQL statement controlling the form is what I want it to be.
So my question is this: are there anymore properties or values that I don't know about, that would control the mentioned behaviour of the form? Maybe something somewhere that I'm missing, that would make the form add only?
Thanks in advance for any help. Kevygee
View Replies
ADVERTISEMENT
Apr 8, 2013
I'm trying to design a simple wildlife tracking DB, so that when myself or my colleagues spot an animal we can enter its ear tag number via a form. That will either bring us up a list of previous dates/locations that animal was observed, or if it's not in the DB, allow us to enter the new animal and location.
I have two main data tables:
dt_Animal- which stores the ear tag info, species, and other information about that unique animal
dt_Sightings - stores info on when/where animals been seen (linked to dt_Animal in a one-to-many relationship, of course)
What I want is that when you open up the form, you get a box (text or combo) to enter the animal's ear tag number.
- If it already exists in the DB, it brings up all the info on that animal and its previous sightings - with the option to fill out any missing info and (of course) to add a new sighting - and it WILL NOT add a new record to dt_Animal - just to dt_Sightings
- If it DOESN'T exist in the DB, it creates a new record in dt_Animal and allows you to enter any/all of the other information
Where I'm running into problems is that I don't want duplicate records in dt_Animal - each animal is unique. I haven't found a way to set up a form so that you don't get pop-up errors if you're typing in an ear tag number that's already in the system.
I've tried various tactics involving simple coding (NotInList, etc.) that I pulled out of this forum and other places, but haven't had any luck.
View 5 Replies
View Related
Sep 9, 2013
I'm fairly new to databases and have been attempting to build a multi-table database. It's not properly rationalised, but I wanted to test run it to ensure it was fit for purpose first.I've built my form, which is pushing data out to several tables, but I cannot seem to get the form to pick up previous records.
View 3 Replies
View Related
Dec 10, 2013
I am tasked with creating a scientific database of fish catches at various different sampling stations. I envisage the entry form having hierarchy levels, ie year, season, date, sample station, species caught, and then the specific associated data with each species (weight, abundance, length etc) will form each distinct record.
In each year there are 2 sampling seasons. In each sampling season there are up to 20 dates on which samples are taken. On each date there are up to 50 sample stations recorded. And at each station up to 20 species can be recorded.
In order to enter each species caught in a survey, the end user will potentially have to fill the season box with an entry 40,000 times. For each season there will be 20,000 date entries to be made. For each date, 1,000 station code entries, and 20 species entries for each station. What I would like to happen is this.
When the end user is entering the data, he or she will be working through the hierarchy from the ground up. Ie., they will enter a particular species' data (abundance, weight, length etc) at a particular station on a particular date during a particular sampling season. The next entry will be a different species at the same station on the same date during the same season. I would like the duplicated information from the previous record to be copied across onto the new one so that all the end user has to do is enter the species name, abundance weight and length data.
Once they have finished entering all the species data for that particular site, they can move onto the next site which they would fill in the data themselves for the station code. So, in the hierarchy, the first button would copy all the previous data except the species name and associated weight length abundance data. The next button would do the same, except leave the station code blank. The next button would leave the species name, station code and date blank. And so on up the hierarchy. The end user would be able to selectively choose which data is copied over by using these buttons, saving lots of potential extra work doing repetitive entries.
View 1 Replies
View Related
Jun 15, 2007
Let's say in one table (called Employees) I have two columns, Name (the Primary Key) and Job (Both are text fields). One row contains "Jack" and "Gardener" in each column respectively. If I were to have a form for a different table where I select Jack's name from a drop down menu of all the "Names" in "Employees" and it then automatically fill in the next field with his Job (which would be "Gardener").
I really hope I'm making sense... Is this possible?
View 14 Replies
View Related
Mar 28, 2015
i've got a Form that contains Subform with an embedded Query that contains 2 tables only (Payments & Invoices) the Join properties between them show all records from payments and what matches it from Invoices where the joined fields are equal (Invoice no).. So, when i enter certain data in the main form the Subform show the results for it from Payments table and only one field needed from the Invoices table !!
The problem is.. i can't edit or add any data in the Subform results with the previous setting, but when i completely remove the Invoices table from the embedded Query then swift to the Form and it's Subform.. i become able to edit and add data in the Subform easily... !!
So, how to enable the edit/add in the Subform with the 2 tables in the embedded Query ?! Cause it's really needed to show that field from the Invoices table.
View 3 Replies
View Related
Jan 17, 2013
Is there a method of setting the default value for new entries to the same value as the previous entry?
For example, I have a quality control information table that stores QC data for different lot numbers. It is annoying to enter in the lot number and product code field over and over again if there are dozens of records per lot number. Is there a way for Access to easily display the previous entry as the default value?
View 1 Replies
View Related
Jul 7, 2013
I seem to be have trouble resolving an issue whereby data entered via a combo box based on another combo box from separate tables/queries is not able to be retained when the data in the original table has been "discontinued". The database in question has changing items that are continually updated and/or discontinued. However when these items have been checked as "discontinued", the old entry data is then updated and the fields are empty.
View 1 Replies
View Related
Nov 19, 2014
The next stage I'd like to include is a match and enter pricing details. We get a lot of repeat work that is entered onto our system, due to the nature of the work we do each item is then checked individually. There is a portion of this that could be automated.Our order intake table has an amount of information, various bits of which are supplied by various customers, but not always all of the information is required or given.
Id like a price to be copied from a previous record where the "shots" field matches a previous entry.The other fields that would need to be similar are the "coverage" "drawing no" "pattern no"..But only when these fields are populated, we often, but not always put a - in these fields where the information is not given. I think this may be bad practice, but it shows us the information has not been supplied, and not just missed from the order.
To sum up, when an order is completed i'd like to have an afterupdate event that searches the previous records, where cover, drawing no / pattern no are *matching* and the shots do match, then copy the price of a matching record, where that record is within 12 months of today (using the date_rec field) and then tick an "automated_price" field so i know the price has been generated by the system.
View 1 Replies
View Related
Mar 13, 2014
I have a table in access which is updated weekly; I need to create two tables from this updated table.
1st table will consist of all the new entries for the current week
2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.
ID
Name
1
Adam
2
Ben
This week I have three new entries New entries
ID
Name
3
Charles
4
Richard
So when I run the same query next week I will get something like this.
Old Entries
ID
Name
1
Adam
2
Ben
3
Charles
4
Richard
[code]....
How do I get a query /queries which divides up the weeks new entries and also all the old entries.
View 11 Replies
View Related
Sep 8, 2006
I have a form called contractors. It works exactly like I want it but it won't let me edit it. The form is based on a query. I have checked the query as stated to do on some areas of this forum and I am able to change it by typing something in a field and it also updates the form for me but I can't edit the form directly. I have allow edits, allow deletions, allow additions set to yes and I have no locks on it. Any ideas?
I have also checked help in access on this to no avail. I am attaching the database so somebody can hopefully help me.
Tracy
View 6 Replies
View Related
May 1, 2007
hi all,
i have created a small application for my assignment using ms access. i apply several function to dis system. initially it works but then i dono why suddenly it came out wif an error sound which mean u cant even edit anything in the form..it sounds ridiculous but dis happened to dis system. i have checked all the properties settings for that form. i compared wif my previous system which i didnt apply the complex function which just pull some data from database. all seems ok wif the settings for the new one...
can anyone tell me what was my problem?
View 1 Replies
View Related
Apr 27, 2005
I currently have two forms: frmE_SAFind and frmE_SAOrder
frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate]
Example:
IDPO Date
btnOpnFrm 6543 2/1/05
btnOpnFrm 5681 1/1/05
frmE_SAOrder shows order details including [txtIDPO] and [dtmDate]
I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command?
Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details.
Hopefully I made myself clear enough to understand. Thanks for your help!
View 1 Replies
View Related
Apr 27, 2007
I have searched the forum and didnt find an answer to this.
I have an Edit Form. When it is opened, it displays the first record.
I have a Combo Box where I select the specified ID and the relevant record is displayed in the form.
What I want is that the Edit Form should be appear blank. The record data should appear only when I select the relevant ID in the Combo Box.
How do I achieve this? Please help.
View 1 Replies
View Related
Feb 21, 2005
I want to be able to choose a record from the combo box and then the rest of the fields fill in themselves... Also some of the fields are in a subform but are all linked to the entry in the combo box... can someone help me ? :confused:
View 2 Replies
View Related
Jul 1, 2005
Hi. 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
View 6 Replies
View Related
Feb 8, 2006
Hi, I have a form where i would like to bring up various records for editing. This part is not a problem. BUT. If a user accidentally changes something and doesn't know what it used to be then i need to have a "cancel" button which will undo the edit so to speak. I am not sure of the best place to do this ?
View 4 Replies
View Related
Nov 1, 2006
Hi
I have a form with avout 4 fields based upon a query to allow user to edit an entry if needed.
I want to put a cancel button on so that if they change their mind after having changed a field it reverts to its original value - so for instance they decide to change a land line phone number to a mobile, exit the field but then have a brain storm and decide not to do this so hit the cancel button.
At the moment my cancel button just closes the form (and accepts the overwrite) which would be fine if I am using ADO but not if I am using a bound form.
I am sure there is a simple answer (since I cannot be the only person who thinks this option might be a good idea). I am just not sure how to look for it.
Any thoughts or ideas?
Thanks
View 5 Replies
View Related
Apr 26, 2007
I have a form with a combo box drop down, next to it I have an edit button. If the agent is not in the drop down list, I would like to press the edit button and add a new agent. This works but it does not show up in the list unless I do the edit before I hit the arrow on the drop down box.
I have a macro on the edit button to OpenForm and Requery.
I would like to be able to press the edit button, make the change/addition, when I close this go back to the dropdown and have the new/or changed value seen in the drop down.
Is this possible? If so, how do I make this happen?
View 12 Replies
View Related
Aug 17, 2014
I have a big table, EquipmentDetails and separately I have job plans.Job plans can have many pieces of equipment. I store the relationship in EquipmentDetails_JobPlanDetails, but am feeling frustrated as I can't seem to get Access to build the SQL query from this in the way I want.
I am generating a List Box in a form which is populated from a query.The query calls on a table which lists ItemID from EquipmentDetails and JobID and in the current form (where the list box is) I want to pick up and display the ItemIDs associated with that JobID. The current JobID reaches my form correctly (I've proven this by displaying it in a text box) from the previous form.
The problem I have is that I can't seem to get the SQL query to only get ItemIDs that are linked to the current JobID. No matter what I try, it either gets all of the ones in that table, or I can't compose one.What kind of SQL do I need to only grab the ones relating to the current JobID please?I've tried building it in the design view but it says that it can't do it because the outer joins are ambiguous.
View 2 Replies
View Related
Jul 20, 2015
I've got one form that a user will start on, titled "Query Form" - Only one text box is here and it is titled "text0"
Upon hitting enter here, a new form is opened up titled "Time_IN_Form".
What I would like to do is have the value from text0 on the Query Form to automatically populate Emp_ID on Time_IN_Form so the user doesn't have to enter their employee number twice (only once via the first form).
What is the best way to do this? I have tried playing with global variables but didnt have any luck with that.
View 5 Replies
View Related
Sep 28, 2006
I have two forms "Enter_details" and "sendemail"
on typing txt in "enter_details" forms txt field " checksum" i want it to be updated in "BODY" field of "Sendemail"
"SendEmail" form may be open or may not be open. I put this code on "Sendemail" but its not working plz help
Private Sub txtBody_BeforeUpdate(Cancel As Integer)
[txtBody] = Forms!Enter_Release_details.[Checksum]
End Sub
View 1 Replies
View Related
Dec 19, 2006
Short version of question:
My research has shown that Access will not allow edits through a form that 1) has subqueries in its SELECT clause, or 2) uses aggregation such as First(). Is there any tricky way around this?
Long version of question:
I have a database form that shows an overview of orders for products (it's based on a query that pulls all current orders from the big table). I would like to handle both of these on each row:
Show where we built it last time, and
Allow the user to select where it will be built this time.
The problem is that I cannot figure a way to change the form/query such that it doesn't aggregate to find out where we built it last time, or doesn't rely on subqueries that do just that.
But I feel like there should be some way to do it--since each row displayed does rely on one and only one record in the complete table of orders. Which obviously is the record I want to update.
Is there something I can do that will accomplish this? I really do not want to have to make the user open up another form to see last time or choose this time.
Thanks in advance!!
View 3 Replies
View Related
Jul 19, 2005
I have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference Number or something.
View 2 Replies
View Related
Aug 11, 2005
I'd like to set up a form that allows you to enter a unique number for a record and then automatically change the value for one or more fields in that record.
I have a large number of records that I only need to add values to two fields so am looking to make a shorter form with the ultimate ail of doing this with a barcode reader.
I thought I could just add a line like:
Me.controlvaluetochangename.Value = "newvalue"
to and event property like after update and it would change the name for that record. Instead it created a new record with that value.
How do I go about changing the existing value?
Thanks
View 1 Replies
View Related
Mar 30, 2006
I guess this is a fairly basic one. I have a form that allows people to edit records, but I want to prevent people from adding new records on this form. I thought that if I put 'no' in the 'Allow additions' property, I would achieve this end, but when I do this, all the input boxes dissappear.
appreciate help
thanks
View 2 Replies
View Related
