Search results

hi how do i make a query that prompts a date and searches for anything that occured after that date? thanks:eek:

any help? pelase

how can i get into VB for a query???

i have a form which has as button that opens a query how can i make it so that if there arent any results from the query then a error message will pop up saying "no results found" and the table dosent show?

but it dosent show how to create a msg command. rather than have a generic error msg when the error arises i can type in a message that lets the user know what is wrong.. whould u know how to do ithis?

thats alright i found out how.. but how can i make it so that it shows a msg box that i can type in my own error message?

hows that done?:eek:

if i had two tables (A and B) which are linked by one feild eg. "user ID" how would i make it so that when data for (table B) is typed into a form that if that "user ID" dosent exist in A then it will not add the record to table B?

that works fine but is there a way to do it in VB, because i want the freedon to wrote a message in the message box

hey, how would u deny a new record if it already exist in the table?

B E A utiful.. ur a gun. thanks heaps.. :eek:

dang . sory i meant i wanted the report to close.. otherwise after the msg box appears the report will appear but be empty. so basically i want nothing to appear if no results are found

hey i got the mesage box to appear, if no matches are found but what code is needed to close the form? i currently have in VB Private Sub Report_NoData(Cancel As Integer) MsgBox ("asd") DoCmd.Close End Sub

hmm. iv foound the properties menu but my events tab has no options

sorry im not the best at access, but i dont seem to know where i can get to the "Report's NO DATA event"

hi, i have a report which is running a query,so when i click on the report it ask for waht to search... but if there is no records found it willl still come up with a report page with empty feilds. how do i create somthing that will automatically close this, and give a message box saying that...

if i had a table with products and i want to keep a record of what has been chaged or added to this product, whilst keeping the old records how could i set it up in a databse? the excel spread sheet looks like this product commments 1 chnged this...

there isnt much relationships at all with my table.. all i did was create a table from the wizard. and thats the only one that exist.. when i double click on the table. the table pops up, when i highlight the row and try the delete it with the delte key i get the error.. and it dosent get removed

haha.. thanks for the help dude. this goes for the other replys in my other post cheeers

i have an entry in my table but when i go to delete it it doesnt work so im stuck with it the error message i get when i try to delete it is "THe search key was not found in any record"