Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: the data of one field trigers the data of another

11 Mar 2014   #1

Windows 7 Home Premium 64bit
 
 
the data of one field trigers the data of another

In MS Access how do I have one field's data trigger another data?
I've tried this but no result:

Private Sub rfi_closed_BeforeUpdate()
If rfi_dt_to_contr = "NULL" Then
rfi_closed = "NO"
Else
rfi_closed = "YES"
End If
End Sub

If "rfi_dt_to_contr" is empty I want the field "rfi_closed" to be "NO" and if there is data [i.e. a date] it is to be "YES".



My System SpecsSystem Spec
.

11 Mar 2014   #2

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Hmm, it's been a while but as I recall NULL is not the same as EMPTY.

Regards,
GEWB
My System SpecsSystem Spec
11 Mar 2014   #3

Windows 7 Home Premium 64 bit sp1
 
 

This MS website may help you as there is a list of the various types of field data information requests. Refer to the list down the left hand side to check for other types.

IsNull Function
My System SpecsSystem Spec
.


Reply

 the data of one field trigers the data of another




Thread Tools



Similar help and support threads for2: the data of one field trigers the data of another
Thread Forum
software to monitor devies on network, data speeds, data usage ? General Discussion
Moving Boot Data to Data Drive Backup and Restore
Data recovery problem, Can reach corrupted data but no external space. Hardware & Devices
windows media player data disk wont allow me to add data when Music, Pictures & Video
External HDD data recovery - Chkdsk erased some data!! Backup and Restore

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:05 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33