Access Question!?

Question

I have a data entry form that calls a query where the user enters the ID number to retrieve records. If there is no record of that number, its just a blank form. Can i specify a message so that if the ID doesn't exist the message can pop up? how?

The form pops up right away as soon as the database is opened asking for the ID. s0 the enter parameter box comues up right away.

let's say the user enters 11 , and there is no ercord with an id 11.

Thanks, but i don't see the nodata option.

Answer 1

Ohhh... I misunderstood you. I am not too familiar with data forms in Access, I prefer VB. Is there an 'On EOF' event maybe on the form? You might want to repost.

Do you have a button that the user presses to get the record?

In the code of the button just check for the length of the id. Like so :

If Len(txtId.Text) > 0 Then
...If IsNumeric(txtId.Text) Then
......'Perform Search
...Else
......MsgBox " That is not a valid id number!"
...End If
Else
...MsgBox " That is not a valid id number!"
End If

***What is the 'enter parameter box'? Is it an inputbox or another actual form? Is it called from 'On Load'?

The periods are there for indentation. I hope that helps and answers your question. If not provide more detail.

Answer 2

Inside the form design.
on properties dialogue.
select all(tab)
select on nodata
write an event procedure that tells no data,and quit the form.

Answer 3

hello friend
I am very happy we can discuss about business experience .i hope we can told each other more important experience .i have a website online store, we are pleasure to offer you large selection of fine products .we are a dedicated shoes .clothes . curio computer for many years ,on this website we will introduce our brand ,as Jordan Puma Nike Gucci Monster dunk Turbo tommy polo Adidas Prada Sony ,Panasonic Lenovo Apple Fujitsu an so on, i hope you can wasting a little time to looking for it, the quality is very goods ,and the price is very low,we can offer large numbers of goods for the seller, this is my MSN [e-mail] and [e-mail] .my email address is [e-mail] [e-mail]
i hope you can joins us ,we are happy contact with some overseas friends .make friend with you ,and make a business-ship with you ,we hope you can interest in our website goods and joins us .thank you very much .
Have a nice day
llpshop