473,327 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Display the Already Existed Record value

102 64KB
Hello Friends,
I got the solution one of my problem how to display a message if record already existed.

Now I want to display its value with the message.
Suppose, If I entered the Drawing No. 100
There should be a message that "
"Drawing No. 100 is already existed"

Please any1 , (especially Veena) pls help again. Thanx
May 12 '10 #1
1 787
QVeen72
1,445 Expert 1GB
Hi,

Change message box like this :

MsgBox "Drawing Number " & dwg & " already Exists...", _
vbCritical, "Duplicate Entry"

Regards
Veena
May 14 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: SAN CAZIANO | last post by:
How can I display all the record of a certain field in a combobox after I have connected to a db in mysql ??? thanks a lot -- Alberto
2
by: Patrick Fisher | last post by:
Hi To display a message when a user attempts to edit a record in a multi-user environment where a forms Record Locking is set to Edited Record and another user is editing a record, is difficult...
1
by: Darrel | last post by:
I use repeater controls and attach a dataset to it to create a list of records. When I want to display just one record, what should I bind the data to? I can use a repeater, but it clutters the...
1
by: ZinksInk | last post by:
How do I make a report display the current record open in a form? This seems like it should be a simple issue however I am strugling to figure out what code SQL / Querry I should use to do this....
0
by: woollymammoth | last post by:
I can't assign a MS SQL Server table record value to a simple VB variable, should be an easy thing. Sample SQL Server table has the data in the record as a char(30) string, the column for that record...
4
by: Bakarre | last post by:
I have problem in retrieving record from mysql using php form, I was able to retrieve the record, if I edit, the changes is not updated in mysql. find below my code <html> <body> <?php $db =...
1
by: kotresh | last post by:
In my sql how to get the previous record value... in table i m having the field called Date i want find the difference b/w 2nd record date value with first record date... plz any one help me to know...
11
by: Gilberto | last post by:
Hello I have a table PRODUCT NAMES with fields PRODUCTNAME and COMMODITY, another table called COMMODITY NAMES with the only field COMMODITIES (containing a list of 7 different commodities), and a...
2
by: clickingwires | last post by:
How would I go about displaying the current record value in a label? This is the code I'm using and all I get is "1" in the label Dim rst As New ADODB.Recordset Dim cnn As New ADODB.Connection...
7
by: shalskedar | last post by:
In a query i want to retrieve the value in such a way that if the value for the current record for a given column is 0 then it should go to the next record & take the value. for ex-I 've column...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.