Question about Microsoft Office Standard for PC

1 Answer

Ms access is it possible to write procedures in ms access , like cursors,procedure in oracle? if yes please tell the way

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 150 Answers
Re: 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 ...

Posted on Nov 24, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

2 Answers

Am trying to use my brand new microsoft office 2007 but it keeps telling me my product key is incorrect what should i do next

You will have to call the Microsoft Product Activation Center at 888-725-1047.
You will be asked if you are at your computer with the activation window open - respond with "YES" your will be asked for your activation I D - respond by saying "HELP", the message will repeat, respond by saying "TRANSFER" - continue to respond with "TRANSFER" until you hear "If you wish to talk with a specialist say transfer" again say "TRANSFER". You will then be asked if you have the activation wizard up on your screen - respond with "YES". Finally, you will be transferred to an activation specialist. You will have to tell them what happened to you original product key (lost it, accidentally destroyed etc.) and you will have to tell them why you need the key. (Hard drive crash or whatever). They will NOT give you a replacement key if you tell them that you need it for a second computer - your are only licensed to use the key on one computer at a time! he may ask you for numbers printed on the CD . He will then tell you what you have to do to order a replacement product key.
You can also request a replacement product key from Microsoft Sales by calling 800-642-7676 and asking to speak to tech support.
If you have any additional questions contact me by clicking on the "Add a comment" link located under your problem description on FixYa. Also, if you believe that this information was helpful to you, please rate my solution using FixYa's "Solution Helpful" rating scale.
Best regards,

Feb 26, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

What is a .sdf file? How to generate a .sdf file using ms access? , you will find here info about a .sdf, it has more meanings

Oct 28, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Oracle ODBC connection shows no tables in Crystal Reports, procedures only. I used to see them, but no longer. I can in Access so I know it is not the ID.

i am also experiencing this problem. what i did was i created a new file in the repository folder (in crystal, when you create a new connection), containing the script that will pull all of my needed data.

Aug 31, 2009 | Crystal Decisions Crystal Reports Server...

1 Answer

How should i connect html page to MS Access

You have to create adodb.connection to connect the ms acesss database to web page

Jan 20, 2009 | Microsoft Office Standard for PC

1 Answer

Loading images into Oracle database

You need to use a blob or cblob field to store a jpg file in Oracle

see this site

Jan 14, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

2 Answers

Steps in saving file in excel to database

severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

DB2 Connect and Excel

hi, you can use the SQL Drill freeware addin ( It is an addin which lets you connect to ODBC compliant databases (DB2, Oracle, SQL Server etc..)

Dec 03, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

2 Answers

How to develop a tool for conversion the database from sybase to sqlserver is a truly glorious day for this work. The detailed solution is to call Larry Ellison, at Oracle, and enquire if you can have his code.

Apr 23, 2008 | Business & Productivity Software

2 Answers

Ms access to excel

I do this on a routine basis.
In Access select the table or query that you want to convert to Excel.
Then File, Export,
You then will see a Dialog Box that allows you to select the format and file name.

That procedure can also be performed using Access Macros for an automated solution.

Hope this helps.

Oct 11, 2007 | Microsoft Office Standard for PC

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

120 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides