Search results

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.

Hi John, Thanks for taking the time to look at this however i cant use a Combo Box and can only use a Textbox due to how the Database already is set up. Thanks for taking the time to look.

Hello all, I could do with some help on the attached Database, it is not the full project but i have scaled it down so i can attach it. I have a Query that is set to look at the name inputted on the main form and if it is their Birthday it shows the entry on the query. If not the query is...

Hi Wazz & Tara, Thanks for taking the time to look at my problem, so sorry for late reply as i have had a long week end away. What i have ended up doing is using a "If Not" function where it looks at a text box (QuantityLeft1) which takes its value from a Subform and depending on its value...

Hi all, Thanks for taking the time to look at this problem of mine and any help you can give i would be very helpfull. I have a Query that counts how meny entries there are with set criteria's but when there are none it returns a blank display. How would i be able to make it return 0 when...