Search results

i have two dates one is called order date and the other is called date required i need to validate these using a created and coded function. both field are on a form call Orders. the things that they need to b validated for are: *the order date must be before the date required *must be valid...

dcount productID, T_order_line, productID > 0 ) insert into ........ if dcount productID, T_order_line, (the first dcount +1) then msg box "this is a duplicate" this is basically what im trying to do, how can i compare the two dcounts and see if it has changed after the insert into

i need to do a Dcount before and after and insert into statement i have the inser into part working now but how would i do the two dcounts so that access looks to see if there has been a change to number of records therefore testing for a duplicate. the field to dcount would be productID, so...

what would the basic syntax be to check for duplicates in a form. the field that need to be checked is called ProductID

I am trying to create a button on a sub form to add the records on it to another sub form on the same for, if that makes any sense! below is my current code and it works sort of, it picks the the records and values but doesn't put it onto the other form. any ideas? Private Sub...

thanks for the help guys i have it working now :)

for some reason the file doesn't open properly. i have tried extracting to desktop as well but opens blank even after enabling content

Hi, i need to select all records and delete them but i dont know how to select al or delete all, i have working code to delete one record within the form but cant delete all, his has caused me problems for a while now. this is the code to delete one record: Private Sub DeleteOrderbtn_Click()...