Search results

I have a function that allows me to add to reports to an email as attachments. However, the report automatically sends. I really want the code to attach the reports to an email but not send it so the user can enter the addresses, as it will vary by Region. Can someone help me with this? Public...

What if you do not want the email to send. Just open with the attachments entered. I want the attachments to automatically embed and give the user an opportunity to review before actually sending. I am attaching 2 reports separately in the email which is why I would prefer not to make the user...

Recordset Overflow Rather than trying to update a table through the form, I would rather just calculate all the information when necessary. However, I am getting an overflow error with this code. I am trying to calculate the future weeks for a project and then move to the next one and repeat...

Forecast Figured out I finally figured it out. I decided to create a permanent table and house the forecast there. Anytime a key field is updated on the bid form, I will have all of the previous entries deleted with a delete query and the new figures entered. So everytime the start date...

Basically, there are a certain number of boxes per unit. That is the number actually displayed on the graph. However, I can figure that out later once I have the units forecasted properly. The graph is designed to sum all of the units scheduled to deliver through a week-ending date. That's the...

Forecasting Ok. I think I know what I want to do, I just don't know how to do it. I was able to create a query that displays the project, project start date, no of units bid, no of units to deliver each week, and calculate the project end date based on the results of no of units/no of...

Thank you Any info you can provide would be greatly appreciated. I can't seem to wrap my head this query. Bozeman is about an hour away Helena. It's actually more of a yuppie town than a bunch of cowboys. It's a big college town so college girls should be in abundance! Good luck with that...

Bid Sample I am attaching a sample of what I am using. If you run the report through Fiscal April of 08, you will see that it generates 8000 cabinets for week ending 4/1. I need to actually need to forecast out the weekending dates for the unit to ship each week. for example Project Start =...

I am drawing a blank on how to proceed with this requirement and was hoping someone out there could help me. I am creating a graph that shows all of the orders we have taken, shipped, and what we have bid on. There is a table that holds the customer, no of units ordered, no of boxes per unit...

I have been surfing through all the topics on this subject and can't seem to find the right information. I found a post that demonstrates how to create an email from Access that automatically sends. This work great for me. The problem I have is that I want to copy and paste information from a...

I have been rummaging through a variety of posts regarding the transfer of data to an Excel spreadsheet. I found some code that works fantastically to export the form information to specific fields on the spreadsheet. The problems is that in the middle of my spreadsheet I have a range of cells...

I have a form that allows the user to print a report for each installer automatically. It prints to the default printer. The problem is this crashes if one of the installers doesn't have any data. Private Sub Command45_Click() Dim ctr As Integer With...

Thanks Bob. But I think may be I was clear in what I was looking to do. I want to print a separate report for each installer in the combobox. I want the user to be able to specify one installer and print the report or just choose the Print All and have it loop through each installer and print a...

The combobox is based off of this: SELECT [tblInstallers].[Installer] FROM tblInstallers WHERE [tblInstallers].[Location]='NV Field' ORDER BY [tblInstallers].[Installer]; How could I loop it through the table/query?

I have a combobox with the list of all of our installers. I have a report setup to display statistics for whichever installer is selected. I would like to have a Print All selection that will rotate through each person in the list and print the report automatically. I know I can do this by...

I have a form with alot of checkboxes. Users enter problems found on job inspection. I have added a checkbox called NoProblems. If there are no problems found, that box should be checked. When the user submits the information, I need to form to see if any of those boxes are checked, if not then...

My Visual Basic code is just going crazy. The database has been working fine until this week. Just about every time I run a report or a form I get compile errors. It says method or data not found. I look at the code and anything that is Me.field is erroring out. Yet the field is on the form. If...

That worked great!!!! Thank you so much!!! :D

An order looks something like this: Job Phase Unit Dr Style PreFin Species DelDate WOSD GDS 1 29 FALCN BR28 SWM 4/4/07 (MOD generated) This unit has a FALCN door which would take 6 days to build. However, it also has the prefin of BR28 which takes 7 days to...

I created a module to generate the correct date to begin manufacturing. There are two sets of criteria. If the job's prefinish is a certain code then manufacturing takes 7 days. If the job's door style is a certain code then manufacturing takes 5 to 6 days. Otherwise the date range is 4...