September 8, 2008 10:01am pdt

Member Login

Hall of Fame

Yearly

1capricorn1 709,737
2boag2000 480,415
3LSMCons... 380,510
4DatabaseMX 339,388
5peter57r 255,702
6harfang 179,713
7jimhorn 144,623
8wiswalld 140,673
9koutny 86,850
10MikeToole 85,778
11hnasr 80,644
12eghtebas 79,977
13GRayL 79,924
14ldunscombe 79,386
15TextReport 76,173
16frankytee 74,964
17omgang 60,422
18LennyGray 56,432
19irudyk 56,350
20mbizup 55,552
21jefftwilley 54,970
22JDettman 53,870
23Rick_Ric... 53,365
24matthews... 45,897
25JezWalters 43,325

	[x] Attachment Details

EXPRESSION BUILDER

Zones: Access Forms, Microsoft Access Database, Access Coding/Macros

Tags: MICROSOFT ACCESS 2007, MS, 2007

Hi guys.

Right i have a form with a tick box labelled [IN STOCK]
i also have a a field called [date packed]

using expression builder i would like to write an expression that when [in stock] is ticked a the date is inserted in to the [date packed] field

again i am very new to this hence i would like try and write it in expression builder.

Cheers guys

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.1

Question Stats

Zone: Software

Question Asked By: davidwalters

Solution Provided By: koutny

Participating Experts: 2

Solution Grade: A

Translate:

Loading Advertisement...

Open Discussion

Comment by davidwalters

im trying to use this again for another field but i get an error.. null function not allowed any ideas?

when you enter a delivery note i want the date to appear in the delassigndate field
when you remove the number from the delivery note i want the date to be removed..

         
             Private Sub delivery_note_number_AfterUpdate()
    If Me![delivery note number] Then
        If IsNull(Me![delassigndate]) Then Me![delassigndate] = Date 'only set the date if the field is empty (null)
    Else
         
         Me![delassigndate] = Null
    End If
End Sub

Open in New Window Select All

Comment by koutny

you will probably need to change the condition for checking whether the delivery note number has been entered:

Private Sub delivery_note_number_AfterUpdate()
If not isnull(Me![delivery note number]) and Me![delivery note number] <> "" Then
If IsNull(Me![delassigndate]) Then Me![delassigndate] = Date 'only set the date if the field is empty (null)
Else

Me![delassigndate] = null
End If
End Sub

Comment by davidwalters

koutny you are the man!
Can you explain the code for me?

i undertsand the basics.. i just didnt want to just copy and paste it...

Thanks again :D

Comment by koutny

An if command expects a boolean expression which can be evaluated to either true of false. With a check box you can pass its value as a boolean expression because Yes/No can be easily translated to true/false.

With a text box I don't think there is a direct translation of its value to true/false (there would be in C++ but this is Visual Basic). So you need to use the isnull function which returns a true/false value. What can also happen with a text value is that it can be an empty string which is not a null value but doesn't count as a valid string for your purposes either (hence the second part of the condition)

I didn't ask where the error you were getting occured. It might be possible that you get an error when you try to clear the delassigndate field by setting it to null - you would get an error if this field is marked as required in the table design.

Comment by davidwalters

koutny i undestand now.. with a check box you automatically a yes no response where as a text box you dont.. which makes sense.. excellent.. i only wish i had assigned this as a new question so you can some more points in return.. thanks again koutny you have been again most helpfull

Comment by koutny

you're welcome

20080723-EE-VQP-34 / EE_QW_2_20070628