Recent content by Summit

Thank you for your feedback, this is my first serious project. The one I did before was to track uniform marks (in a cadet program) and display that information in graphs, etc all which was navigated through forms. There were some automatical recalls so we could follow up with issues. The...

Hi Folks, Haven't posted on here in a while, but I've started my second database, but I think I'm way over my head this time. I'm hoping that someone could let me know if what I'm doing is far beyond my skill level, or even possible in Access (using 2010). I have attached the database incase...

Alright, awesome. I'll take a look at it later this week. And again, that you very much for the help, I do appreciate your patience, especially since I am new to all of this.

Yes the query does give the desired information. Below shows the Form that I am talking about, and the query it is based on.

I'm trying to read that link, I understand some of it, but I don't think I'm wrapping my head around it. If I am reading that correctly, the link is talking about emailing reports. The way I have it set up at the moment, is that an internal database alert pops up on start up if there are...

Thanks, I'll take a look at that. I am incredibly new to VBA and coding in general. This database (which is my first database) is my first attempt at any sort of coding and I am trying to wrap my head around it.

Perfect, worked like a charm. Thanks!!

Now from what I've read, I know that Access cannot actually completely automatically email people. If I have to press a button for these emails to go out, that is fine. Basically, a user will enter observations about someone, and there is a field on the form to enter who made the observation...

Thank you very much that worked! How come after update worked and lost focus did not? And one more question. What would the code be for if the password is incorrect, clear the text that was entered into the textbox. And I'm assuming this code would be placed after "else" in the code above.

Hi all, I get this error 2585 This action can't be carried out while processing a form or report event. This happens when I enter a password into my form in order to open any other one. When the password is correct, I want it to open an administrator form, close the form (Main Start) which has...

Forgot I had to close another form when the password is correct so that is reflected in the code below. Also I changed Menuboard Password to Menuboard Login. I am still unable to close "Menuboard Login.". Private Sub txtPassword_LostFocus() Dim PassWord As String strPassword = "12345" If...

Thank you very much, that code is working almost perfectly. The close form command is not working however (the form to close is actually named Menuboard Password). I'm getting error code 2585. Also, I put the code on event lost focus Private Sub txtPassword_LostFocus() Dim PassWord As String...

I just started experimenting with access this year and am still trying to wrap my head around coding so I could use a little help if you don't mind. In my database I have the navigation bar and the ribbon hidden so it looks a little more user friendly for those who use it. I have an...

Ahh ok that makes more sense now. I've also been looking into Sharepoint 2010, and I do have it on my computer. I will do some more research, and I will talk to my coworker and discuss what we want to do. If it becomes too much for me to do, perhaps I'll seek out professional help (do you happen...

Hello, Made it into a web database with a bunch of changes. The new data entry form is not complete as it doesn't actually enter any data yet.