Question about Microsoft Office Standard for PC
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 26, 2011 | Microsoft Office Professional 2007 Full...
Oct 07, 2010 | Canon LC-3175 Laser Fax
Jan 20, 2009 | Microsoft Office Standard for PC
Oct 21, 2008 | Office Equipment & Supplies
Apr 23, 2008 | Computers & Internet
Oct 11, 2007 | Microsoft Office Standard for PC
Dec 21, 2006 | Quest Software SQL Navigator Professional...
124 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: