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