In both the GL system and Cognos Finance accounts have a user defined attributed called “CashFlowCD” or “Cash_Flow_Code,” respectively, which is assigned when an accountant creates the account in the GL system. The value of the Cash_Flow_Code is received in CF during the normal update routine...
Working on executing a DTS package from ADP. Using the VB file generated by enterprise manager, importing that into an ADP module. Reference thread958-848668
The package picks up a flat file on C:\ and appends it to an existing table on the server. The process executes but terms with the...
Friends - I knew once I posted a question it would all come back to me.
For those who need the insight:
(1) From the Modules menu list, select Tools > References...
(2) Scroll through and select Microsoft DTSPackage Object Library. Then OK.
Building from p27br's thread "Execute a DTS package from VBA" originally posted on 05/26/2004:
Where or how in the ADP module do you include the reference to Microsoft DTSPackage Object Library?
thread958-848668
I am receiving the following message when attempting to execute a database:
The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exists and that you spell its name and the path name correctly.
I'm not sure what has happened or how to correct as I was...
I need to link two tables where case sensivity is essential. The query executes properly using the following SQL:
SELECT StrComp(tblCode!code,tblCodeRevenue!RevenueCode,0) AS Expr1, tblCode.code, tblCodeRevenue.RevenueAmt
FROM tblCode LEFT JOIN tblCodeRevenue ON tblCode.code =...
In Visio 2002, the max cell count available is 16. While I'm not necessarily using the Vtable for it's true use, it is serving a perfect purpose in my database diagram. Is there a way I can change the cell count in excess of 16 (say 28)? In 'Define Custom Properties' I've modified the...
Can anyone advise more on this particular error msg:
Cannot open a form whose underlying query contains a user-defined function that attempts to set or get the form's RecordsetClone property. (Error 3252)
It occurred after I processed a report and then attempted to export it as a snapshot file...
I presently have a subreport nested in my (primary) report's footer section. Is there a way to suppress the (primary) report's page header from appearing on and overriding my subreport's page header?
Thanks!
- Tony -
I'm having a ridiculous issue.
I can't seem to get this to work in Access 2002:
E.g.,
If BlankReport = True Then ...
Else...
End If
It errors on the BlankReport wanting it defined. Did the report property change? I can't find anything in HELP besides the On NoData event.
Thanks!
- tony -
Curious...
Rather than have a report email itself to a recipient, is it possible to have it post itself into Outlook's public folders? I haven't found any reference to such as of yet.
Any guidance is appreciated!!! No urgency on this issue.
Thanks!
- Tony -
Has anyone encountered an issue where if you do sendobject report via a macro you have the option of outputting the report as a snapshot (*.snp) but if you do the sendobject via code *.snp will error?
Also, anyone know where I can find documentation on using sendobject report output to *.pdf...
The code below is processing report and then emailing automatically as defined in a table tbl_Email.
The first entry in the tbl_Email is executing correctly. Subsequent entries are emailing but are processing under the first entry's parameters. It appears my rst.MoveNext isn't working as it...
Tony,
Thanks for the immediate feedback! Your suggestions couple with information I found in thread 68-566499 (ensuring the latest Microsoft DAO library is active and has a high priority) my code Finally works!
Thanks so much!
- Tony -
(Yes, my name is Tony, too)
I'll first admit that I'm not literate at code writing. I've found an older database where the following code worked and I copied and updated it to meet my needs. However, I continue to get the error "user-defined object not defined" for
Dim dbs As Database
My entire code is below...
Using Access 2002, I'm generating a couple hundred reports that are to be emailed to company agents (controllers, etc.) every month-end. I've written the code in access to automate this process so that I don't have to manually perform each function; I can kick it off and go home for the...
Using Access 2002, I'm generating a couple hundred reports that are to be emailed to company agents (controllers, etc.) every month-end. I've written the code in access to automate this process so that I don't have to manually perform each function; I can kick it off and go home for the...
There's an annoyance I need to surpass.
When I send a report to adobe, I do not want to view the PDF results.
Even though I've used printer setup>properties to establish my preference, Adobe still executes and shows the PDF file.
In addition to the simple code below, can someone help me...
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.