Recent content by nagiese

This worked great. Thanks a bunch

I've been asked to pull the last shipment from each location for December of 2012. I have my data by location and date, so how to I write a query that will show only the last shipment date for each location? :banghead: Thanks for all your help :)

I'm sure you can write this all in one module, but I wrote my email code in one module then I wrote another module to make a command button on my form automatically run the email code (see command button code below). SendNotesMail is the name of my module, I'm just telling it to run the code on...

I'm trying to use this same code to auto send an Excel report located on my network each month (ex. Q:\WWC Common\TAMPA Files\ItemIDCount.xlsx). Where do I put in the file address for the attachment? It’s a bit confusing and I'm just learning VB. Thanks for the help.

Thank you, I'll remember that for next post. :banghead:I'm really stuck on this section of the code I hope someone will please respond to my post.

I am an accountant in Nashville TN, and I've been working with access for about 8 years now. I've recently gotten a new job that requires me to develop my skill set and learn SQL and VBA, so I can create integrated reporting/analysis models for our department to improve efficiency and access to...

:banghead:Hello, I am new to VBA and I'm trying to write a VBA Module in Access that runs a SQL query and takes that result and appends it into an existing Excel report. Thus far I've been able to get it paste the data but it puts it in the wrong spot, the correct columns but wrong rows on Excel...

I am trying to write a function in an access 2007 query that will calculate the date range for each of my records based on the month-ending date and the In-transit days assigned to each record (excluding any weekend days) (i.e. if the in-transit days number is 5 & the month ending date is...