Search results

Thank you Goh, it has not been what anyone has suggest that has pushed me past my limits. I am also not frustrated with the program as I know it is completely my fault because I don't know how to use it. I am irritated with those who act like I should know all of this when I repeatedly explained...

JHB, I appreciate all of your help and I will most definitely look into the references you sent me. Thank you very much, hopefully I can figure out what I am doing wrong, it may be something as simple as my table names are not a good fit for VBA code. I will continue trying to understand the...

Moke, I will get back to you tomorrow but I unfortunately do not think that this will do what I need it to. Thank you for your help! Cronk, Yes, that much is obvious. However, it is not working in my database. It continues to come up with an error no matter what way I type it. The problem is...

Different in my code. I looked up the field Last Date Sent in my database because it couldn't find it when I put it in the WeekReminder1. So I did the look up and then inputted what the look up was called into the DateDiff code. I wasn't sure if it would work but I gave it a try. I have another...

At first the debugger didn't bring anything up but now it highlights the line for LastDateSent and brings up the error: Run-time Error ‘2465’: Microsoft Access Can’t find the field ‘|1’ referred to in your expression. This is all of the code that I have, the dcount wasn't working the way I...

So that isn't working for me, sorry for the trouble. Let me try to explain it better.. I am trying to create a reminder form that will come up when my database form is opened. I need the form to search through the table for two criteria, if the Survey collumn is not check (= No) and the Last...

Plog, I am trying to avoid queries as the ones using this are not very familiar with Access so I am making it as point-and-click as possible. "Date" is not the actually field name I was using it as an example; furthermore, "Database" is not the name of the table, I also used it as an example...

I am trying to set reminders for a couple things but they require a time after the dates that are entered in the form. For Example, I need a reminder to send a survey 2 weeks after the customer is invoiced. The invoiced column has a date format 00/00/0000 and the survey box has a combo Yes/No...

I have had to ask quite a few questions in an effort to secure a database for my company. What I am trying to do is make the tables in the database secure but also available to the correct people when they are logged in. The reason being that most of the people using this database are not...

Thank you! I'll try both and see what works best for my company, appreciate the options!

Thank you so much! I will keep looking into the rest, you have been a huge help!

Ok awesome! Any chance you could show me how to make a switchboard? Thank you so much for all of your help!

That's still part of the problem, the owner doesn't want any one to access the tables that have the log in information. I can hide the table links which might work but if there is a safer way to lock other users out that would be the best. Any chance there is a way that when they select the link...

If I hide the navigation pane then my users can't see all the forms though right? Also, there is no option to save it as ACCDE do you have another reference to do that on access 2013? Thank you for all of your help!

I did what you suggested and creating the new links worked but it defeated the purpose. I split the database and put a password on the back end so that if someone logged into the front end they wouldn't have direct access to the back end tables without the backend password. Any other suggestions...

I am trying to find a way so that users who are not supposed to acces the tables on the database cannot get to them. I split my database and put a password on the .be end in the hopes that if they were to select the link for the table (this is if they figure out how to see hidden tables)...

I would but the problem is actually that my users are not savvy at all. The owner would still need to see the navigation pane but our office assistants wouldn't. If there is a way that I can put in a line of code in the login so that when the office assistants log in they cannot open tables with...

I have created a login form and set users with access Levels, ex. 1 - Administrator, 2 - Editor, 3 - Reader. What I am trying to do is see if there is a way that if a user with the access levels 2 or 3 logs in to that database certain tables/information should be inaccessible to them.

You all are the best thank you so much!

Awesome! I created a new type of form and AllowEdits was available. I have set this on my detail view under On Got Focus. If Me.No_Work = True Then Me.AllowEdits = False Else Me.AllowEdits = True End If And when I tested it out it worked! Thank you all so much for all of your help it is very...