Recent content by HangoutGuy

Is there any reason why my button just started working when I started up my db again? Because now I'm having no problems and I didn't change anything or even compact & repair for that matter. And this wasn't the first time I shut it down and reopened it.

Now I think this might be where the issue lies. So I wrote all the code in the VBA window that pops up after I hit design view on the form where the button is. Then I opened the property sheet for the button and under "Event" and "On Click" I hit the ... box that opened the VBA window. I did...

Okay something really weird just happened. I closed down my db and opened it again and it just worked without my opening the VBA. This is so odd.

Sorry but posting bits of text and code is about all I can do, I am a lowly intern and I don't want to accidentally make a major screw up. I am happy to answer as many questions as you're willing to ask and I will do my best to answer them with my limited access knowledge. I appreciate the...

Actually I have been running into issues with security and outlook as well due to lock down. The button is supposed to automatically send the email but when it works correctly it only opens outlook with the prewritten email and only sends with the user clicking the send button. I know this...

I do not. Not everything in the db should run upon opening. Is there a way to AutoExec the VBA code to open and close on startup?

I'm a bit confused because the code itself isn't causing the error, it runs perfectly fine. It just doesn't work when i click the button after first opening the db. But if I simply open the code up and close it the button works. This is why I'm baffled because the code works but only when the...

Private Sub Command58_Click() Dim dbs As DAO.Database Dim rsEmps As DAO.Recordset Dim rsPrj As DAO.Recordset Dim strEmpQry As String Dim strPrjQry As String Dim strTo As String Dim strSubject As String Dim strMessage As String '-- Query for the...

Hi all, I am having this odd problem that I really don't understand. I have a button that when clicked it runs some code that I have written that builds an email out of the data in my db. When I first open my db and click the button I get this error: "The expression On Click you entered as the...

Hi all, I have 4 different queries that I want to build 4 separate reports of, one for each. Each query has all the same fields save for different locations, hence why I need 4 reports to send to the 4 locations. I have spent a long time getting all the spacing and lining up to what I want and...

Hi all, I've been having this issue for sometime now and I'm not even sure if there is a workaround. I have an employee table with names, addresses, emails etc. and I want to be able to send out an email to each of the 180+ employees about their project details. My VBA code is working...

Yes, but I seem to have figured it out after playing around with Group & Sort settings.

Hi all, I'm having a slight issue with a report that I would like to be able to save as a PDF. When I run the report in report view, everything looks just how I want it. For instance an Employee is listed with their location and their projects they work on. If they work on more than one...

Hi all, I was wondering if it were possible to make a calculated field or a query that will take all of an employees certain record and sum them all into a total that will be its own column. For instance Employee 1 is working on Project 1 and Project 2 both with a 50% dedication of service to...

Yes I realize there are far and away better approaches to what I am currently doing. This is my first access database that I will be building and I just need the simple work arounds to get done what I need done.