Hey all, I'm somewhat new to working with Access (aw geez, a noob) so I am hacking and slashing my way through creation of a database for a user at my job. The problem is this: I have created a form for tracking incoming calls and would like it to notify me when a call comes in from the same phone number. I would like it to notify me after the number has been entered by something like a color change or popup, so that I am aware of the duplication while I am continuing entering information on the form.
Like I said, I am new at this, so I am hoping this is a simple thing. Everything I have found so far just indicates how to delete duplicates. I want to keep them and just need to know when they happen while entering them.
Thanx for any help for pointing me in the right direction.
Beags
2  1427 
Try this in the Before Update event of the Phone number control.
' (be careful with the syntax - it is ' " & strField & " ' " without the spaces
If (Not IsNull(DLookup( "[Field]", "Table", "[Field] = '" & strField & "'"))) Then
MsgBox "This Field " & UCase(strField) & " is already in use."
Else
' All Ok Continue
End If
Fantastic.
That worked just fine.
Thanx for the help, I appreciate it.
Beags
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: mra |
last post by:
I want to receive a notification (via an event), whenever a property is
modified.
Of course, this would be possible if i write code such as the following to
EACH "set" part of each property:
if(Modified != null) Modified(this, EventArgs.Empty); //Modified is an event
Yet, this is annoying. How could I avoid this code duplication? Do
attributes help here somehow?
|
by: Steve Jorgensen |
last post by:
A while back, I started boning up on Software Engineering best practices and
learning about Agile programming. In the process, I've become much more
committed to removing duplication in code at a much finer level. As such,
it's very frustrating to be working in VBA which lacks inheritance, one of the
more powerful tools for eliminating duplication at the level I'm talking
about.
I've recently come up with a technique to emulate one...
|
by: Tcc |
last post by:
Hi All,
Assume there are some data in "a.txt":
e.g.
ABC
|
by: SB |
last post by:
Can someone please tell me Microsoft .NET's position on this WS-Notification
specification that includes the pub/sub model? Is there something in the
pipeline or already available as part of the .NET or WSE?
--
Kind regards,
SB
|
by: =?Utf-8?B?S2F2aXRh?= |
last post by:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.
But only one of the users is facing following problem:
Whenever the user submits an “Approval Process” form, there are 3 times
entries of same record with 2 – 5 seconds time difference.
This problem was faced by user in May and now again in last week. So, even
this user does not...
| | |
by: dbarmer |
last post by:
I have a unix database system that hold three tables, 254, 255, 256, and all are linked together by WO, CUST NO, LOC NO. This is for Unix Program Purposes Only. Duplication here is by design. So Up Front I have duplicated data due to a sequence work'd performed. For example. WO 000001 has duplicate WO, CUST, LOC etc... four times because it has four different Work Descriptions.
SO, When I transfer these tables to access and create a...
|
by: arnuld |
last post by:
I have created a program which creates and renames files. I have
described everything in comments. All I have is the
cod-duplication. function like fopen, sprint and fwrite are being called
again and again.
I know to remove code-duplication I have to make functions and pass
arguments to them but I am not able to think of a way doing it. Can you
post some example for me, out of this code:
|
by: henry |
last post by:
Folks:
Using Dreamweaver CS3...
Consider a home page, "index.php" which conditionally REQUIREs one of 'N'
HTML files of pure content. All site styles are specified in a master CSS
file, "siteformatting.css"
The home page, "index.php" must link to the master CSS file, so that HTML
elements in this file can conform to site-wide standards, right? (Or
|
by: markmcgookin |
last post by:
Has anyone used the notification class from Windows CE forms?
using the following code
using Microsoft.WindowsCE.Forms;
...
Notification note = new Notification()
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
