Re: Anyone done this before???

2010-05-08 Thread Maureen
You can do this easy in .NET using doCMD. The is a good article on it here. http://support.microsoft.com/kb/317113 I've never tried it in Coldfusion but I would think you could write an Access macro to load a report menu and call Access with CFExecute with the name of the macro appended. You

Re: Anyone done this before???

2010-05-07 Thread Claude Schnéegans
>>how the heck can I get this to run online??? Reprogram the whole report in CF. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusio

Re: Re: Anyone done this before???

2010-05-07 Thread denstar
Maybe it could be done using a scripting tool like powershell, if there's no way to call an ocx deal or whatever? :Den -- Whatever universe a professor believes in must at any rate be a universe that lends itself to lengthy discourse. A universe definable in two sentences is something for which

Re: Anyone done this before???

2010-05-07 Thread Stephen Hoskins
Language in the report. Are you the Professional CF consultant William? If so, do you know how to pull up reports in access without rewriting the report? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/A

Re: Re: Anyone done this before???

2010-05-07 Thread William Seiter
I am confused as to what language they changed on you? the database? the report scripting language? the web server language? as far as pass the id, it will all depend on what your system actually looks like and what you are trying to accomplish. I would suggest that you give us a longer, mo

Re: Anyone done this before???

2010-05-07 Thread Stephen Hoskins
There are about 5,000 reports with conditional statements in VB script. I started creating pdfs and was going to use cfdirectory to parse through them. After spending a day creating 1,000 of them manually, they changed the language on me. Im suprised there isnt a way to pass the id and pul

Re: Anyone done this before???

2010-05-07 Thread William Seiter
Having very little knowledge of MS Access for the web, can you have the report output to a static table, where the web page reads the data from the table, and the report runs hourly, or more/less often? Or, can you port the report functionality to a 'view' and have the web page read its data f

RE: Anyone done this before???

2010-05-07 Thread Eric Roberts
: Anyone done this before??? Nope. What I would do is convert the report to a webpage and pull the data from the db. -Original Message- From: Stephen Hoskins [mailto:shosk...@andonia.com] Sent: Friday, May 07, 2010 12:17 PM To: cf-talk Subject: Anyone done this before??? I have a pretty

RE: Anyone done this before???

2010-05-07 Thread DURETTE, STEVEN J (ATTASIAIT)
Nope. What I would do is convert the report to a webpage and pull the data from the db. -Original Message- From: Stephen Hoskins [mailto:shosk...@andonia.com] Sent: Friday, May 07, 2010 12:17 PM To: cf-talk Subject: Anyone done this before??? I have a pretty complex MS Access report th

Re: Anyone done this before?

2006-05-11 Thread rhymes with 'loud'
>We want to start auditing the database changes made in our home grown >CMS app. Anyone on here done this or have suggestions on where to >start with some thing like this? > >-- >Phil Hi Phil. I work with a homegrown audit system that does the job pretty well. There exists a single table (Audit

RE: Anyone done this before?

2006-05-11 Thread Jeff Garza
- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 11:41 AM To: CF-Talk Subject: RE: Anyone done this before? You can do this with Transact SQL as well (SQL Server). I've setup triggers to monitor specific fields, or you can just store a record for any change on a

RE: Anyone done this before?

2006-05-11 Thread Munson, Jacob
You can do this with Transact SQL as well (SQL Server). I've setup triggers to monitor specific fields, or you can just store a record for any change on a table. Email me off-line if you'd like some code examples. > -Original Message- > From: Turetsky, Seth [mailto:[EMAIL PROTECTED] > S

RE: Anyone done this before?

2006-05-11 Thread Ian Skinner
Well u don't want to slow down the db by keep all the old data in there, which will have to be searched through in your queries. So prob best to copy out the data to another table or even another DB when it is changed. If you have a sophisticated enough database, this can be done inside the da

RE: Anyone done this before?

2006-05-11 Thread Turetsky, Seth
: CF-Talk Subject: Re: Anyone done this before? That would have been a better way of putting it. Yes We want to track the changes made in the database. We would like to keep it indefinitely. On 5/11/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > By auditing, do you mean tracking changes? I

RE: Anyone done this before?

2006-05-11 Thread Snake
t: 11 May 2006 17:42 To: CF-Talk Subject: Re: Anyone done this before? That would have been a better way of putting it. Yes We want to track the changes made in the database. We would like to keep it indefinitely. On 5/11/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > By auditing, do you

RE: Anyone done this before?

2006-05-11 Thread Ben Nadel
whunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 12:42 PM To: CF-Talk Subject: Re: Anyone done this before? That would have been a bett

Re: Anyone done this before?

2006-05-11 Thread Phill B
That would have been a better way of putting it. Yes We want to track the changes made in the database. We would like to keep it indefinitely. On 5/11/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > By auditing, do you mean tracking changes? If so, how long do you need to > keep the old data for? > >

RE: Anyone done this before?

2006-05-11 Thread Ben Nadel
By auditing, do you mean tracking changes? If so, how long do you need to keep the old data for? ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bow