Search results

thanks guys that worked. How would set this so it only enters the current date if the text box is blank. Cheers R

Thank rural Guy, I tried that. I put date() in OnEnter, but I get the error message " Microsoft can not find the object date()" Is that the wrong code??

Hi All I have form with thousands of records where users input data One the boxs is a text box and the user has to enter the date. I would like it so if the user clicks or tabs into the box it will automatically show the current date. But I only want it to show if the user clicks into the...

Fabulous thank you very much

(((Warranty.GoodRecievedDate)>[Forms]![AMKReportFramework]![AMKDate1] And (Warranty.GoodRecievedDate)<[Forms]![AMKReportFramework]![AMKDate2])

Hi I have a database that runs all the outstanding warranties. When i run the report lets say between 01/02/09 and 01/03/09 it will only give me results of warranties entered between 02/02/09 and 28/02/09, it is not including the dates that I actually enter but is between them Is there...

haha, well my weekend starts now! I finish in 2 minutes :)

I feel so thick, of course thats the way to do it. Sorry its been one of those days today :) yes i cant create mde file in 2000 format.

I just figured that out, that works for new databases but the one i currently have is still in 2000. it has not changed! :( Any Ideas?

Actually, i thought i solved it, im having problem with this 2000 format. I have 2003 but when i create a database it automatically creates it into 2000 format???!?!? how do i change that? Thinking about the layout looks like 2000 aswell. Ive checked in add/remove programs and there is only...

Hey It should have only been the date parameters that appear, when i was running the report it was asking for a parameter for every field in the qury even though only the dates had parameters in the query!!?? bizarre but like i said that is sorted now as i used the database splitter tool. I...

Thanks, when i run the querie direct it prompt for the dates thats in the queury which is correct then at the bottom the progess bar runs the query but then crashes the whole database. I have resolved this issue now, as I have used the database splitter and all is working fine. I will try to...

Sorry I also forgot to mention, even though the users open the front end they can still see the reports, queires etc, and delete or alter the reports. Even though i have password protected the back end????

Thanks, I have tried exactly what you have suggested, and it does work but when i run the reports, it comes up with pop up box for every field in the query that the report relates to. Woud youi know why? Thanks

Thats fantastic thanks Jpaulo

Thanks everyone for you help. thats great

Thanks Damo, how do I split it?

Thank you but that has not made any difference

Hi I have an Access 03 database that is centrally on the server, I then put a short cut link on users desktop to the database. I would like to know how to not let users have access to the back end of the database, users have been going in and altering tables etc, I only would like them to...

Hi I have set up a form and a table for users to enter there user name and password. I have set the table with 2 user names and passwords to go with them. How ever when the I enter the users name and password the first one works, but the second one says invalid. even though I know I have...