Search results

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...

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...

Hi all, I feel like this is a simple question with a direct answer I'm just not finding. Can I make a button that when I click it, the dates in my database are all updated to the next Monday of the current date. Like today is Thursday the 15th, if I clicked the button the dates would be...

Hi all, I have used this link: access-programmers.co.uk/forums/showthread.php?t=298062 to insert a calendar date picker into my form. What I would like to do with this is use the date picker to run a query using the chosen date to calculate the weeks left until another date. I have a list of...

Good day, I am in charge of creating a company-wide resource database which keeps track of employees, their projects, when projects are due and so on and so forth. I would like to know if it is possible, and how to, add a date picker that would let me know that time left on a given project...