Search results

Hard to describe what i want but ill explain. I created a stock database with a field called "tape range" so inside this we would have for example Tape1 - Tape 10 which has a total of 10 tapes. When someone uses 5 tapes this range now becomes Tape 6 - Tape 10. because 1-5 have just been used...

Hi is it possible to have access send a reminder/email after a certain amount of time has passed? ie... Product - 3 Bottles Time Sent - 12:00 Time Arrived - (send email if this field has not been filled in within 2 hours(SLA)) I have looked at some pretty intense VBA scripts that look overly...

Hi all, i was wondering how it was possible to create a query where by when you update the quantity field it will copy the "old" entire record into another table and keep the existing one updated with the new quantity. for example: Tape Range: 20 new media Tape Type: DVD Date Added: 20/11/2010...

Hi i am looking to create a new stock control DB and i want to be able to create a report which flags up any stock under the reorder level and keep a track of when the media has been used... the stock table contains the following: ClientName CD DVD Floppy for example. when a client orders...