Question about Microsoft Office Standard for PC

1 Answer

MS ACCESS i do not how to write a code in MS ACCESS to create a bank pass book in MS ACcess

Posted by on

  • Anonymous Feb 15, 2008


    I am designing a report , pls help me to make a function statement or event procedure for “ECIP” from the following data:

    StaffA:1%Salary=192.35, ECIP=100

    StaffB:1%Salary=202.08, ECIP=100

    StaffC:1%Salary=89.53, ECIP=89.53

    StaffD:1%Salary=77.24,ECIP=77.24

    so that when i generate a report, the value of ECIP should appear as above. Hope you could help me on this right away. Thanks.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to Evaluate the rows in MS Access

Posted on Feb 05, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Log in to online banking


You'll need to contact the bank for help.

Feb 05, 2014 | Cars & Trucks

1 Answer

Want miniproject using javascript & msaccess


Hi
I need the mini project in html & java script with back-end
Ms Access
Kindly help me

Dec 11, 2011 | ArcMedia JavaScript Source Code 3000 Pro...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-


1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

1 Answer

How to make the library managment project with VB.Net & using MS Access as for database.& please help me out what code should I use for making that project?


firstly you have to create a database and in that you have to create tables as per your requirement.
secondly, create forms in vb and connect the database, as per your requrement. it is not possible to give all the codes. use some e-books.

Nov 19, 2009 | Computers & Internet

1 Answer

How to create a program using ms access?


access has a complete tutor built in id do the course press F1
and ask.

hope this helps

Dec 13, 2008 | 2001 Ducati 996 R

1 Answer

How to create a program using ms access?


you need to study the basics of database programming. take short courses for database programming.

Dec 04, 2008 | Microsoft Access 2002 for PC

1 Answer

How to create database in m.s.office


you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.

Nov 28, 2008 | Microsoft Computers & Internet

3 Answers

Connectivity between HTML page and Ms-Access


<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

Nov 11, 2008 | Microsoft Office Standard for PC

2 Answers

Help MS Access 2007


There are several books out there. Take a look at amazon.com and you will see several solutions. most of the books are very informative and will help you get started.

Jun 29, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...