Why Won't It Update This Table Entry?

Mar 11, 2008

Hi there. My mother (who hasn't programmed in say 25 years) has been driving herself absolutely up the wall trying to figure something out. So I'm asking here since my programming knowledge does NOT include Access. We have a form for keeping track of previous appointments and scheduling the next appointment. It's a simple form consisting of a "Date Last Visit" text box, an Interval integer text box, and a Date Next Due text box.

What we're looking for, is to have it so that when the user clicks on or tabs to the Date next Due text box, it reads what's in the Date Last Visit variable and changes Date Next Due to Date last Visit + 3 months. So... here's what we have.

Code:Private Sub Date_Next__Due_GotFocus() 'MsgBox (Interval) If IsNull(Date_Last_Visit) = False Then Date_Next_Due = DateSerial(Year([Date_Last_Visit]), Month([Date_Last_Visit]) + Interval, Day([Date_Last_Visit])) End If 'MsgBox (Date_Next_Due) End Sub

Now if I uncomment that bottom msgbox, it shows the correct Date_Next_Due... But it's not displaying it on the Form, nor is it updating it in the table! We've had this working before, but due to an accidental deletion and some other messing around, I CAN"T FIGURE IT OUT! So why isn't it updating?

If there's anything else you need to know, please ask. We really need this to work. Thanks so much in advance!

View Replies


ADVERTISEMENT

General :: Automatically Update Field Based On Entry In Another Table

Jan 14, 2013

I have two tables, one called 'Company' and one called 'Person'. Both tables have several fields, but they both have the same primary key, i.e. 'Naam'.

When I type in a name in the 'Person' table, I'd like the 'Company' table to automatically display the name too. So for example if I type in 'John Doe' in the person table, I want to be able to switch to the 'Company' table and have the same name displayed there, automatically.

View 1 Replies View Related

New Entry After Update

Dec 2, 2005

I have a table where records are updated regularly with new information [date & engineer] & the old information over written.
What i want to be able to do is every time a field is updated with new data, write the new data to a second table as a new entry so that i have an archive of all old records held in a second table.

Thanks for your help in advance.

Larry.

View 3 Replies View Related

Update Query For Manual Entry

Nov 21, 2014

Is there a way to have an update query update values in a table based on the user's input?For example, I have categories of tests and educational assignments indigenous to a course I manage."How many students failed the Science Exam?" The user would then put the manual calculation in since it varies from semester to semester.

View 6 Replies View Related

Forms :: Update Combo Box For Entry In Another Form?

Feb 3, 2014

I can't work out how to update the selections available in a combo box as follows: I use a combo box in a main form to select a record (yacht) If it's a new yacht then I use an event linked to a button to call another form to add the new Yacht On exiting the Yacht Maintenance form I return to the main form The combo box in the main form doesn't list the yacht i just added unless I exit and re-load the form

I'm not sure of the best way to refresh the combo box selections or main form without exiting.

View 1 Replies View Related

Queries :: Update Date Entry Using SQL In Access 2010

Sep 20, 2013

I have a date field with dates stored as MM/DD/YY, ie.10/13/09 and I want to use an UPDATE statement to change the year from 09 to 2009 but keep the 10/13/. The issue I'm encountering is when I use a wildcard in the SET portion it takes that as literal and updates with the wildcard. ie. Set Date = '*2009' WHERE Date LIKE '*09' updates the column with *2009 as the entry and not 10/13/2009. How can I update my field so I end up with 10/13/2009, not *2009?

View 4 Replies View Related

Modules & VBA :: Database For Data Entry - Update And Navigation

Oct 28, 2013

I have made a database for data entry, currently i have a challenge of getting it update and navigate.

On the form if the staff name is xyz it should only shows the records filled by xyz in form and navigate that records only. I am attaching the data base also....

View 3 Replies View Related

How To Update A Field In Subform When Main Form Is Data Entry

Sep 19, 2012

I have a mainform set to data entry to add records to TABLE1. I inserted a subform that shows fields from TABLE2. I have a field in TABLE2, let's say TBL2FLD1(NUMBER). I want to add TBL1FLD2(NUMBER) from TABLE1 in the mainform to TBL2FLD1 and update said field in TABLE2.

My problem is:

(1) I get a #TYPE! error when I try to add the two fields, which I have tried many, many ways (adding them together in the Default Value; creating an unbound field to hold the calculation and then putting that field into the Default Value of TBL2FLD1; ETC), and
(2) I don't know how to get the subform to update TABLE2. It seems like the control gets stuck in the subform. Is there a way to accomplish this without coding it?

View 3 Replies View Related

Forms :: Select From Combo Box During Data Entry And Automatically Update Field

Mar 13, 2013

I have one field AccountName in customer table and another field AccountID.

In my form I would like to select from the combo box AccountName during data entry and then have the AccountID automatically update in the Account ID field.

View 2 Replies View Related

Forms :: Assigning Multiple Entries In One Table To A Single Entry In Another Table

Jul 24, 2013

I've got a table tblPatienten, a table tblRechnung and a form frmRechnung.

The primary key in tblPatienten is KundenNummer, the primary key in tblRechnung is RechnungsNummer. The relationship between tblPatienten and tblRechnung is one to many.

Now, every patient (stored in tblPatienten) is allowed to make multiple orders (stored in tblRechnung).

How can I assign each new order entry in frmRechnung to an existing patient in tblPatienten?

View 10 Replies View Related

Forms :: Display Some Fields From Master Table And Only Last Entry From Child Table

Jul 1, 2013

I have 2 tables, master & child. with a one to many relationship.

On one of my forms I want to display some of the fields from the master table and only the last entry from my child table.

How would i accomplish this?

View 5 Replies View Related

How To Make Two Table Entries Correspond To Single Entry Of Different Table

Nov 18, 2013

I have one main table with a list of equipment. I have a second table where there will be a form for damage reports.

What is the easiest way to make multiple entries from the second table correspond with a single entry on the main table?

Some equipment pieces might have dozens of damage reports, while some might not have any.

View 1 Replies View Related

New Entry In Table

Nov 23, 2004

I have an input box that gets a string from the user. I want to put that string in a table. How would I do that?

View 4 Replies View Related

Locking Table After Entry

Feb 6, 2007

I have created a part number generator for our Manufacturing company. Usualy there are a few changes on some of the information within a few days of being created. Is there a way to lock information in certain rows, after it is finalized?

Thanks,
James

View 1 Replies View Related

Tables :: First And Last Entry With A Key From Different Table

Oct 13, 2014

Can I determine what the 1st and last entries are with a key from a different table

For example I have a job parts table (ID= JOBPARTID). There is a specific part that may be replaced several times. I keep these parts on a separate table called swaps. The swaps table is purely

SWAPID (KEY)
JOBPARTID
PART
PARTDESCRIPTION

SO on file I'll have

SWAPID JOBPARTID PART PARTDESCRIPTION
001 1234 PART1 DESC1
002 4231 PART2 DESC2
003 1234 PART3 DESC3
004 1229 PART4 DESC4
005 3241 PART5 DESC5
006 1230 PART6 DESC6
007 1234 PART7 DESC7
008 3289 PART8 DESC8

For JOBPARTID I want to be able to get the first record (SWAPID =001 for PART1) and the last one (SWAPID = 007 for PART 7).

How do i go about it?

View 4 Replies View Related

Adding One Entry To More Than One Table At Once

Oct 15, 2015

I have created a database and I have the same primary key(SITE) for more than one table. I can not seem to figure out how to create a query to add an entry to all the tables that have site as the primary key. Also, I am running Access 2003

View 1 Replies View Related

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Automatically Create A Table Entry

May 10, 2007

In my DB I'm tracking seed. I have a form that I enter in some info in and an ID number is created (based on that info). Then in a different form I track "events" that happen to that ID (drying, moved, bagged). Is it possible to have a button or something like that that after my ID is created from my frmHarvest to automatically generate an event in tblEvents that has the date the ID number and then have something like Harvested in the description field?

If possible can I get some hints on what to do?

Thanks,
Rick

View 7 Replies View Related

Auto Entry Of Fields From Another Table

Nov 23, 2007

I have a simple table called CUSTOMER with contact details on there...First NameSurnameDate of BirthAddress 1Address 2Address 3Town/CityCountyPost CodeemailetcI have a second table called TOWN_COUNTY_REGION that lists all the towns and cities in the UK. Each Town/City is listed with its corresponding County and Region. This table has 3 fields...Town/CityCountyRegionThe TOWN field in the CUSTOMER table is populated by the user selecting from a list of towns in the TOWN_COUNTY_REGION table. When a user clicks the town that they are in, I would like the appropriate COUNTY and REGION fields to be automatically populated in the CUSTOMER table. So, for example, if the user clicks LIVERPOOL from the list of towns and cities, Merseyside and Northwest should automatically be populated in the other 2 fields.How do I do this ??Many thanksAllan

View 13 Replies View Related

Data Entry In A Junction Table

Dec 18, 2007

Hello all,

I just wanted to run this by some experts before I go mucking around in my db. Basically, I am creating a data entry form to populate with information about car parts, and the vehicles they apply to. This is what I am working with:


tblParts tblModelsParts tblModels
PartID ModelPartID ModelID
PartNumber PartID ModelNameID
PartDesc ModelID ModelYearID

I am trying to build a form that will allow me to enter new part numbers and descriptions into the table, and then have the user select (through a listbox?) all the vehicles the parts apply to. Is there a way to populate the junction table with each combination of partID and ModelID automatically? NOTE: tblModels is already populated with data.

I am assuming there would be a way to do this... A query of the junction table (and tblModels?) as the recordsource for the form, and then a subform with the tblParts as its recordsource?

I would have posted this in the massive thread I have going already... but I thought it might be nice to give Craig and Adam a break from helping me :o

View 14 Replies View Related

Updating Table From A Combo Box Entry

Oct 22, 2007

I am learning access on my own, so please bear with me.
I am using Access 2000.
I have a form with a combo box. I use this form to enter data into the database. The combo box selections are from a separate table. If the required entry is not in the drop down menu selections from the table, the user needs to type in the proper selection. If this happens I want the table driving the combo box dropdown to be automatically updated with the new entry so that the data will appear in the drop down menu selections the next time. How is the best way of accomplishing this. Thanks for any answers and examples.

View 4 Replies View Related

Editing Table Entry From Form?

Aug 27, 2015

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.

View 6 Replies View Related

Conjunction Table Data Entry

Aug 22, 2014

i have 2 tables, "Items" and "Locations" and i created one to many relation from each table to 1 conjunction table, and Added one extra field called quantity into the conjunction table, so now the conjunction table has 4 Fields, ID AutoNumber and "Item" "location" "quantity" Fields, ok and i turn it into query then put the fields in form and use it as a data entry

im looking for a way, where if I choose an item From the item combobox, the locations where this item has quantity in it, would be available in the locations combobox, so i can add on the existing quantities...or to make it eazier, when i choose an item, it would let me choose all the location names which have this item next to it, so i may ( edit and add) the previously set quantity field

View 5 Replies View Related

Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry

Sep 8, 2013

I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.

View 3 Replies View Related

Creating A Table Based On The Latest Entry

Jun 14, 2005

I am working on a jobs database where employees enter information where the job is being handed off to. I want to create a table showing the latest job entry by date. The jobs are listed by "Job Number" and when I try to create a table and remove the duplicate "Job Number" it does not always remove the oldest entries.

Any help would be appreciated.

View 1 Replies View Related

Using A Table For Both Data Entry And Building An SQL String

Oct 8, 2007

I have a table that lists county names. On the data entry form only the county names are displayed. However, I have another form that is used to build a custom query based on various criteria, of which county is one.

To make the table compatible with both both forms, the data source for the dropdown list for data entry is: Select * FROM county WHERE county <> "No Selection"

For the SQL form the code is simply: Select * FROM county The default value of the dropdown list is "No Selection". When dropdown list for county is set to "No Selection" the program interprets it as "select all counties". Other dropdown lists provide other parameters such as the project year, nature of the project etc. Each of these other dropdown lists also have a default value of "No Selection". The SQL form thus gives me the ability to mix and match several criteria. For example, it will display all projects in a particular year for a particular county or all projects in all counties that involve the construction of a residence.

My question, instead of physically having the string "No Selection" in the table itself, is there a way to embed the phrase "No Selection" in the SQL expression itself and still have it as an option on the dropdown list?

View 1 Replies View Related







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