473,405 Members | 2,300 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

increase value of field

266 256MB
i have an unbound text box on a form with '0' entered in it. i also have another text box linked to my table. what i would like to is when the linked text box (dayoff) has a certain criteria entered (ie. Vacation) i would like my unbound text box (vacaused) to increase by 1. any ideas?
Feb 2 '10 #1
1 2986
missinglinq
3,532 Expert 2GB
This will do it:
Expand|Select|Wrap|Line Numbers
  1. Private Sub DayOff_AfterUpdate()
  2.  If Me.DayOff = "vacation" Then Me.vacaused = Me.vacaused + 1
  3. End Sub
  4.  
Linq ;0)>
Feb 2 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Shamet | last post by:
Dear: Com.database, My name is Shamet, I am working with large questionnaire, I need your help to solve this problem, how can I increase the field size in the text data type, I want more 255...
2
by: Miguel Dias Moura | last post by:
Hello, I have a dataset (users) on an ASP.NET/VB page (detail.aspx). A record on this dataset (users) has 3 fields: "id", "username", "visits". The page detail.aspx is called with a...
3
by: Shapper | last post by:
Hello, I have a database table with 2 fields: and ; I need to create a function which increases by 1 the number in field for a certain id. In this moment I have the following: Private...
1
by: Phil396 | last post by:
I am using an old version of the DAAB. I need to set the command timeout property. This is my code. SqlConnection myConnection = new SqlConnection(_ConnectionString); DataSet ds =...
4
by: =?Utf-8?B?c2FtZWVy?= | last post by:
environment : .net framework 1.1, ado.net, visual studio 2003, vb, sqlsever 2000, winforms, webforms I want to increase the timout of the webservice in the application which is being used in a...
3
by: nineoo | last post by:
To all, Ok , now this may sound a little crazy, but does any one know if there is a way to increase the maximum value of a unsigned long int? I'm aware of the the max value of an...
0
by: anuragshrivastava64 | last post by:
Hi All, I am currently preparing a database updation patch that copies tables and queries from one table to another.(using vb and ms-access) Can u please help me to increase the field size of...
3
by: remya1000 | last post by:
I’m using Vb.net application program. I created a datagrid having text field and checkbox fields. Everything is displaying correctly. I have 9 Columns and each columns are equally separated. In...
4
by: zoeb | last post by:
Hi. I have a form which the user enters 2 years worth of data into (one record per year). The aim, is to populate the table this form is based on with 3 more years worth of data (i.e. creating 3...
9
by: prncstela | last post by:
Hi. I am fairly new at Access and am in need of some help... I am trying to use the database located here: http://office.microsoft.com/en-us/templates/TC102068781033.aspx?pid=CT101428241033 ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.