Thanks. The Snap part works. Perhaps I didn't place the quotes around Snapshot Format. Using acFormatSNP I get a error.
On Q1, isn't the "To" condition after the 3rd comma? (Here is my command so far:
dptsel = DLookup("[email]", "email address"...
I am using a Event Procedure attached to a button on a form. When clicking on the button, the procedure will run. I want the procedure to send a report to certain email addresses. I am using the Docmd.sendobject to do this. Two questions:
1) when you use the command Openreport, you have the...
Thanks Joe
I'm not real good with Code yet so I'm trying to sort through this. One thing that I may not have been clear about and want to make sure this will still work is, the reports I want to send out are specific to each person/location I want to send the report to. Example: Report 1 can...
I am building a macro that will email reports directly to employees using the Send Object command. I have about 4 different documents that I could email at any point in time. The plan is to send each one on its own if the report is selected (potentially 4 emails for each person. Rather then...
I can select the directory where I want the file to export to when it goes throught the export process. Sometimes it exports to this directory and sometimes it does not.
I had recently saw some discussion on using Snapshot. A few weeks ago I found out about this program through this support group and think the program is great. Finally a way to publish your Access reports (so I thought). Things were working great until today when I'm trying to do a new report...
Thanks Paul
That did the trick. I knew there had to be away to use a If statement but I was getting caught up in using the Count function and never thought about a sum function.
Thanks again.
ed
This will work. Unfort. I have 12 column weeks so I will have to put in 12 different fields in the query. Was hoping to have a formula in the report itself that could look at each row under each column and determine the number. Thanks for the suggestion.
I am putting together a report that has the columns: Customer account, week 1 sales, week 2 sales, etc. The customers are grouped based on State. Each customer does not have sales each week (some weeks are 0). In the Group footer I want to be able to count the number of customers in each...
I am currently doing something simular. What I have done is set my report to use a query that prompts for a location number that the report is to be based on. I then set up a macro that has a macro name for each location. I have entered 2 command lines for each location. Line 1 is a SendKey...
Interestingly, I'm trying to do the same thing with the page numbers. I have put the code in as indicated in the article but cannot figure out what I need to put into the Page footer to show the actual page numbers. Should there be a text box and if so, what do I put in the fields to reference...
Why don't you just set up your form the way you want it in Excel (including any calculations you want to do) then use the "Get External Data" function in Excel to pull the data from Access into your excel table. You can even set up a macro in Excel to run all the updates for you.
I need to have a report that is like a customer order where the page is split in half. The bottom half needs to be an exact duplicate of the top half. This will be printing to a preprinted form so the fields have to stay in the exact place. The number of detail lines on each report can vary...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.