Recent content by OrionTC

Does this help? The entry Tape 1 - Tape 10 only exists once until its changed to Tape 6 - Tape 10 for example. thgere is a record of Tape 1 - tape 10 in "before value" from the audit table but that could populated with other before values too from other fields i.e. Total. Maybe its a...

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...

ive had a look and i get what you mean by the table design and i agree it looks a lot better im just very confused how i am supposed to turn the ID's into useful information. for example: tblcustomeritems is various ID's but to the user doesnt mean a lot. is it possible to have this...

thankyou very much i will take a look now

glad you have it, any ideas on what i was doing wrong? (probably a lot)

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...

absolutely. done.

i changed the sensitive data and changed each client to client1-2-3 etc. ok so firstly we have tblstocklevel/frmstocklevel in conjunction with tblcomments/frmcomments. we open the form stock level and select the client, when we use an item of media we adjust the amount in the correct field, ie...

maybe im in way over my head, this was supposed to be a quick side project to get away from a spreadsheet used currently to keep track of stock, but like i brought up its almost useless since you have no audit trail and needs to be right 100% of the time to work. i then thought about making...

thanks, ill give it a look. anymore advice would be appreciated.

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...