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
Silvera

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
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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
Ranger4

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
Thread Forum
External HDD data recovery - Chkdsk erased some data!!
I booted up my Win 7 computer today and ChkDsk said my Ex HDD may have been corrupted and proceeded to delete some files. Those were some very important files - how can I get them back? (Video and Adobe Premiere Pro CS4 files) I prefer free methods on this - I know I can buy software to do this,...
Backup and Restore
Prep for Win10 - backing up C-Drive Data (app data, fonts, etc.)
In preparations for upgrading from Win7 to Win10, I want to make sure I don't lose any essential program data. Most of my data files (word processing, graphics, etc.) are not located on the C-drive where my OS is located, so they aren't the issue. However, as I recall the last time I had to install...
Backup and Restore
Minitool Power Data Recovery or Runtime Get Data Back, which
Minitool Power Data Recovery or Runtime Get Data Back, which one would you choose or which one did you choose? I want to purchase a serious data recovery program for personal business use.
Backup and Restore
software to monitor devies on network, data speeds, data usage ?
Hello, I have a number of devices connected to my virgin router, via wireless and lan. I was wondering if their was software that exists, that allows you to monitor the speed, traffic, and what kind of bandwidth each device is getting from the router, speed etc too . Many thanks, ...
General Discussion
Data recovery problem, Can reach corrupted data but no external space.
Hi everyone.. My external USb Wd mybook box has 1 tb Seagate Sata 3 and i use original Wd disc as W7 installed... in My PC Case as sata II Today my old problem appears again as Corrupted disc... I have Get Data Back NTFS (and i used before plenty of times for recovery, loss data or...
Hardware & Devices


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 12:37.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App