Adding To Value In Field

May 21, 2005

Ok, this may be a ridiculous question to ask, and i imagine there is a simple answer, but i cant see it. maybe its coz i learnt access from the "for dummies" guide :)

i have a table with a "quantity" field. i have a form for finding a record, and then i want to enter a value in a box and press a button to add it to the existing value in the "quantity" field. basically it is for increasing the amount of a certain type of item in stock when a new delivery comes in.

Please help me, im a simple man and havent got a clue

thanks

View Replies


ADVERTISEMENT

Adding Same Field Twice

Mar 7, 2013

I got a question about a database I'm trying to design. It's a small cable management system.

I want to create a form that shows where the port of a computer is connected to.

For example; A computer has one ethernet port. That port is connected to a switch. I can add the fields for the Unique hardware ID and for the ports of the computer. But I can't seem to chose a device where the computer is connected to.

Ive tried working with queries.. but nothing seems to work so far.

I created a small example of the database I'm trying to make.

example_database.zip

View 7 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

Adding To Access From The Field

Nov 26, 2007

Hi again. I finally have time to start working on my access project, and what I want to know is how could a field technician add to access from the field, either with a laptop or possible even a pda. things a tech would need to add are notes, different readings that monitor job progress, equipment placed at the job site, other things like that.

View 3 Replies View Related

Adding A Field Name To A Query

Nov 30, 2005

I hope I can ask this question so that it makes sense.

I have a totals query that I'm using to make a Chart. The query works fine but I want to change the look abit. What I'm doing is quering a table looking for the total number of times that there is a check box in a field called PDC RTA and totaling the Hrs as well. The data comes back looking looking like this.
PDC RTA-----Count-----Total Hrs
-1 ---------- 6 -------- 53
0 -----------25 -------- 78

My problem is that when I chart this the -1 and 0 show up at the bottom of the bars on the chart. I would like to rename these to fields on the qry qrid then I can chart the new field names so that it will make sense to the user.

Make sense

Jon

View 2 Replies View Related

Adding A String To The End Of A Field

Nov 20, 2007

I have a field that contains various text....(It's a note field that allows 86 characters).

I want to go in to the database and add the string "Conversion 2007" to the end of every record. So leave whatever is in there but add in the string. I would like it to add whatever it will fit, in the cases where there is not enough room.

I figured this was somewhat simple, but I haven't found anything yet.
Thanks.

View 4 Replies View Related

Adding Field To A Form

Jul 13, 2005

I am using a Microsoft Access Form and would like to add some new fields and have no idea where to start. Any step-by-step help would be greatly appreciated.

I am an amateur and would need step by step so minute details would be greatly appreciated.

Thanks!

View 2 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 1 Replies View Related

Form Adding In A Field

Dec 1, 2006

Hi

Can somebody help me with forms. I have not used Acecess for sometime and have created a form and realised that I had not included another field in the form. Can somebody help me I have forgotten how to add in the additional field. Simply please:eek:

View 3 Replies View Related

Adding A New Field Into A Form

Dec 4, 2006

Hello

I have created a form and now realised that I have forgotten to put in a field. I have forgotten how to add an additional field to the form. Help in plain terms please. Thanks:eek:

View 2 Replies View Related

Adding A Value To New Field In Access

Jun 5, 2012

I'm importing a text file into Access. The file is just a string of numbers that I'm breaking apart into three fields. Once those three fields have been broken apart by the import tool I need to add a new field that just contains the year.

For example, I import the 1990 data file that is .txt format and I break apart the three fields while it's imported. Once imported into three fields, I want to add a 4th field that says 1990 for every record. This has to be a pretty simple thing to do, but I can't figure out how to add a single number as a new field to every record in the database.

View 2 Replies View Related

Adding Value To A Field When Condition Is Met

May 19, 2015

I need for a valued to be changed in a row after it checks for how many rows have another value, counting how many and that number making it the amount field.

Example:
Fields- Name sponsor amount

I want access to show how many people have been sponsored by Gabriel... So if 3 where sponsored by Gabriel show 3 to the amount field for Gabriel row! Any way to do this or an easier way?

I for it to check it every time a user is added incase the user added is sponsored by Gabriel add it automatically!

View 14 Replies View Related

Adding A New Field To A Report?

Aug 6, 2013

I'd like to add a customer type field from my 'Customer:Table' to my 'Customer Balance Report' Also, I need to create a validation rule in my table specific the legal values of SAL, SPG and WMN in my customer type field. with validation text, which I'm not sure how to do.

View 2 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

How To Update Access After Adding A New Field?

Apr 27, 2007

Hi

1. I need to know how to update the field list of the query after
adding a new field into the table and the query?
2. I need to know how to update the records table after adding
calculated filed?

View 1 Replies View Related

Adding An Autonumber Field Automatically

Apr 27, 2007

Hi,

Can somebody help...
I'm trying to put via an automatic way a field to a table that autonumbers. When I use a select-query: ALTER TABLE tablename ADD COLUMN Id Autonumber, Access doesn't recognizes the type "Autonumber". Even in VBA when I use the .createfield method, I can't set the datatype "Autonumber". I'm pretty sure it must be possible (as access can store anyway the indexes.. actually, I want those indexes as numbers in a separate field).

Thanks a million for any help!!!
Leen

View 2 Replies View Related

Adding Days Onto A Date Field

Jun 5, 2007

I am trying to add a certain number of days onto a date field to create a due date within a Table but can't work out how to do it. I know that to add days on I can use the function DateAdd but the only way I can see how to do this is to create and update query to run and add the date on. Is there anyway that I can set the field to automatically update the due date dependent on the priority of the record e.g. immediate (1 day) standard (3 days) and request (28 Days)?

View 3 Replies View Related

Adding Fields Into A New Field Drives Me Mad.

Dec 4, 2007

So I have a table containing 2 fields containing the first name and last name of a customer. I do need to add these names in the same table into a new field called Name. Can someone help me out?

View 5 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

Anyway Of Adding Like A Count Field To A Query Please?

Feb 3, 2006

Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries.

For example:

PositionID NumOfVotes Count
5 5 1
6 2 2
etc.

Any advice please?

View 1 Replies View Related

Anyway Of Adding Like A Count Field To A Query Please?

Feb 3, 2006

Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries.

For example:

PositionID NumOfVotes Count
5 5 1
6 2 2
etc.

Any advice please?

View 1 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

Simple T-SQL Problem Adding A 0 With A Field

Mar 6, 2008

Hello,

I am having a small problem inserting a 0 in a text field that contains a date. I work with large amounts of data derived from other systems and I have to format them to meet the requirements to be feed into others. I need a query that will only insert a 0 to the single digit day within a date where a text field date looks like say 01/2/1998 and I need it to look like 01/02/1998.

Thanks in advance for any help!!!:

View 1 Replies View Related

Adding New Field To Query And Then Form

Mar 6, 2005

I have created a form from a query. I have then at a later date added a new field to the query. I have returned to the form and attempted to add it to the form but it doesn't show the new field within the control source options. Does anyone know why? Do I really have to start all over again with my form?

Thanks
Just1

View 3 Replies View Related

Adding Criteria On The Field Being Filled.

Aug 6, 2005

I am working on a scheduling form that uses 3 combo boxes to select the people being scheduled. The form is rowsourced to a table of training sessions with a field for each of three crew positions being trained. One combo box is used for each of those fields. The row source for each combo box is a query that returns a list of people due for training, not on vacation that date, correct crew position, etc.

The problem is this: I want to eliminate the people already sceduled in prior sessions from the list. I've tried to put a "not" criteria on the rowsource query but that did not work.

I've been away from Access for a few years but I vaugely remember problems of putting criteria on the field you are filling. Anyone have any ideas?

View 5 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







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