I will be programming with vba in another tool that calls outlook and emails me when done. it works great, but my emails address is hard coded. What I want to due now is pull the report creator name out of the report( did it ) and email them as well. My question is the name of the report creator...
I am looking at use ones joins and see that the person has two joins between two tables. One of the joins is a many to many, and the other one is a one to many. Can you get good results doing that. This is the first time I have seen this type of joining.
hello, I have a table I take order. that table uses item key to look up item on other table. One order might appear twice because two items. this work great for everything i do, but look at orders with same items and different order amounts. I though about decode but there are over 100 itmes...
I Have a report built that I run monthly I have the report write out to and execl file the order numders. I want to use a copy of the file as list of numbers not to pull. I tried importing the file as a datasource but can't get it to be a Charter field to match the other one. Is their a way to...
I'm new to databases, I wanted to known if there is away to create a store proc. that will look at a list table and compare the Order_IDs on this table with new query like this 'give me all order_ids that are not in this table' then fill another table with the results then update the list table...
I have a report that uses two dataproviders one for data the other is excel file. my do not equal to excel file to keep track of things I have pulled. Right now I add to excel file mannually what was in the report that I just pulled. Is there a way to append the data in report to excel file with...
I Wrote some vba code to do everything , but the porblem is it exports into 60 excel files I want one excel file with 60 tabs. Can any one help me.
code..
Private Sub Document_AfterRefresh()
Dim dopDoc As Document
Dim mydopRptAs Report
Dim FilterVar As DocumentVariable
Dim FilterChoices As...
I have a problem. I have a report that has a column with codes(010). I need to apply a filter and make a report for each code. So what I will a report called 010, 020, 030 ect.
Is there a way to do this without doing it manually.
What I want is find out what day something happen on. Example: Date of transaction 07/15/2002. I need to know if that is a Monday, if so turn row red in table. If anyone has any idea how to do this please help.
Thank you,
Dvraggs
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.