Re: Appending monthly data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Freeman (spam_at_microsoft.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 11:18:15 -0800

Two things spring to mind:

1) Make the last line of the command button's click method
this.Enabled=.f. -- in other words, once they've run it once, turn it off

2) Getting a password is as easy as calling InputBox(), although it can be
done in other (more robust) ways.

Dan

Dan Williams wrote:
> I have gone as far as I can with the limited abilities I have.
> I have everything working the way I want, but here is the trouble.
> I collect the data, and save to tables, and poplute a report with the
> data. I give end use the ability to run this via a form, with a
> command button that makes it all happen.
> Problem is, if they click the button twice, or three times, it does
> what it is told to do in that it appends the data, however this is
> not good. It should only be allowed to append that data the one time.
> The only work around that comes to mind is to create a sub
> administration form that an admin would go to and execute the code.
> This is one spot that would be a big help to have the ability to
> force a password for use of a "command button"
> Dan
>
> "Dan Williams" <dan@willcraft.com> wrote in message
> news:111ndrifad09k2c@news.supernews.com...
>> Hi,
>> I have created a "remote view" to grab some employee data from our
>> AS400 just before we process payroll (once the process payroll
>> procedure is run, this data is no longer available on the AS400).
>> I would like the ability to have this info show in a table, all 12
>> months. I am guessing I would create a table that would hold this
>> data, but do not know how I would automate getting the remote view
>> to populate this table. I would then like to design a report that
>> would show the employee the current info, and the past info.
>> Where I am at with it now is I have the remote view working, getting
>> the current info, and a report reporting that current info, so I am
>> part way there, just need to learn how to collect and record the
>> historical data. Dan

Relevant Pages

  • Re: Appending monthly data
    ... I agree with Dan Freeman. ... I disable all of my command buttons on ... enable them when the report is done. ... > I give end use the ability to run this via a form, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Double criteria ???
    ... Dan ... > Each query requires it's own parameters. ... > When ready to run the report, ... Click the command button and the ...
    (microsoft.public.access.reports)
  • Re: Double criteria ???
    ... Dan ... > Each query requires it's own parameters. ... > When ready to run the report, ... Click the command button and the ...
    (microsoft.public.access.reports)
  • Re: [SLE] ls -l
    ... And when you follow everyone's advice about using the "du" command, ... There are many options for changing this, including the ability ... to report the number of bytes directly (by telling it to report the ... Randall Schulz ...
    (SuSE)
  • Re: Prevent Deleting of Spool Files
    ... Instead of the audit report printed out all the time, I have set the environment to send the report to an outq, but our ERP software uses 'wrksplf' command that allows user to press the button and see all their 'submitted' reports. ... Is there a way to revoke a specific ability from a user such as he/she can View/Display their spool files, but not able to delete them? ...
    (comp.sys.ibm.as400.misc)