Recent content by AccessNewBoy

Lagbolt, thanks for support but already tried to work the Datediff's from seconds and to take all other results from the interval. The issue is still the same, i feel the issue is due to the Datediff being refreshed each second. If i just use two fixed dates and keep changing them the results...

Hello all, as you can see from my user id i am new to Access so any support you can give me would be great as i need it. I have created a countdown counter on a form using different Datediff's so to split the renaining time into days, hours, minutes and seconds. The Datediff compares Now() to...

Yes i agree that is the easy solution, my question was also directed to trying to make the database more secure as some people need to now some data but not all that is why they have access to the folder. Thank you for taking the time to look at my question thou.

Will give it a go when back home, thanks

Hi PaulO, Thanks for the reply, i have tried this and it makes no difference a person can still view the tables when navigating looking for tables to link to.

Hello all, thanks for taking the time to look at my problem. Hi, Is it possble to find out if someone has linked a table on my database so they have the linked version of the table in their database? As you know it is quite simple for a person to open a blank database and select the option...

GALAXIOM, Thanks for listing these links to the Microsoft Access Q AND A. I have spent as little time looking at the site and will be look at the links you sent me. Thank you

LAGBOLT, Thank you for taking the time to reply to my question, i have looked at your code/module and will be looking at ways to use it over the weekend while i am off. I am very new to Access and am starting to think i am running before crawling with this problem. as most of the users would...

Hello, I wonder if anyone can help me. Is there a way for access to pull and show all the file attributes associated with a TXT file located in a folder or one that has been imported into the databae its self? For example: When it was created? When it last was modified? Size etc etc Either...

Hi, thanks for taking the time to reply. Just out of curiosity did you successfully try both these suggestions in my Query? The reason i ask is that when i do none of them work. I am asking in case the error is mine

Hi all, i have an issue with a Query i have created which shows all birthdays within a 21 day period. I have searched this forum and it appears the problem has been experienced by other people to yet the solutions suggested to not rectify the issue do not. so i was wondering if anyone has any...

Thanks for the assistance, like i said i am just getting to know Access and your help and suggestions along with boblarson is very much needed and appreciated.

JBB, I thinks its fare to say your experience in Access supersedes mine. The reason i wanted to use a Text box and not a combo box is that the likely hood of someone guessing a password is high as most office people use a pets name, Childs name or something simple. Compared to the likely hood of...

Bob, This is just what i need, i have been spending a large part of the day trying to create a piece of code looking at using a DCount and even a DLookup without any success. It was my intention to post the code i had done as i wanted to show people i was trying to do it on my own but i thought...

Hi Bob, this is what i need apart from just one thing. I need it to show the persons name in the message box: Happy Birthday Matt Either way thanks for taking the time to help.