Search results

I found my answer from a 2010 post from Rural Guy who posted the following link http://www.granite.ab.ca/access/email.htm Thanks RG

I want to do it from the Excel Workbook (Assignments) it is stored in using a command button. I already have a button that sends a separet workbook via outlook with the code below. but I can't get it to send one sheet from the active workbook. Sub SendWorkbook() Range("B12").Select...

I need to Email a single Excel worksheet (Status) from a multi sheet workbook (Assignment) as a PDF attachment to multi recipients. Any ideas?

When using the Report Wizard their is a box with fields on the left, arrows in the center that allows you to move the fields from the left to the right so you can use them to build your report. What is that box called and can you build one in Access? I don't have a project for it yet but...

AccessMSSQL, The single quotes worked Thanks VbaInet, Got it working. just needed to join them by BatchType

I've tried that before and it does not work. The sum of AMB between 1/1/12 and 1/8/12 is 208 not 1034. Also I need the sum of BatchTypes not batch names. When I remove BatchNames from the query I get what I need as far as BatchTypes for each Date period but the sum of BatchTypes for...

I forgot the attachment

Ok I will try and be clear. My tables/Queries are attached ProductyRpt FromDt - Date field ToDt - Date Field BatchType - Text BatchProd IndexDt - Date (Yes, this is a date) BatchType - text NumBatches - Numeric BatchProd is acutally a simple query of tables Productivity and BatchCtrl...

Now I think your F***ing with me Thanks for not helping

ProductyRpt FromDt - Date field ToDt - Date Field BatchType - Text BatchProd IndexDt - Date BatchType - text NumBatches - Numeric I need to sum NumBatches for each batchType that falls between FrmDt and ToDt.

I'm trying to sum the number of batches by batch type in table B that fall between the From and To dates of Table A

I've tried the links again and attached is what I get

Tried re-naming all my Dates, nothing. Also my first choice was to display my results in a query but I can't figure out how to calculate it.

I couldn't get it work. I keep getting an data type mismatch error calling it from a query

I have 2 tables like this TableA FromDate ToDate BatchType TotalBatches TableB Date BatchType NumBatches Is their a way to update the TotalBatches in TableA with the sum of NumBatches from tableB that have the same BatchType and falls between the FromDate and...

I get a Excel report each month with a cell that contains "01/01/12-01/08/12". Is there a way to add this into a table and split it into two different fields(From, To)?

Thank you, It was exaclty what I wanted

I'm looking for a way to create a Userlog that track a users actions while in the application. I have a table with the following fields UserNam Date/Time Action When a user logs in, I want to fill the fields that they logged in. When a user click to search, I want to log that they...

Thanks All, I've tried Forms and Queries and it is best way to go

Thanks but that didn't do it. I haven't done this since DBaseIV. I want to assign a file location for medical images. I have two fields. a Box number and file number. I want to reset the File number each time we start a new box.