Search results

"Then set the control's RunningSum property to OverAll" Sorry, got the first part, but not the second - Please could you elaborate. Louchey

Could you zip up your db and post it so we could have a look and help???

Cheers Moonshine, Did a bit of trial and error myself and realised the same thing. Will look into my Windows setting. Cheers louchey

sorry, it is now formatting to MM/DD/YYYY Louchey

Hi Guys, I Have been using this function basically to export data to .xls and giving the last part of the file name as todays date. Been working fine, but I've noticed today that is not formatting the date to DD/MM/YYYY anymore?? Can anyone see anything I'm missing?? Thanks for any help...

why not just give the db a password or setup user gorups and security??? Louchey

Thanks Rich - I always forget about that.

Sorry - I created it in Access 2K !!!! I'll see if anyone is running 97 @ work.

Heres a basic example using a query to find criteria - Without seeing exactly what you want it is hard to write code for you. Hope this helps Louchey

Well this forum is a perfect tool if you search the archives for problems you run into along the way. Access will definately cope with what you are trying to achieve. Getting yourself a good Access "Bible" would be the best you could do as it will help to teach you some do's and dont's of...

An Idea ??? It's part of my religion !!!!

Damm Right Soundsfishy, was even colder in west Melbourne !!!! Needed a beer @ lunch to warm up !!! Louchey

I recommend structuring your tables something like this......... Split your tables into 2. If the "MemberNo" is the persons name, then have one entry per person in the main table. I would use this as your primary key. All other fields can go in table 2. Create a relationship between the 2...

No, but it does require some code. Please try searching the archives as this has been covered numerous times. Let me know if you still have any problems Louchey

Add this code underneath the code to open form DoCmd.GoToRecord , , acLast Regards Louchey

Try searching previous posts for "dateDiff" and "MsgBox" function Regards Ben

Thanks very much Travis - Simple when you know how eh!!! Louchey

Hi Guys, Know this must of been covered before, but had trouble finding a solution inthe archives. I'm working in Australia at the moment and would like to change the date format. I have created a module that exports data to an excel file, and gives the file name todays date. I would like to...