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

START UP FORM, PAYROLL AND CURRENCY DENOMINATION

P: n/a
Hello Friends!

I have three questions I wish to ask with regard to some tasks I am
performing in Ms Access 2003.

1. I have a start up form named “Splash” which I want it to load for some
seconds when the database is opened and then to close and give way to another
form called “Loans”. I would not want the “Splash” form to appear again
unless I close the database and re-open it again. How do I code this in VBA
or using Macros?

2. I have a payroll whose orientation in report form is landscape. The
headings are in multiple rows while the data is laid out in several columns
each page. Here is a hypothetical example:

Employee’s Name John Smith Mary Jones
Designation Clerk Typist
P/No. 001 002
-----------------------
Basic Pay 35,000/= 32,000/=
H/A 15,000/= 10,000/=
------------- ------------- -----------
Gross Pay 60,000/= 42,000/=
Less:
Deductions 25,000/= 12,000/=
--------------- ------------- -----------
Net Pay 45,000/= 30,000/=

There are several columns on each page. How do I lay out these.

3. I have a payroll in MS Excel 2003 which I want to transfer to Ms Access
2003. I want to get the MS Access VBA formulas/code for breaking down net
pays into shillings denominations of 1000/=,500/=,200/=,100/=,50/=,20/=,10/=,
5/=,1/=,0.50
Abdallah Khamis Abdallah
Jun 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"ebrainers" <u23345@uwe> wrote in message news:62308ba4ff00d@uwe...
Hello Friends!

I have three questions I wish to ask with regard to some tasks I am
performing in Ms Access 2003.

1. I have a start up form named "Splash" which I want it to load for some
seconds when the database is opened and then to close and give way to
another
form called "Loans". I would not want the "Splash" form to appear again
unless I close the database and re-open it again. How do I code this in
VBA
or using Macros?


Set the timer interval of Splash to, say, 5000 (5 secs). Put some code in
the Timer event to close Splash and open Loans:

DoCmd.OpenForm "Splash"
DoCmd.Close acForm, Me.Name

Regards,
Keith.
www.keithwilby.com
Jun 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.