Changing Data In A Field Using A Form

Dec 14, 2005

I have made attempts at this but none have worked, so I am looking for guidence.

What I creating is a database that I can track students and their community service hours.

I have made several versions but I figured the experts could point me in the right direction.

So far I created two tables:

tblStudents
STUDENT_NAME - Text
HOURS_GIVEN - Long Integer

tblHours
STUDENT_NAME - text Links to tblStudent
DATE_COMPLETED - Date
HOURS_COMPLETED - Long Integer

I created a form "frmStudent" with the following:

a drop box to chose a student name from "tblStudent"
a text box "txtSTUDENT_NAME"
another text box "txtHOURS_GIVEN"
another text box "HOURS_REMAINING"

Then I have a subform that has two text boxes "txtDATE_COMPLETED and "txtHOURS_COMPLETED"

I need a code that will enable me to chose a student from the combo box and then have that students name and hours given automatically enter into the respective text boxes in the main form. Then I would enter the date and hours completed into the respective text boxes of the subform, which in turn would update the fields in "tblHours" at the same time subtracting the new hours from the hours given and displaying the new total hours remaining in the respective in "txtHOURS_REMAINING" of the main form. Can anyone give me any help in coding that? Thanks in advance.

View Replies


ADVERTISEMENT

Tables :: Changing Field Data Type But Keeping Data

Oct 23, 2013

I have a field in a table that is comprised of mostly numerical data but some records are text.

I want to convert this field to numerical only and make a new field to put the textual data in.

However converting the field will delete the textual data. What is the easiest way to convert the field but save the textual data AND append the textual data to the SAME record that they were in originally in the new field?

View 2 Replies View Related

Changing Case Of Data In A Field

Mar 16, 2012

I've purchased & downloaded this Zip Code Database which has every Zip zcode in the U.S. which I use for different projects/reasons. The problem is, ALL of the data is upper case letters. I was wondering if in Access (or Excel) is there any way I could convert all of the letters (except the first letter) from upper case to lower case letters?

View 4 Replies View Related

Manipulate Data By Changing One Of Columns To Lookup Field

Aug 16, 2011

manipulate the data by changing one of the columns (Customer 1) to a Look Up Field. This has created two challenges for myself:

1) The data is gone ... oops. I can solve this one.

2) More serious, that column (Customer 1) will only display primary key numbers of the data. Before the corruption, I had a combo box on a form. This combo box took its values from a Table called CustomerTable, the value in this combo box was stored in the QuoteListTable. Before it showed names, now only primary key.

I have attempted to:
-change the look-up back to a regular field (got rid of the look-up)
-exported the table to a query, turned it back into a table, no change.

View 1 Replies View Related

General :: Changing Data Type Of Calculated Field In Table

Jul 18, 2013

I am trying to change the data type of a field in a table from calculated to something else. It gives me the error "this data type cannot be changed once the field has been saved"

Is there any work around to this?

View 2 Replies View Related

Changing Text Color In Access Table Data Field

Oct 31, 2013

I'm trying to change Selected text color in an Access data Field. I want the change to be permanent and show up in reports.

View 1 Replies View Related

Changing Table Data Using Form

Sep 8, 2004

My scenario is that a user enters how many parts of 'Part No.' are going in or out of Inventory. I also would like fields automatically entered on other tables based on the data the user enters. All I need is some understanding of how to code something like this or a pointing in the direction of a resource that can tell me how to code this VBA stuff and the syntax required.
Hopefully you get what I mean.

Thanks.

View 3 Replies View Related

Changing Value Of Another Form Field

Jun 30, 2006

I have a property form for keeping track of houses and buildings owned and then on that form i have a policy field for the policy number of the insurance called txtPolicy. Next to that field I have a little button which opens a form so it will show all the insurance policies associated with the housing group which the property is in. When i select the appropriate policy and double click it in the listbox I want it to close the form and set the value of the txtPolicy to the one just selected in the listbox. I know how to get the value of the item selected in the listbox but I just don't know how to set the value of a field on another form...

View 1 Replies View Related

Changing Form From Modular To Data Sheet

Sep 14, 2006

Hi all, :D
I have built a form in tabular mode with a combo box named "STAFF NUMBER" I have a code for a NOT IN LIST event and when double clicking on it It will open the STAFF form in adding mode.... it works OK... I have now changed the properties of the form to data sheet wich gives me a better view of all the information but I have lost the NOT IN LIST and the DOUBLE CLICK option...
How can I get these features back??? :confused:
Thanks
Marco

View 2 Replies View Related

Forms :: Form Is Changing Table Data

Aug 29, 2013

I have a form that allows users to click on an item in a listbox and it brings them to the selected record in another form. However, everytime I close the form and open it, it changes the client name in the list to the client ID.

List is set up like this

Client ID | Client Name| Order Date
1 Mike 2013-08-04
2 Jon 2013-08-15
3 Mark 2013-08-17
ETC...

Turns into this on close - Changes the client name to the ID of the last item selected before close

Client ID | Client Name| Order Date
1 Mike 2013-08-04
2 3 2013-08-15
3 Mark 2013-08-17
ETC...

Select statement is:
SELECT Client.[Client ID], Client.Client, Client.orderDate FROM Client ORDER BY Client.orderDate;

Code is:
Option Compare Database
Private Sub Command22_Click()
'opens the form with my subform that holds the table data
On Error GoTo Err_Command22_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Client1"

[code]...

View 5 Replies View Related

Newbie: Changing The Value Of A Field On Form

Dec 11, 2005

Hello...

I am a newbie to Access or any database for that matter. So please be gentle.
I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game.
On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database.
In Amt1 I would like to typein an amount and have it multiplied by 15% (.015).
I fiddled with the "On Enter" in the Amt1 property box but got nowhere.
Can someone help???

Thanks for your time
d9085@hotmail.com

View 7 Replies View Related

Forms :: Form Is Changing Data On Load And Close?

Feb 8, 2014

I have designed a form using the wizard from a table which records transactions for an entity.

I have a Primary Key (auto number), entity id, transaction amount, description and date fields in the table.

I look up the entity using a list box, then populate unbound fields then use CurrentDb.Execute "INSERT INTO in order to save the new record.

When I open the form for use, it automatically changes the entity id of a previously added record to the most recently selected entry in the list box. I am unsure why it does this. It seems to be editing previous records when you change the value of the list box.

View 8 Replies View Related

Changing A Field In The Table And The Form Not Opening

Aug 20, 2005

I have made a table and quered that table. I have a form that I designed and is working well. It updates the table like it is supposed to. The problem I have is when I go in and change the master table. I decided that instead of havinga field titled "Unlisted/Listed" I just made it Listed and you put a yes or no. But when I do that and go back to the form a box pops up asking for some value. How do I fix this? Thank you.

View 2 Replies View Related

Stop Access From Changing Format / Value Of Data Entered From A Form Into A Table

Oct 7, 2012

I have a database (split into front and backend). Users populate the table using a form on the front end. Recently, it has been pointed out that some of the data entered into one specific textbox is being changed on the table. The data entered is always has a minimum of a letter and number value i.e. "A1", "A2" etc. Upon examining the table, this has changed into numeric values i.e. "1291", "1061", "852"... etc. Looks like it is translating them into both 3 and 4 digit numerical values by the looks of things. Where more complex data is entered such as "2(A1, A2)" these seem unaffected.

The field is set to text, I have set no validation rule, format or input mask. Just can't see why access is changing these values. It seems to be translating them, but I can't see a pattern.

View 2 Replies View Related

Forms :: Changing RecordSource Of A Form Based On Field Values?

Feb 16, 2014

I have a simple add form that will add an entry to one of two tables: Box 1-1, or Box 1-2.

They have the exact same fields. In the add form, I want the user to specify a Rack field and a Box field. Box 1-1 would be Rack 1, Box 1. Box 1-2 would be Rack 1, Box 2 (there will be more tables later, but just using two for now until I get it working).

But right now my form always adds to the table Box 1-1 - I can't get it to switch.

I've added the code I have so far below. The first part is what I'm having trouble with, the second part just uses a Submit button to add a new record - I'm just including it in case it's interfering in some way I'm not seeing. I'm running Access 2007.

Code:
Private Sub Switch_BeforeUpdate()
If Me.Rack.Value = "1" And Me.Box.Value = "1" Then
Form_Add.RecordSource = "Box 1-1"
ElseIf Me.Rack.Value = "1" And Me.Box.Value = "2" Then
Form_Add.RecordSource = "Box 1-2"

[Code] ...

View 7 Replies View Related

Changing Data In Query Results Changes Data In Source Table

Dec 17, 2012

I have a table and a simple query that pulls results from the table. Nothing too crazy. But, if I were to go in and change some of the data/values in the query results it will change the respective data in the table. I know that this cannot be right. What do I have to do to either prevent the ability to change query results and/or prevent any changes in the query from altering the original data in the table.

View 2 Replies View Related

Queries :: Changing A Text Field Into A Number Field Using A Query

Jul 31, 2014

I currently import data into a table and it it has a text field which looks like this: 12,345.67 GBP...I need to use a query to make this a number field so that I can sum it's contents. I've managed to remove the 'GBP' part but can't seem to get rid of the comma?

View 4 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Forms :: Copy Value From Field In Subform To Field In Main Form During Data Entry

Jul 18, 2013

How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.

In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.

So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.

View 10 Replies View Related

Changing Data Types

Oct 19, 2005

Is there a way to change the data type for multiple fields at once? Such as 20 text fields to numeric in one step.

Thanks

View 1 Replies View Related

How To Prevent Data From Changing

Mar 3, 2008

I have a form that with a combo box that is populated by a query. The user can select a value from the combo box which then opens a form filtered by the chosen selection. However I have noticed that the identifier field gets changed when the form is closed. I would like to prevent the identifier from being changed will still allowing the user to make a selection. I am open to any suggestions.

View 5 Replies View Related

Changing Data Type

Feb 18, 2005

I have inherited a table where the data type is binary in some cases and I want to change these to Numerical. When I do this in design, I get a message which says I can't do that. I have something like 200,000 records.

If I try to export as Text file I get Invalid Argument message coming up. Can anyone help?

View 2 Replies View Related

Changing Name Of A Field

Jan 4, 2007

I have a table Client-Details,in which i have a record namely "bharti-chennai".this table is associated with aother table "release-details". bharti-chennai has records in relase details.i want to change the name of bharti-chennai to bharti -mumbai ..how to do it.

View 3 Replies View Related

MDB....underlying Changing Data Source

Dec 1, 2006

Hi!

I have an MDB file that points to a postgres database. What I'm trying to do is to redirect it to another datasource. The database is exactly the same, but I just need to point it to a different location. I tried doing this with linked table manager by refreshing the table and enabling the "always prompt for new location". I was able to point to my new location but what happened was my MDB became readonly, I am unable to edit anything after I changed the datasource.

View 2 Replies View Related

Mysterious Table Data Changing

Nov 10, 2005

I have a table that contains all of our company pricing for services. You can see a screen shot of the table here:

http://www.x-raysband.com/table1.jpg

All of this data is locked and cannot be changed by the user. However, the seasons keep getting mixed up. What I mean by this is that suddenly there will be a record missing from one of the seasons and there is a duplicate record in one of the other seasons. See the spot-shadowed fields here:

http://www.x-raysband.com/table2.jpg

Off season and Spring are now missing entries for CDJ, INC but the records that belong in those places are now showing as duplicate entries in Prime and Regular. Simply put, the season name somehow got changed within the record, but there is nothing in the system that allows a user to do that.

This has been happening ever since I added the pricing feature to the DB and I am completely stumped. Our work DB has the tables stored in a SQL server back end.

If anyone can shed some light on why this might be happening, any help would be appreciated.

View 7 Replies View Related

Changing Table Data Via Forms

Mar 7, 2006

Hello everyone, and thanks in advance for any help you can provide.

I am currently working on a large project to track, issue out, and re supply an operational stock of various tools and parts we use in our shop on a normal basis. This program is in it's beginning steps at the moment, and already I need some help.

If anyone has any tips on how I can change the raw numerical data in my table, via a textbox and a command button on a form, I would be greatful. I am trying to avoid allowing users to directly modify table data. Although this method is what I am aiming for, I will gladly accept any suggestions. Thanks

AIC Jason Kiebler
OSAN AB ROK

View 4 Replies View Related







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