Adding Same Data To Different Field Within Another Table

Apr 14, 2013

I have tblCategory and tblExercise. The data in tblExercise can sometimes match with more than one record in tbCategory. When inputting data into tblExercise how can I choose to have that stored under more than one field in tblCategory?

Example:

tblCategory: Arms
tblExercise: TRX Biceps Curls
so TRX Biceps Curls can also be under
tblCategory: TRX

Right now I have to input TRX Biceps Curls under Categories Arms and TRX. Very time consuming.

View Replies


ADVERTISEMENT

Queries :: Connecting Data - Adding Field From Another Table

Jun 15, 2015

I have a query all set up and now I have to add one field from another table in it. I am looking for a date which has the criteria Now() - Last Movement Date. Last Movement Date is the column I am taking from the other table which I just added which is the ZLX02 table. When I run the query, everything but the Last Movement Date shows up. What can I do to get the Last Movement Date to show? Check out the attached pics.

View 5 Replies View Related

Tables :: Adding Field To Table And Updating Data?

Dec 1, 2013

I have a table in my DB called, devices. This contains all the information about various devices we have deployed in the field.

These devices are also contained in 2 other separate MySQL DB's.

What I need to do is add 2 additional field to my access table for the DeviceRecno and DeviceID of the same device from the MySQL DB's.

Adding the field is easy, but I cant think of a way to enter the recno and ID from the other DB's without typing them in manually for each one.

The common between them all is the serial number of the device, and I can get a list of serial numbers, recno's and ID in an excel sheet.

like a vlookup in excel to easily populate all the existing records with the recno and id's from the other db's?

When I created the access system there was no intention to link it to the other DB's for any reason, but that has now changed due to a lot of reasons.

View 4 Replies View Related

Adding A Unique Identifier Field To A Table With Lots Of Data

Jan 9, 2007

Hi,

I wonder if someone can help with what must be an easy solution to this problem.

I have a table with 350,000 records, but without a unique identifier field. I just want a simple incrementing number field to become the primary key but dont know how to add this in. I cannot add an autonumber as there are two many records - it falls over.

Ive tried exporting it all to excel, but as well as being cumbersome, something went wrong and so I'm back to square one.

I think there must be a way to add an incrementing number either via a query or in VBA but I dont know how. Please can somebody provide a solution.

Thanks,
Adam.

View 2 Replies View Related

Adding MR. Or MRS. To Existing Field Data

Jan 24, 2007

Hi.
I have a table with a NAME field and a GENDER field.

How would I code a query so that if the gender is MALE than MR. would be added to the front of the existing data in the NAME field? MRS. if gender is FEMALE?

i.e., the result would be MR. SMITH, MR. JONES, MRS. CARSON...

Russ

View 4 Replies View Related

Adding Data To A Table

Sep 18, 2006

hi
I had a form with TO,DATE,BODY and a button .
on click of a button this fileds should get added to a table.
I have created a table with same fields.
Thanxx

View 1 Replies View Related

Adding Data Into A Table Via A Switchboard

Mar 11, 2006

I was wondering if it was possible to do this, currently if I need to add a new record, I have to add it all in the tables section, this works fine but would be easier if it could be done through the switchoard somehow.

View 4 Replies View Related

Adding Data To Table Each Month

Feb 22, 2008

I want to have a query that I run at the end of each Month to track a workers production and to store that data in a table for each worker by month. Can this be done?

Something like

Worker Jan Feb Mar
Mike 45 33 95
Sue 125 44 02

If this can be done could someone explain to me how to do this. I don't even know if a table can be used to keep stats over months and years.

Thanks for any help you can give

View 7 Replies View Related

Adding New Data To Existing Table

Mar 27, 2007

Please bear with me, first post, trying to get to grips with Access for work!

We (a primary school) had a "bespoke" database set up using MS Access by someone who has long left the area and now we need to make changes and I, as the most computer literate person on site, have been volunteered to make these changes.

My level is beginner (for now) and my first job is to add some new options to a "Titles" table, four columns, six records. Column1 = ID#, Column2 = Male Titles, Column3 = Female Titles, whilst Column4 seems to hold items from Columns 2 & 3.

If I add a futher option, I get the error "Can't perform cascading operation: Entry must be one of the Titles as featured in the drop-down box or in the Titles table.

Now, as far as I can tell, I HAVE added the new option to the Titles table, and they DO show in the drop down box in the main spreadsheet display, BUT the error comes back as soon as I try to confirm the new title.

Any ideas please?

View 9 Replies View Related

Adding Form Data To A Table.

Mar 2, 2006

This may be a very neebie question, but I have a form with drop downs for data choices. When an employee finishes with the selections, I would like all the data transferred to a table as a record. How would I go about doing this.

Any assistance is really appreciated!!

View 1 Replies View Related

Adding Combo Box Data To A Table

Jul 28, 2005

I have an existing FORM called Evaluations where you can select a trainer and a trainee from two different combo boxes. Once a name is selected from both of the combo boxes I click on an assign button and I want it to record those two names selected into my evaluations table in the Trainer_Name and Trainee_Name columns.

How do I do that??? Please help??

Thanks

View 2 Replies View Related

Adding Data To Table From Form

Jul 10, 2006

I have a query based on two tables and I have created a form based on that query. Now I want to take input in the form and then add that data to one of the tables, that the query is based on. How can I do that?

View 1 Replies View Related

Queries :: Adding Data From One Table To Another

May 11, 2013

I have two tables in access:

TABLE 1:
ID
SINGLE_MULTI

TABLE 2:
ID
NUMBER OF VIEWS
MULTI

The data is a store of all viewers of a video.

Table 1 has all of my unique data within it. People within this table may have watched the video once or several times. People within Table 2 have watched the video several times.

I want to add a flag for "Multi" to Table 1. And, where a person is not a "Multi" create a flag that reads "Single".

I've spent countless hours (probably days) trying to achieve this and have failed miserably. Whatever approach I take I end up creating a new table that just contains the "multi" people.

View 1 Replies View Related

Forms :: Adding Data To Table

Nov 20, 2014

I have a form that I'll populate with some data, I need to then append this data to a table and clear the form for use next month, is this possible?

View 1 Replies View Related

Adding Data Back To Table?

Sep 30, 2012

my problem is that when i make a booking on my booking page it all saves, but when i go to the table where the bookings should all be kept, they all dissappear and only the recent booking i have made shows.

View 10 Replies View Related

How Would I Go About Adding A Field Or A Table?

Oct 2, 2005

The attachment is the database Im working on and I have a problem.
I need to add a supplier Product number in there some where so I could keep the numbe as reference and so it may be easier to enter items recieved.
in the form section, I will have Invoice with a sub form Invoice details.
I need to put suppliers Item number somehow so it would search and if the item is on the product list it would fill out the rest of the values.

should I make a separate table for suppliers product number or should I just include that into the invoice detail? I dont want to put it in the product table since I get same Items from different suppliers.

View 1 Replies View Related

Number Field Adding Bogus Data Beyond Decimal Point

Jan 6, 2008

I have a field for Item Price.
It would be a currency field, but I want it to be able to work with up to 6 decimal places. currency only seems to handle 4.
So, in the table, i changed it to a Single.
In the form, I left the control on Currency.

If I type in $1.43, instead of storing $1.43000000 it stores $1.43003243953

Why is it adding all these bogus sub decimal numbers? Any clue?

Thank you,
Evan

View 5 Replies View Related

General :: Lookup Field - Adding Another Column To Enter Data

Aug 2, 2013

I have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and then enter the date that it expires (different for expiry date for each employee) How do I do this?

I have added the date field to the qualification table but when I create the lookup field on the form it shows the qualifications and a blank column next to it which data can't be enteed into.

View 2 Replies View Related

Adding Data To Table From Form Text Box

Jun 3, 2006

Hey, im developing a taxi service database and i am working on adding new customers to the customers table through a form using text boxes. Im wondering if its possible to have text boxes as inputs and once all the data is entered (first name, last name etc) have a button to simply click and have all the data transferred to the table. Im also trying to do this without having all other records shown as well.

I've included a screen and the db to show you what i mean:
http://shieldfilez.fasthost.tv/images/screen.jpg

View 5 Replies View Related

Forms :: Adding Data From Form To Table Using VBA

May 27, 2013

I have a form (called Form2) with say 3 text boxes, called txt_Field1, txt_Field2 and txt_Field3.

In txt_Field1 the user specifies the number of records to be added to an existing table. The fields txt_Field2 and txt_Field3 are used to pre-populate the records with default values.

Furthermore, I have set up a table called Table1. It's headers are ID, Strategy, divRate. ID is Autonumber, Strategy is Text, and divRate is Number.

Suppose the user inputs the following on Form2:
txt_Field1 = 3
txt_Field2 = Covered
txt_Field3 = 0.04

How do I programmatically add 3 records (since txt_Field1 = 3) to Table1 such that the table will look like:

ID, Strategy, divRate
1, Covered, 0.04
2, Covered, 0.04
3, Covered, 0.04

View 6 Replies View Related

Adding A Field To A Table In Access

Aug 4, 2006

I have created the code below to add a new column to a table each month. This may not be the best database design but it meets our needs for now.

However I am having difficultly with the code below. The CreateField Function is unable to accept the parameter periodDate. Any Suggestions on this would be apprerciated




Function DateField() As Long

Dim colFullName As Object
Dim dbsCurrent As Object
Dim yearInt As Integer
Dim monthInt As Integer
Dim table1 As Object


Set dbsCurrent = CurrentDb
Set table1 = CurrentDb.CreateTableDef("103TblCustomerBalancesCombined")

yearInt = Year(Date)
monthInt = Month(Date) - 1

If monthInt = 0 Then
periodDate = CLng(yearInt - 1 & 12)
Exit Function
End If

If monthInt < 10 Then
periodDate = CLng(yearInt & "0" & monthInt)
Else
periodDate = CLng(yearInt & "" & monthInt)
End If

Set colFullName = table1.CreateField(periodDate, DB_TEXT)
table1.Fields.Append colFullName


End Function

View 2 Replies View Related

Adding A Field To A Linked Table

Mar 27, 2008

Hi folks,

I am really struggling w/ the following & would greatly appreciate advice!

I want to add several Fields to a Linked Table in Access. The Access wouldn't let me do it because it is a Linked Table. What should I do?

There is also a nicely designed Form that goes w/ that Linked Table. So I figured that once I add the Fields in the Table then I can add them to the Form too. - But can't even add the fields yet....

HUGE THANKS in advance!

View 7 Replies View Related

Adding Field To Form And Table - Please Help

Nov 18, 2006

hi,
I added a field to a table in the backend
I also addded the same field to show up in the form

Now the problem I am facing is that in a new record I can type my values for all fields but an error(2465) is thrown when i try to save it

I suspect that when this field is added in the form it is not getting committed/saved into the table

how do i go about doing this?
thanks

View 1 Replies View Related

Tables :: Adding Value To A Table Field

Mar 20, 2014

I am building a DB for my college, it is needed to replace a spreadsheet they have in place. The spreadsheet is used to monitor and track Students grades.

Each unit a student passes gives that student a certain number of points, the number of points depends on the grade (e.g. a student will get more points for a B than they would for a C). The point of the DB is to input all the students grades so that student can see how many points they have.

I was wondering if there is a way to add a value to a field, so if I put in a field that a student got a B grade the database would know how much a B grade is worth points wise. Each field should be added together to generate an overall score. Is this possible?

View 1 Replies View Related

Adding A Record And Specified Field In Table?

May 20, 2013

I am using a form to add a record to a table and need to be able to specify one of the fields in the table that will be added to. This field is predetermined by another form selection. If there is a way to force a value on a title box with a control source this would also do the trick.

View 4 Replies View Related

Modules & VBA :: Inserting Field Value When Adding Record Using Data Entry Form?

Dec 14, 2014

I have a form for entry and some fields are computed or result of a query from another table. I have a function that looks up a value from another table like so

************************************************** ********
Public Function GetTargetType() As Variant
GetTargetType = DLookup("type", "tblFormulations", "[tblFormulations!formulation]=Forms![frmNmsConsumptionEntry]![formulation]")
End Function
************************************************** ********

Which works fine when I test in the immediate window.Then I have this form event. This however does not insert this value when I am adding records using my continuous form.

************************************************** ********
Private Sub Form_BeforeInsert(Cancel As Integer)
Me!target_group = GetTargetType()
'Forms!frmNmsConsumptionEntry!target_group = GetTargetType()
'[tblNmsConsumption.target_group] = GetTargetType()
End Sub
************************************************** ********

making sure I can insert this value once retrieved.

View 7 Replies View Related







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