Topics Search

Increase by 1

Increase by 1
Views: 12
I have a field (non rimary, but unique) it has text i.e.: "Q123", I need to make this increase by 1 form the last known highest number. i.e. "Q123" to "Q
Sponsored Links:

More topics

 

Keydown increase value

Preview
I have a field named Letters where I want to be able to increase the number by one every time I use the keydown function. I have done this in the past but it escapes me how I did it. I guess also the value if I use the keyup key for a greater and the keydown for a lesser value.

Using the arrow keys on my keyboard to be clear. Up increase and down decreases.
 

Access doesn't like my coding but gives the right answer

Preview
Attempting to determine what the actual cost of a salary step increase will be during the current fiscal year. The approach used is to determine the current salary, then the new salary. Their difference would be the annualized increase.

However, the increase will not be in effect for the complete fiscal year. To determine the percentage of the year that it will be in force I use DateDiff using the salary increase date (Sal Con Date) and subtract it from the fiscal year end date which is expressed as 41455 (06/30/2013).

but I get that nasty inbox asking for a parameter.
 

Check Box update in Form

Preview
I have a check box in a table ("increase") and when I check this box I need a few things to happen

1. Increase Price field in the same table (+4)
2. Increase the contract end year (+1)
3. Uncheck a "option" check box in the same table

But also need the ability to uncheck the "increase" and the fields to return to the original price and year. But this is not as important as getting it to update the first time.

I have a from for this based on a query I created (I need to look at only some products and perform this task)
 

VB to Increase record update by 1

Preview
I have a form with multiple fields on it. We will call them SLO They are text boxes and there are 6 of them named SLO1, SLO2.SLO6 What I want to do, is use VB to update each as a string to a table individually. and use a DO WHILE and increase the value by one.

Example.
Current Code looks like this:
 

Switchboard

Preview
How can I increase the switchboard items to 12 instead of 8? At present I can have only 8 items in a switchboard page. Is there any way to increase it to 12 or more
 

Switchboard

Preview
How can I increase the switchboard items to 12 instead of 8? At present I can have only 8 items in a switchboard page. Is there any way to increase it to 12 or more?
 

MS Access 2010 - Changing Text Field Size Across DB?

Preview
I have a large database that has a number of existing tables and relationships. I need to increase the field size of a text field that appears in multiple tables.

My question - it seems that I need to remove the relationships before I can increase the field size - is there an alternative, or a way to keep a record of the existing relationshipsand re-instate them as they are once I have made the necessary changes across the entire database?
 

Issues in Create Email Options : Access

Preview
I have a table and one of it's column contains data that is a the output of a query. This column is drop down box. When I try to create email, using INFOPATH option, the drop down field with all the values is generated properly. However, the field size of the drop down box seems to be fixed. I cannot increase the size and hence some of my data {lenghty strings} is not seen fully. Is there any way to adjust/increase the size of fields in the auto generated infopath form
 

Issues in Create Email Options : Access

Preview
I have a table and one of it's column contains data that is a the output of a query. This column is drop down box. When I try to create email, using INFOPATH option, the drop down field with all the values is generated properly.

However, the field size of the drop down box seems to be fixed. I cannot increase the size and hence some of my data {lenghty strings} is not seen fully.

Is there any way to adjust/increase the size of fields in the auto generated infopath form?
 

Calculated & Manual Entry Fields

Preview
Is there a way to have calculated field & a manual entry field at the same time in Access 2003. I have Calc Renewal Rate: ([Pct Increase]*[Expiring Rate])+[Expiring Rate]. Which is the calculated portion that I want. But, I also want to enter a manual number if I dont have a percentage increase. Example: Expiring Rate = 1000, % Inc = 10%, therefore .10*1000 = 100 + 1000 = 1100. But if I wanted to manually type in 1102 instead, it currently doesnt allow. Is there a way to have both? if yes, how