Recent content by AccessRube

Hello, I'm working on a vacation/time off tracker and was hoping to use the collect data feature. I've created a form where a user submits their requested date and number of hours, at which point I'd like the form to be sent to their manager for approval. The manager's email address is stored...

Great, thanks Paul, I'll try and work through that.

A lot of good stuff. I apologize though, I'm still a bit green. I have the report that has their schedules, and I understand that I need to put a procedure on the On Load event of that report. I'm assuming I'd want to use my Employee ID for that, without seeing the DB used in the examples I'm a...

On the login form's properties, set Close Button to "No", this will ghost out the red x in the right corner, thus preventing them from just closing your login form and accessing the database. Set the Shortcut Menu to "No", this will prevent them from right clicking on your login form and...

I wish I could help you. I just recently put a login form into my database. I set the close button to no, hid the navigation on the front end, disabled the shift open, and set the shortcut menu to no, so they can't just right click the form and go into design view. I think I have it as secure as...

Are you putting something else in that will lock them out until an administrator allows access? What is to prevent them from simply opening the application again and trying three more times, and again and again, etc.?

Thanks, I'll give those a read.

Hello, I'm relatively new to Access. I was a data analyst for a number of years, primarily on SQL backends. Most of my Access experience is trial and error and help from great sites like this one. Right now I'm trying to develop an event management tool in Access to replace the previous method...

Re: A sorely missed feature I certainly don't speak for all Americans, but I'll feed the troll. I own several guns. Hunting is a storied part of my family tradition as well as our local culture. I also firmly believe in the Second Amendment. History tells us that an armed citizenry is...

Good morning. I have an event planning tool I've developed that I'm trying to add some functionality to. I have a list of attendee's and their schedules in an aggregate query, and then formatted a report based off that query to make it look pretty ;). What I'd like to be able to do is send each...

Please ignore my previous post. After a little thought I added this if anyone is curious. Dim mySQL As String mySQL = "Delete * from tbl_PresentersBundled" CurrentDb.Execute mySQL, dbFailOnError above the "With rsGet" line.

Hello all, I've got a module for sending emails that works fine, with one exception; I'm attaching a few files with MyMail.Attachments.Add, which is attaching the files fine, except it's ignoring the value I pass it in "Displayname", and simply using the entire file name, so...

Hi John, Thanks for the code. I've modified it for my own database, and it's working fine, except that if I try to run it again, I get an error saying it would cause duplicate entries and so on. If it's not too much trouble, could you show me what the code would look like to clear the contents...