Recent content by dsthome

What an idiot didn't even think about that thought it would be more complex. Over thinking again. Sorted now thanks.

Hi just wondering if the following was possible. In a date field is it possible for a date that is in the future to be hi-lighted in a different colour. eg todays date is 25/03/14 So anything with todays date or previous would stay in black 24/03/14 25/03/14 but anything from 26/03/14...

ACCESS 2010, I have a from and to date in a query. How do I get these two dates to show in the report header please?

Please find attached the Databse I have started this morning very much a work in progress, and very much new to databse design. I may be going completely down the wrong route please advise. I have a table for orders and a table for products, I am trying to get it so when you put the item code in...

If I have 3 tables linked together is it possible when I put a product code in one of the tables it will lookup my product table and return the description in a description field on my orders table.? So far I can only get it to give me a lookup with a list of all the product codes for me to...

If I have 3 tables linked together is it possible when I put a product code in one of the tables it will lookup my product table and return the description in a description field on my orders table.? So far I can only get it to give me a lookup with a list of all the product codes for me to...

Thanks, I think this is way above my knowledge base, I will try and find another option

Hi I am looking to set sommething up that I can place orders in and be able to part ship the order creating a depstach note, but still leave the balance of the order showing for future picking, is this possible with access? Thanks :banghead:

Hi Still quite new to Access, I have designed and been using a databse on access 2010 at work that is shared bewteen up to 10 users, but I have to do work on it every now and then. I need to know if it is possible to set an autologout to log all users out at a certain time, or something I can do...

Hi Friday Brain again I have a query that I run to give me a record of what what issued on a certain day I just used [DD/MM/YY] and then type the dat I require in when run, which has worked fine until I changed the dates that were entered to include the time. Now I run the query is comes up...

Sorry grey cells have kicked into life I have done it now thanks

Hi Thanks for that, I appear to only be hlaf wey there I have got it to return a number, how do I change this to an actual day. Here is the code I used =Weekday([Iss Date]) What am I doing wrong please

Having a bit a brain freeze today. I have a field that auotmatically puts a date in when a checkbox is checked I am now trying to add a field which returns the day of the week from this date. Brain now mashed I am sure it's pretty simple but I just can't get it to work any help would be greatly...

Excellent Thanks Very much I knew I did something like that last time, but couldn't for the life a me remmber how I did it. Once again thanks for your help

Hi Sorry Didn't know what information to put. I have a Database that has a box (yes/no data type) to tick when a certain process has been complete. I also have a date process complete field. I was trying to get the date to automatically fill the field when the tick box was checked. hope...