Search results

ok, let me try sort that, be right back. em

right, ive had to delete nearly everything! i think i have left what you need, but if i have deleted anything, please just let me know. Thanks very much! Emily

Problem with posting my db, apparently its too big to post, even when zipped. I'll try and sort something and get it posted in a moment. Thanks for you time, its really appreciated. Emily

i am still getting the same. No result for qryTotalquantity which means no result for the qrytotalfree. I have tried putting the nz bit into the 2 first queries which create the value for the 2nd but this does not work either. Im going to try and explain how it works a little better, and it...

nz - null values in queries - CRACKED!!! i have checked the forums and i know they kind of answer this question, but im not really sure where i am ment to write it! I have two queries, which a third query subtracts the 1st query and 2nd query values and gives the end value. If the 2nd value is...

thanks for the help. I have worked out how to complete this task in a different way somehow! But thanks anyway R G, you have been very helpful! Emily

I think i have got it! i just had to change when the code was being executed and hey presto! it works. Thanks very much Antonio, you have been a great help. I will probably be back on with another problem soon anyway! Emily

Thanks for the reply. Although i can see what this is ment to do, for some reason, i cannot get it to work. The message box appears with 0 records every time. I do need it to see if what is in the text box matches any value in the query, but if it does, i need the command button to show, and if...

How can i show command button if text box equals one or more query values? Hi, I have had a look at quite a few threads, but cannot find what i need. I am looking to show a command button if the value typed into the text box equals one of the values in the query. I understand how to show/hide...

sorry, RG, i dont fully understand what you mean by the previous post. emily

what is the recordsource of the form?

ha got another problem now: i want to click on a button which will look at a number in a field on a form, open up the new form, and find that number. If the number is not in the table, it shows a blank (this is the part i was doing a minute ago) I can get everything to work on their specific...

ah brilliant, ill use that, that would be better! Thanks! em

ah i cracked it! Thanks anyway. i ended up writing: stDocName2 = "frmStock" if isNull(txtCustomerNumber.value) Then DoCmd.OpenForm stDocName2 End If Thanks for the help previously R G!!! Em

ok thats great thanks! 1 more thing, i am trying to get my command button to open another form if a specific text box is blank. I can get it to do this if i have a specific value typed in, of my choice, but as soon as i want to have it blank, it does not respond. I thought i could just type: If...

Go onto your form, and on the toolbar, you need to click on the button which is a square, with what looks like some text and 2 small squares inside it. If you hover over the symbols, it should say "Subform/Subreport". Click on that, and the wizard is pretty good! Select which table you want to...

Access error: you can't reference a property or method for a control unless the co... Hi, Can someone tell me what this error means? "You can't reference a property or method for a control unless the control has the focus. It is to do with a text box on a form, checking whether it has text in...

i think that may work, ill have a go and let you know! Thanks em

problem is, there could be thousands of numbers, there are alot of customers! Also, due to one customer having possibly more than one item, their number may be able to be found more than once. This is fine for the search, as there are say, 3 records in the filter. But how would i delete all...

Hi, I am trying to do a search that will find all the records matching the customer number typed in another box on a different form. When i search a valid customer number, i.e. a number which is in the table, it will find the correct record, and close the other form. The problem is, if the...