Search results

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?

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

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

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

Hi I wonder if anyone can help, just upgraded to access 2007 and having difficulty with getting a date field to automatically update when I check a yes/no box, not sure if macro or expression builder is the way to go. I have had a look at a few suggestions but still having difficulties. Please...

:o Hi this is probably so simple I keep missing it, but this froum has been a great help so far. How do I get a window to open maximised? Thanks Dave :rolleyes:

Hi I have a primary key autonumber set up which increases by 1 each time. I was wondering if it is possible only to display the last 3 digits when using tihs number on forms / reports etc. Dave :confused:

:mad: Hi got a bit carried away setting up my databse and only allowing certain access to certain users. In my haste I have unticked all the startup options and now can't get access to the tools menue to reinstae the startup options :eek: .Help please how do I get them back. Dave

:confused: Hi new to this don't know if this is in the correct section. I have set up a database and have a couple of yes/no fields. Is there anyway I can get a field which will automatically put the date in when the yes/no box is ticked? I have been looking at this for ages now without...