Search results

DB7: your code produced an error (see attachment)

DB7: How do you make the code go to the next line like that and make it work?

Wyane: New error message see attachment DB7: Don't worry

Wyane: that did not work either. ***Edit*** I get error message (See attachment) ***End edit*** DB7: I'll post the entire if statement so you get an idea of why I need it like this If DLookup("[Book_ID]", "tbl_Inventory_Each_Book", "([Book_ID]= " & Me![Condenced_Book_ID] & " ) and...

Thanks wyane It did not like me puting in "Not" If DLookup("[Book_ID]", "tbl_Inventory_Each_Book", "([Book_ID]= me![Condenced_Book_ID]) and ([Customer_No]=[txt_Cust_ID]) and (Date_Sold Not IsNull)") = Me!Condenced_Book_ID Then also tried: If DLookup("[Book_ID]", "tbl_Inventory_Each_Book"...

Hi all, I am trying to make this code work for finding whether the Date_Sold has a value in it but do not know how to incorperate a "Not isNull()" thing in there heres my code: If DLookup("[Book_ID]", "tbl_Inventory_Each_Book", "([Book_ID]= me![Condenced_Book_ID]) and...

I do not think I will be able to have the same for the miscellaneous books. The miscellaneous books are books that are generally the same type of book eg magazines etc that the user does not need to have author etc, and he sells them all at one price. This is where quantity comes in, I have it...

Thanks Rich, but I had already had support for that when I first started. I am going to have to have one record per book because each has a different price, although I 'could' have a quantity field, I do not think it will work very well because the same book/customer may bring it back and...

Thanks everyone, I think I might try out Rich's Idea (Brilliant Idea!!!). I should have asked this question long ago... Thanks again

Does any one have any suggestions? Would this work? Would it be better? Thanks for any advice

You have not even tried it and you are stating it wont work from looking at the one line. I got it from my data base and it is working code. I think that what the code has done before the line may be the problem or that the problem may be that your code leaves a required field empty before the...

I think I might have the customer number as one field and as a number format set at byte for size. then I might have the current customer number table store the other stuff. Also here is a screen shot of the sales form with the onresize disabled so you can see the controls that you don't...

This is not for a website. this is for a phyisical store with phyisical customers that walk in to the phyiscal store and get a book off the shelf and buy. The customer takes the book they what to buy to the counter and the sales person scans the barcode the store has printed of the genune...

Clinton Jokes and One-Liners Q: What does Monica Lewinsky have on her Resume? A: "Sat on the Presidential Staff" Q: What's the new press name for the latest Presidential scandal? A: Fornigate. Q: What do Monica Lewinsky and Bob Dole have in common? A: They were both upset when Bill finished...

Bush and Clinton on a Train Bill Clinton, George Bush, a spectacular looking blonde woman and an enormously large woman with an unfriendly scowl are in a train car. The train passes through a tunnel, and in the darkness the unmistakable sound of a slap is heard. As the train pulls out of the...

Clinton Goes to Hell One day in the future, Bill Clinton has a heart attack and dies. He immediately goes to hell, where the devil is waiting for him. "I don't know what to do here," says the devil. "You are on my list, but I have no room for you. You definitely have to stay here, so I'll tell...

A Robber Meets A Theif Late one night in Washington, D.C., a mugger jumped a well-dressed man and held a gun to his ribs. "Give me your money!" he demanded. The man stiffened, but said indignantly, "You can't do this to me - I'm a U. S. Congressman!" "In that case," replied the robber, "give...

More funny pictures

Here is some funny pictures. enjoy

Hi All, I have many problems with this sales form I have been creating, one is slow on old machines, two is more complex than any other project I have created, three although it works well overall, it still has errors (Have been working on it for 4 months). This last feature (1, 2 and 3...