Search results

yep thats it..

Not sure about dirty stuff..am v new to access as you can probably tell! Why does it ask me for a supplier name parameter...is it not able to get it from the text box??

Oo I have a development.... I put a messagebox within the code to see whether it was going to the sql sequence and it wasnt until I made the fields "dirty"...i have been entering a new supplier in and saving it and then going back to it so that is not dirty..but when i go to delete it the delete...

Ok I changed the tablename to the name of the Supplier table "Suppliers" and the other two to Sup_Name as the text box in the form has the same name as the field in the table...but I get a syntax error..

Hi guys, thanks very much but its driving me a bit mad so I might just go back to the wizard button and I dont really have much time to fiddle with i still have to fix all the other problems I have created!. Is there a way to stop the warning message coming up with the delete cascading...

Hi James, no not yet , how do I reference the record that is currently selected? you put me.supplierno ??

Noo, not in the main form...i created a test form without the subforms and it seemed to delete the record eventually after a bit of opening and closing and then it worked quite well...

:confused: Do I need to create a delete query? Am majorly confused now, can u not delete a record using VBA only?? Thanks again, VB

Yep deleting them in the main table works..but nothing is deleted using the form button....not even the main record...

Hi James, Thanks my cascading is all ticked but it doesnt work, the delete button doesnt seem to have an afterupdate event..?

Hi Guys, I have searched the forum for the answer to this question but have not found the solution yet. I would like to get rid of as many macros in my database as possible and rely on the VBA. I have a button to delete a record on my mainform, which I have put the following code: Private Sub...

Could do but I did a few things on friday to my saved copy which I might not get back...i am a plonker!:eek:

Oh Dear I think i have broken the search again it doesnt seem to send the filter to the output fields anymore...Doh!

oo so would it end up like IN('AB' AND 'AL')? Or would that not work!

Ok, not sure whether I need to have it select only those that satisfy both or not argh...hmm..

Cool thanks, is the bit in the IN('AB','AL') an OR function? Does it result in an output of the records that satisfy either as opposed to both?? :-)

ah cool I thought that was the case as I fiddled with it and it worked! I seem to fumble my way round ! Is there a way to improve what I have done ie make it neater??

Thank you very much vbaInet that is great and so neat! How does the code determine how to search through the multi-valued field as opposed to a normal field? I have modified the code to be able to search the container and waste type as a multiselect combobox from the single field container and...

Thanks v much vbaInet, Thank you for the database am still confused as to how i would get my datasheet view of services to allow the user to put in the postal codes (and be able to copy the postal info from another service) and have the postal codes saved in a long list....do queries work in...

Oops just checked and the box is a combobox, so does that make a difference.....!