Topics Search

Increasing values

Increasing values
Views: 0
I have a field with number values

id_field contains numbers like 1,2,3,4.(some of them are repeated)

In a form the user introduces for example 2, then all the values >= increase by 1, how I do that?

the user introduces 4 then.

7-5 (change id +1)
8-6 (change id +1)
9-4 (new)

or just tell me, this is possible in access or not?
Sponsored Links:

Similar posts...


Field Size Option Not Working in Access 2016

Field Size Option Not Working in Access 2016 Icon
That’s right, another MAJOR bug has reared its ugly head for MS Access 2016 users in which the combo box to assign a Field Size no longer displays any values! For the past couple of days now, we have been seeing an increasing number of reports of the above problem in various forums...

Specific autofill in form

Specific autofill in form Icon
I have a form in Microsoft Access with barcodes for every single product. First I enter the barcode and other values for one product.

Then I enter a new row and my next barcode should be +1 from the first one. Example: the first barcode is C2025540 and the second should be C2025541, the third C2025542 and so on.

Can I somehow enter just the first, and then the next ones (second, third .) fill in automatically by increasing it by 1.

Update query for numbering the records

Update query for numbering the records Icon
Could anyone Pls. help me to form an expression in the update query which will be using to update the numbers in increasing orders for a set of records in a table. For example, a table contains fields like (Customer Name/S.No/Items Description/Unit/Price/Invoice no.). The update query shall be used to enter the Invoice no. in increasing order for the set of Customer name in the fields

Macro for increasing table values

Macro for increasing table values Icon
We have a list of students, all their information, and the grade that they are currently in. There is a field(called: Grade) in a table (called: students), and at the end of the year, i need a macro that increases their grade by 1.

Query to select only records with certain values

Query to select only records with certain values Icon
I have a large database with over 1MM records. It is a database of reservation records, with 15 separate tables. I am attempting to do two things: find records containing ONLY certain field values, and none of the other possible values, and find records that do NOT contain those values.

Example: I need to find records that contain one of three values, and also contain one of 3 other values, but no additional values. The record needs to contain one of these 3 values - UO ADM, UO ADM FL or FLEX ADM, and it also needs to contain one of three other values - CW INCLUSION, TP TRANS or EPA. I don't want records that include any other values

Calculate if number of records is increasing or decreasing

Calculate if number of records is increasing or decreasing Icon
I have a database with a table of every client (current and cancelled clients) and a query just showing the current clients.

I want to show if the number of clients is increasing or decreasing, but I'm unsure how?

I was thinking maybe calculating the average number of records for this month, and then seeing if the current client is above or below this average.

In VBA I have CRecords = ("*", "qCurrentClient")
TRecords = ("*", "tblClientDetails

chart using variable values

chart using variable values Icon
I have some code behind a form which calculates some simple values and places them in unbound boxes. All these values are stored in variables such as a1, a2, a3 and b1, b2, b3, etc

I would now like to make a line graph with those values on the same form, but when I try to use the "Graph" icon it asks me for a query to get the values from. How can I create a graph using known values instead of a table/query

Similar to countif

Similar to countif Icon
I have a current dataset that is in excel however has become to large. Currently in that data set I have a key associated with each record for lookup purposes however that key is not exclusive. For instance multiple records will have the same key. For lookups I have used the formula =countif($B:B2,B2)&B2. The result as I copy this formula down to the next row is each new occurrence of the same key will have an increasing value associated with it. This allows me to set a vlookup to pull the 1st record the 2nd and so forth.

I am going to pull all of the data into access and need to be able to recreate this key so I can put it back in excel as values and then perform the lookups. Because of limited use of Access in my corporation I can not do all of the work in Access

Problem with Listbox update via Combobox and Field Values

Problem with Listbox update via Combobox and Field Values Icon
I have a listbox(includesA) which works via combobox(sel_mac) update sort and the field values that were selected prior, however, the values it posts are numeric ID values and not theactual field values I want to be shown in the listbox.
I have some code below that pushes the updates from the combo to the list.

How to transfer values from forms to table

How to transfer values from forms to table Icon
am having problems with values on my forms in access.the thing is, in my form i change some values by using control source and put some formulas to control source like =date+102 . then im wondering why the values are not reflecting to my tables.