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

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Novelist:

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

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 150 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
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:

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,
Yavacotech

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

1 Answer

Hello - We have a Canon Model 3175MS Fax Machine - we want to print a comfirmation that a Fax has been sent. Is this possible? Thanks! Marcy


Yes, it is called a `transmission report' (TX report), and is a setup option.
You can change this setting with the following procedure:
Open the 1-touch panel to access the function keys.
Press the `data registration' key to access the user menu.
You should see `user settings'. Press the `set' key. Press the cursor down key to get to `report settings', and press the `set' key. You should see `TX report'. Press the `set' key. Cursor down till you see `output yes'. Press the set key.
Press the `stop' key to return to the normal screen.
It is now set to print a report after each transmission.

Oct 07, 2010 | Canon LC-3175 Laser Fax

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 http://asktom.oracle.com

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

1 Answer

DB2 Connect and Excel


hi, you can use the SQL Drill freeware addin (http://www.sqldrill.com) It is an addin which lets you connect to ODBC compliant databases (DB2, Oracle, SQL Server etc..)
hth

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

1 Answer

On a Canon MP 460 printer, the paper will not feed in straight causing constant paper jams.


If the paper feed roller is dirty, paper is not fed properly because the paper feed roller slips. Cleaning the paper feed roller could resolve the paper feeding problem. Please follow the instructions below to clean the Paper Feed Rollers directly from the unit.Caution: Since the cleaning process wears down the paper feed roller, perform this procedure only when necessary and no more than three (3) times.
  1. Ensure that the printer is powered on and remove any paper from the Auto Sheet Feeder (ASF).

  2. Press the <Menu> button.

    mp460_copymenu.gif

  3. Use the right / left cursor button to select [Maintenance/settings], then press <OK>.

    mp460_maintenancesettings.gif

  4. Use the right / left cursor button to select [Maintenance], then press <OK>.

  5. Perform the paper feed roller cleaning three times.
    1. Use the up / down cursor button to select [Roller cleaning], then press <OK>.

      mp450_rollercleaning.gif
    2. When prompted to start roller cleaning, use the up / down cursor button to select [Yes], then press <OK>. (The paper feed roller cleaning starts.)

  6. Check if the paper feed roller cleaning procedure resolved the issue.
    1. Load a sheet of letter-sized plain paper in the ASF and open the paper output tray.
    2. Use the up / down cursor button to select [Roller cleaning], then press <OK>.

      mp450_rollercleaning.gif
    3. Use the up / down cursor button to select [Yes], then press the OK button. (Paper will be fed.)

  7. If paper is not fed properly, repeat step 6 up to three times.

Oct 21, 2008 | Office Equipment & Supplies

2 Answers

How to develop a tool for conversion the database from sybase to sqlserver


ahh..sudeep...it 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 | Computers & Internet

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

4 Answers

QUEST SQL Navigator 3.2 with Oracle 10g Fails


I followed the advice given above and copied the ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. copy ociw32.dll ora73.dll
And the software worked immediately.

Dec 21, 2006 | Quest Software SQL Navigator Professional...

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

124 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...