By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Report - Openened twice

P: 8
Hello!

I have a slight problem with a report.

I have a report which is made from a query (User enters in PersonId) Then it comes up with a payslip. I want a msgbox to appear if the user opens the same persons report twice. Say person id = 1, payslip comes up. Then I want the user to know that they have already viewed(payed) this report.

Is this possible? If so any help is much appreciated! Thank you in advance :)
Dec 22 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello!

I have a slight problem with a report.

I have a report which is made from a query (User enters in PersonId) Then it comes up with a payslip. I want a msgbox to appear if the user opens the same persons report twice. Say person id = 1, payslip comes up. Then I want the user to know that they have already viewed(payed) this report.

Is this possible? If so any help is much appreciated! Thank you in advance :)

Can you post a reply to this thread on Wednesday/Thursday to bump it up the list. It may not get much attention over Christmas.

Happy Holidays.

Mary
Dec 25 '06 #2

P: 8
BUMP ;-)

Any help is much appreciated.
Dec 27 '06 #3

NeoPa
Expert Mod 15k+
P: 31,489
You need to do an update to the record for the system to know when an ID has already been used (for the month/period).
A field would need to be added to the record to 'remember' this. A date field of some form would be best to allow it to work for subsequent periods.
When an ID print is requested there should be code that says :
Expand|Select|Wrap|Line Numbers
  1. Pseudo-code
  2. Update new date field with todays (or this period's) date.
  3. Run report (Generally better to do an actual print rather than a print-preview).
Dec 28 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.