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

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Win8.1 / 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
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
Mixing a GPT data disk with MBR OS and other data disks
Hi guys Need some advice here. I have Win 7 Ultimate x64 installed on a H77 board (assume it's UEFI compatible). The OS is on a partition residing on a 160GB raptor HDD that's MBR/NTFS formatted. I also have several other 2TB WD Greens also on MBR/NTFS. I've recently gotten a Seagate...
General Discussion
amd data change update new data to dmi
Need help.. when I turn my pc on itll load windows then shuts down with a really quick flash of BSOD. Then says "amd data change update new data to dmi" Ive put the window 7 disc in and I just get the compatibility report screen! Help?
BSOD Help and Support
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
Moving Boot Data to Data Drive
So I've been using my 64GB ssd as my windows 7 boot drive and i have a 1TB hdd as my data drive. Recently the my computer has begun to freeze up with errors like "explorer.exe" has stopped responding or "windows" has stopped responding and half of the time when i try to boot it says it cant...
Backup and Restore
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
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

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 08:06.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App